Bookmark and Share
Last Updates
Display: 1 - 10 of 13, Total Pages: 2
1 2 > >>
[Blog] Innodb DB gap lock and timeout [Original] 2011-2-11 4:05pm

We hit a timeout issue on inserts/updates on an innodb table. We can only resume INSERTS/UPDATES by restarting apache or MySQL.  The inserts/updates were logged in the slow query log and time out on the value of "innodb_lock_wait_timeout=120".

Read Full Article...

Section:MySQL DBA | Read:2631 | Comment:0 | Rating:0%

[Blog] InnoDB: Warning: a long semaphore wait [Original] 2011-2-7 4:02pm

error: MySQL is keeping restarted and generated a lot of error message on the InnoDB datafile.

Read Full Article...

Section:MySQL DBA | Read:4023 | Comment:0 | Rating:0%

[Blog] Errors on a Slave: received end packet from server, apparent [Original] 2010-12-28 5:18pm

I use MySQL 5.1.48 and hit a bug on the slave server-id and got the following errors in mysql error log. The slave IO thread keeps rotating relay-log file and caused high IO usage.

Read Full Article...

Section:MySQL DBA | Read:2754 | Comment:0 | Rating:0%

[Blog] Analyze Innodb Deadlock [Original] 2010-10-20 11:34am

In the innoDB status report, MySQL got deadlocks on two different SQL statements and two different tables.  After analyze the general log, the deadlock happened on the same row, same table.  See the following general log.

Read Full Article...

Section:MySQL DBA | Read:4638 | Comment:0 | Rating:0%

[Blog] mysqldump: Got error: 1556 [Original] 2010-10-16 1:15am

mysqldump: Got error: 1556: You can't use locks with log tables. when using LOCK TABLES

Read Full Article...

Section:MySQL DBA | Read:6604 | Comment:0 | Rating:0%

[Blog] ERROR 1005 (HY000): Can't create table [Original] 2010-2-23 12:19am

Got the following error when adding a FK to a table:
ERROR 1005 (HY000): Can't create table 'db1.#sql-133b_d8714' (errno: 150)

Read Full Article...

Section:MySQL DBA | Read:2082 | Comment:0 | Rating:0%

[Blog] InnoDB: Error number 37 means 'No locks available'. [Original] 2010-2-18 2:23pm

I used "innodb_file_per_table" in my.cnf and failed to load a database which has about 280 innodb tables. I can load the data if I disable "innodb_file_per_table". With this parameter, I got the following errors in mysqld.log.

Read Full Article...

Section:MySQL DBA | Read:3781 | Comment:0 | Rating:0%

[Work Notes] Can't open file (errno: 24) [Original] 2009-11-3 11:57am
I go the following errors in a database: 091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file: './register/member.frm' (errno: 24)091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file:..

Read Full Article...

Section:MySQL DBA | Read:6756 | Comment:0 | Rating:0%

[Work Notes] [ERROR] Got error 127 when reading table [Original] 2009-8-18 11:18am
I optimized a base table of a merge table. Later on I got the error 127 on the merge table. And in mysqld.log, it says that merge table is corrupt and needs to be repaired. I tried to optimize table,..

Read Full Article...

Section:MySQL DBA | Read:2621 | Comment:0 | Rating:0%

1 2 > >>
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am