Bookmark and Share
Last Updates
Display: 1 - 10 of 24, Total Pages: 3
1 2 3 > >>
[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:1808 | 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:2572 | Comment:0 | Rating:0%

[Blog] An example of user_defined variables [Original] 2010-1-4 11:50am

select max(trans_id)+2000 into @v1 from transactions_overflow_insert;

Read Full Article...

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

[Work Notes] how to use MySQL SET Datatype [Original] 2009-10-7 5:22pm
A table article has a column is defined as SET datatype; mysql> desc article localized;| localized | set('articleName','articleSubname','topTitle','description','content','keywords','status',..

Read Full Article...

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

[Work Notes] MySQL case statement [Original] 2009-10-4 1:46pm
1. An example of case statement in the procedure: delimiter // create procedure migrate_total (norID int) begin         DECLARE euID INT DEFAULT 1;&n..

Read Full Article...

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

[Work Notes] An example of MySQL cursor [Original] 2009-9-25 10:52am
An example of MySQL nested cursor loops: 00    begin 01        declare no_more_rows boolean default false; 02     &nbs..

Read Full Article...

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

[Work Notes] MySQL trigger [Original] 2009-9-17 11:36pm
Test a mysql trigger in MySQL replication. 1. create a table on mastercreate table emps(emp_id int NOT NULL, emp_name varchar(30), dept_id int, dept_name varchar(30),..

Read Full Article...

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

1 2 3 > >>
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