Re: Restoring a database from binlogs

2005-05-18 Thread kernel
Jeff McKeon wrote: Hey all, I've got a big problem. Seems one of our programmers decided to write a script that deletes all records from a log table older than 3 months. Problem is, we need old data from this log to reconcile our customer accounts. Our backups only go back 2 weeks. What I do h

Re: java.lang.OutOfMemoryError

2005-04-27 Thread kernel
gerald_clark wrote: >huanggaofeng wrote: > > > >>I have too many databases,when i select it by client ,but it has error . >> >>the error message is : java.lang.OutOfMemoryError >> >>how i can to resolve it. >> >> >> >> >> >You might try a java list. > > > > Gerald, Check out the "java -X"

Re: InnoDB Writes blocking Reads

2005-04-22 Thread kernel
s touching this test table. So one of those three things seems to be the cause... I just don't know what to do at this point. -andy On 4/22/05, kernel <[EMAIL PROTECTED]> wrote: Andy McCurdy wrote: I forgot to mention: we're running mysql version 4.0.23-standard-log -- Official

Re: InnoDB Writes blocking Reads

2005-04-22 Thread kernel
wered and the normal processing continues. I've included two samples from the "show processlist" command. They were taken approx. 1 second apart and show the growing amount of reads when writes are in the queue. I've removed the User and Host columns as they don't

Re: Why is this table lock?

2005-04-22 Thread kernel
Reto Breitenmoser wrote: Hi In the output from the show innodb monitor I can see, that I have a table lock on a table. But, I never set a table lock on a table (only row locks). Do I misinterpret the output or what causes this table lock? thanks Reto TRANSACTIONS Trx

Re: InnoDB Writes blocking Reads

2005-04-21 Thread kernel
es are in the queue. I've removed the User and Host columns as they don't seem to be relevant as well as trimmed the state column down. I've also included the my.cnf config file and an output of "show status". Additionally, I'm running Redhat 7.3 - kernel ver.

Re: InnoDB Performance

2005-04-12 Thread kernel
Marcin Lewandowski wrote: Hi, I've got webserver. There, I've got phpbb2 with circa 6000 users (average 70-100 users online). There was problems with locking or something else, when phpbb was using myisam tables. Yesterday, we have converted tables to innodb, because it should be more effective.

Re: Optimising a query on a large table.

2004-12-23 Thread kernel
Rob Keeling wrote: I have a 152MB MyISAM table that I am trying to execute a simple select statement on, I need to retreave all rows with a given index, sorted by date. This is taking a very long period of time to execute. What can I do to speed up the query. The sql is, SELECT * FROM table WHERE

Re: Restart of Mysql and tomcat error

2004-12-15 Thread kernel
Duhaime Johanne wrote: Hello Since that list is wonderfull to solve my problem, I will try again. But this might not be the best place since the problem concerns mysql access througt tomcat (jakarta-tomcat-5.0.28). The java application we have, when start after a mysql restart (night backup) , wi

Re: MySQL/InnoDB-5.0.2 is released

2004-12-02 Thread kernel
"MySQL to return wrong results if a SELECT uses two indexes at the same time" Does mysql 5.0.x have the ability to use more than one index per table on a select ? We had to rewrite a simple "select id from table_a where last_name like 'smith%' and first_name like 'john%'" to "select id from

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
Brian J.S. Miller wrote: Brian J.S. Miller wrote: Hello, I've read over every archived posting I can find about this problem and havne't found a solution that seems to work for me. Here is the deal: I had a server crash. Hard. I re-built the server (i686, Debian install, kernel

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-24 Thread kernel
Sebastian Geib wrote: Hi! I have a huge problem with the following insert statement: INSERT INTO cds_catalog SELECT cds_stage.cds_catalog.* FROM cds.cds_catalog, cds_stage.cds_catalog WHERE cds_stage.cds_catalog.prodid<>cds.cds_catalog.prodid; Whenever I'm running it, it pro

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
Brian J.S. Miller wrote: Hello, I've read over every archived posting I can find about this problem and havne't found a solution that seems to work for me. Here is the deal: I had a server crash. Hard. I re-built the server (i686, Debian install, kernel 2.4.18). I restored the data for

Re: Clean Reinstall

2004-09-22 Thread kernel
FayeC SQL wrote: I am extremely frustrated with the root passwordproblem. I read the manual and followed the instructions but it just won't work. I tried setting a newpassword but then when I insert the new passoword it says the password it wrong. In any case...I want to uninstall MySQL and try

Re: How to limit log space usage?

2004-09-17 Thread kernel
Nico Sabbi wrote: Hi, I have a configuration with 1 master and 2 slaves; all servers are correctly running mysql-max-4.0.20. All is fine, but I'm observing a strange usage of logs. On one of the slaves I have: mysql> show slave status \G *** 1. row