Bookmark and Share
Last Updates
Display: 1 - 10 of 46, Total Pages: 5
1 2 3 4 5 > >>
[Blog] How does "LOAD DATA LOCAL INFILE" work? [Original] 2012-9-6 12:46pm

How does "load data infile" work in different binlog_format?

Read Full Article...

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

[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] Using the Transaction Information Schema Tables to check lock status [Original] 2010-12-28 4:50pm

It is sometimes helpful to be able to identify which transaction is blocking another. You can use the Information Schema tables to find out which transaction is waiting for another, and which resource is being requested.

Read Full Article...

Section:MySQL DBA | Read:2104 | 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%

1 2 3 4 5 > >>
Latest Comments

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

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

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

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

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

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

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

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

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