| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Hi
<0> I have configured MySQL replication but when doing "LOAD DATA FROM MASTER;" it complains about the information_schema table (with those metadata data).
<0> Can't create database 'information_schema'; database exists
<0> What should I do to circumvent replicating this database ?
<1> replicate-ignore-db
<1> mabye
<1> maybe
<1> replicate-do-db the ones you want
<2> replicate-wild-do-table=go.%
<2> replicate-wild-do-table=zones.%
<2> slave-skip-errors=all
<2> those are the ones i use
<3> hello. "select distinct extract(year_month from FROM_UNIXTIME(time)) from comentarii;" will get me the months I have in the DB. how can I get a count of all the entries next to that ?
<0> Trying.
<2> select extract(year_month from UNIX_TIME(time)) as m, count(*) from comentarii group by m;
<3> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(time)) as m, count(*) from comentarii group by m' at line 1
<2> select year(curdate()) as y, month(curdate()) as m, count(*) from comentarii group by y,m;
<3> yes, but I'm intrested in all the months, not just current.
<2> that's an example
<2> modify it
<2> instead of curdate use the column
<0> Ok, it's not giving me the information_schema issue anymore.
<0> progress!
<3> ok. i'll try.
<1> slave skip errors doesn't sound like a good idea
<2> ya it does
<2> for my stuff it works great
<1> so you don't care if you have the same data on the master and slave?
<2> doesn't even apply
<2> the errors are created from non-existent tables and what not
<0> Where would there be a logfile ?
<2> not the replicated tables
<2> forgetting to run sql_log_bin=0
<2> airox, show variables like 'data%';
<2> look at data_dir
<0> I'm in the data dir.
<3> "
<3> select year(FROM_UNIXTIME(time)) as y, month(FROM_UNIXTIME(time)) as m, count(*) from comentarii group by y,m;
<3> thankyou :)
<4> how can I change the field name of an object in a table?
<2> !man alter table
<5> (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<4> im looking at that exact page...
<4> i keep making bad syntax though
<3> jeffzz any tips on excluding the current month from that list ?
<2> Snus, where clause
<3> where time != month(curdate()) ?
<6> hi
<0> hello
<3> select year(FROM_UNIXTIME(time)) as y, month(FROM_UNIXTIME(time)) as m, count(*) from comentarii where extract(year_month from FROM_UNIXTIME(time)) != extract(year_month from curdate()) group by y,m;
<3> found it :)
<0> root1: You better not be IRC'ing as root.
<0> ;)
<6> does anyone please know how to link in a library in borland builder 6? i have all the libraries in the lib directory and it still keeps giving "unresolved external..." errors
<7> can anyone suggest some steps to follow as to why ndb would not get past the 'starting' phase?
<8> !tell me about join
<5> But I don't know a thing about that.
<8> i want to do a join on two tables where there will always be exacly one row that matches, which type of join would be fastest?
<8> nevermind, INNER JOIN sems to be best
<9> does anyone know of an executable installer that bundles PHP 5, Apache, MySQl and PHPMyAdmin?
<10> hi all...
<10> is there a log of attempted connections to mysql databases?
<11> Is anybody available to help me solve a difficult MySQL problem? We can pay you a fee, but you first have to convince me that you are likely to help us resolve the issue.
<12> timkay: we don't do fees in here.
<13> spundun: I think only if you enable the general query log.
<3> IamEthos http://en.wikipedia.org/wiki/LAMP_(software_bundle)
<12> timkay: if you want to pay somebody, pay MySQL AB
<11> ok. sorry
<13> timkay: try your question anyway and see what you get?
<10> TodoInTX: how do I do that? I am on debian
<12> timkay, no need to be sorry. TodoInTX is correct too.
<14> can someone please help me with this error ive been struggling with all day: ERROR 1005 (HY000) at line 861: Can't create table './mydb/update.frm' (errno: 150)
<13> spundun: just add 'log' to the [mysqld] section of my.cnf and restart.
<15> 1perror 150
<15> !perror 150
<5> MySQL error: 150 = Foreign key constraint is incorrectly formed
<10> TodoInTX: ok lemme try
<14> SHOW INNODB STATUS shows an Fkey constraint, but i have disabled fkey checks in the SQL
<11> Ok. I wrote up the problem here: http://www.writely.com/View.aspx?docid=baccf6xnntdtb
<13> spundun: it will make a log in your datadir that is named host.log
<10> TodoInTX: actually my.cnf had a commented line about log I just uncommented it, I think it will log at /var/log/mysql.log
<11> Julian|Work: Ok. I am happy to pay MySQL AB. Let's see what this group thinks about my problem first.
<10> TodoInTX: also warned me that log is performance killer :)
<13> yes it is.
<12> timkay: any indexes?
<10> TodoInTX: oh.. and how do I make sure that the server is accepting connections from outside?
<11> Julian|Work: sure, I've indexed it, I've done "explain"
<12> Prepending "EXPLAIN" to the query and running it will break down how it's being executed, and help you optimize it.
<12> Ah
<13> spundun: you can check netstat.
<12> timkay: may want to include 'rows returned' in your table.
<11> Julian|Work: I have used straight_join and specified indexes explicityly (force index)
<16> Is there a way to refresh the table info cache in the command line client?
<11> Julian|Work: The number of rows is proportional to the number of hours
<12> timkay: I won't say I'm an expert though-- sounds like you've done everything I would.
<11> Julian|Work: a 24 hour query should return roughtly 24x as many rows as a 1 hour query
<12> timkay: alright
<10> TodoInTX: what port am I looking for?
<12> That seems very inconsistent then.
<13> 3306
<12> Which version of MySQL?
<11> Julian|Work: I saw the problem years ago on 3.x. Recently, we have the problem with 4.x and have confirmed it is still there in 5.x
<12> timkay, so even when fully indexed, you're getting the same results?
<11> Julian|Work: yes. I can talk you through how I expect it should handle the join, if you like.
<11> Julian|Work: I have tried numerous different indexes and manual optimizations.
<10> TodoInTX: its linstening to localhost.localdomain:mysql (according to netstat -l) does that mean it will accept connections only from localhost?
<12> Ah, I don't really have the time to put in. It sounds like you've reached the limit of my knowledge.
<12> Hopefully you get a guru here-- otherwise, MySQL AB is capable.
<13> spundun: yes
<11> Julian|Work: explain shows that the bad behavior happens when the optimizer changes the order of the join
<10> hmm :(
<10> is that also a setting in my.cnf?
<13> spundun : you may have a directive in /etc/my.cnf to sets the ips to listen on.
<11> Julian|Work: however, when I put the straight_join option and join in the right order with the right indexes, the keylen column shows that it doesn't use the full compound index
<14> !perror 121
<5> System error: 121 = Remote I/O error
<5> MySQL error: 121 = Duplicate key on write or update
<10> TodoInTX: in my.cnf bind_address is set to 127.0.0.1 .... should I change that?
<13> spundun: if you want it to listen to external connections you do,
<6> does anyone know how to link in a library in borland builder 6?
<13> spundun: 0.0.0.0 will set it to listen on all your server's IPs.
<13> or comment it out and it wil do the same thing.
<10> TodoInTX: ok.... thanks a lot
<10> TodoInTX: can I make it accept connections only from a certain machine? or a certain set of machines?
<12> timkay, I'm not horribly familiar with how each different join type behaves, but have you cycled through those?
<13> spundun: that's something best done via iptables + mysql grants.
<17> hey hase anyone got a stored procedure that does the same thing as PHP's ucfirst function
<10> TodoInTX: ok.. that makes sense... thanks
<17> I've got one that works when selecting fields from DB tables but doesn't seem to want to work with input variables
<11> Julian|Work: is MySQL Network what I need to get help from them?
<17> this is the sql statement I'm using: SELECT CONCAT(UPPER(SUBSTR(in_value,1,1)),LOWER(SUBSTR(in_value,2,LENGTH(in_value)))) AS Value;
<12> timkay, I think you can purchase "support," not just a network subscription
<12> timkay, let me go ask our network guy, hang on a sec.
<6> what's the library containing SQLAllocConnect in C? sorry to ask here but i have no other place (channel)
<17> !m Psykick strings
<5> Psykick: (Strings) : http://dev.mysql.com/doc/mysql/en/String_syntax.html
<12> timkay, I'm looking at http://www.mysql.com/support/
<13> timkay: it looks like a lack of diversity issue on the timestamp index
<13> mysql will hit a threshold where it thinks read huge chunk of rows from the index then the table will be slower than just reading from the table. hence doing a full table scan.
<11> TodoInTX: clearly it is calculating wrong
<13> or you key_buffer size is too small to keep the required part of the index in RAM and is swaping to the index file.
<11> TodoInTX: Is there a way to insist that it uses an index?
<11> TodoInTX: When I point it at a compound index, it only uses the first column in the index, eventhough the second column would make the calculation trivial.
<12> timkay, I know 3.x was notorious for that
<13> right
<12> Which version are you testing on?
<13> all versions do that .
<11> TodoInTX: and there is diversity in the datetime
<13> you should have a spearate index for the second key in a multipart index if you want to use it alone without the firstpart in a where clause.
<18> how to echo the first element of a table using a bash command ?
<18> and put it into a variable
Return to
#mysql
or
Go to some related
logs:
#linux
#math
who owns livemercial
#debian
#debian
WARNING: could not find /usr/src/kernel-modules/fglrx/.libfglrx_ip.a.GCC4.
etch freenx amd64
ddclient update ubuntu
#ubuntu
#kde
|
|