Bookmark and Share
Last Updates
Display: 21 - 30 of 150, Total Pages: 15
<< < 1 2 3 4 5 6 7 8 ... 15 > >>
[Blog] restore a single table from a large mysqldump file [Original] 2011-9-8 5:04pm
$ sed -n -e '/CREATE TABLE.*mytable/,/CREATE TABLE/p' mysql.dump > mytable.dump

Read Full Article...

Section:Linux tips | Read:795 | Comment:0 | Rating:0%

[Blog] a script to kill many same slow queries in DB [Original] 2011-8-18 1:45pm

A small script to kill all same slow queries in MySQL database.

Read Full Article...

Section:Linux tips | Read:1260 | Comment:0 | Rating:0%

[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:1842 | Comment:0 | Rating:0%

[Blog] innodb 1.1 new features [Original] 2011-2-15 1:55pm

Multiple buffer pools and Multiple Background I/O Threads

Read Full Article...

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

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