Bookmark and Share
Last Updates
Display: 1 - 10 of 52, Total Pages: 6
1 2 3 4 5 6 > >>
[Blog] using an inner join instead of a sub-query [Original] 2011-4-8 1:09pm

For a subquery, the explian plan scans from the outer table first, then the inner table. If the outer table is larger than the inner table, try to use an inner join. Here is an example.

Read Full Article...

Section:MySQL DBA | Read:1811 | 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:2586 | 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:3945 | 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:1983 | Comment:0 | Rating:0%

[Blog] how to dump mysql procedures [Original] 2010-4-26 10:44pm

mysqldump -uroot -p --routines --no-create-info --no-data -S /data1/mysql/tmp/mysql.sock network > proc.sql

Read Full Article...

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

[Blog] character_set and collation [Original] 2010-4-9 3:56pm

Another way is to change the connection character set and collation to utf8. You can do that with SET NAMES 'utf8' or by setting the character_set_connection and collation_connection system variables directly.

Read Full Article...

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

[Blog] Bad performance on a large offet and coving index [Original] 2010-4-1 11:50am

A statement with an offset got bad performance when the offset getting bigger and bigger. The performance was improved after changing it to use the primary key.

 

Read Full Article...

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

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