Bookmark and Share
Last Updates
Display: 31 - 40 of 150, Total Pages: 15
<< < 1 2 3 4 5 6 7 8 ... 15 > >>
[Blog] Upgrade to MySQL 5.5 [Original] 2011-2-1 1:24pm

If you use MySQL5.0, you need to upgrade to MySQL5.1 first, then upgrade to MySQL5.5.


Read Full Article...

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

[Blog] articles' collection about Mysql InnoDB status and MySQL InnoDB internal files [Original] 2010-9-2 5:45pm

Check "show innodb status\G", if you find high values (>) on "Pending reads, pending writes, flush list..", which means InnoDb is I/O bound. Using "vmstat 5 5" or "iostat -dx 5" to check I/O details.

Read Full Article...

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

[Blog] Mysql InnoDB mutex status [Original] 2010-9-2 5:15pm

SHOW MUTEX STATUS returns detailed InnoDB mutex information and is mostly useful for gaining insight into scalability and concurrency problems. Each mutex protects a critical section in the code.


Read Full Article...

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

[Blog] about innodb_force_recovery [Original] 2010-8-15 9:54pm
innodb_force_recovery is used to force mysql to start up while preventing background 
operations from running, so that you are able to dump your tables.

Read Full Article...

Section:MySQL DBA | Read:3716 | Comment:0 | Rating:80%

<< < 1 2 3 4 5 6 7 8 ... 15 > >>
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