Bookmark and Share
Last Updates
Display: 1 - 3 of 3, Total Pages: 1
1
[Work Notes] Query Cache Status and Maintenance [Original] 2009-8-10 2:58pm
1. merge query cache fragments by using "flush query cache;" mysql> show status like 'Qc%';+-------------------------+----------+| Variable_name        &nbs..

Read Full Article...

Section:MySQL DBA | Read:3969 | Comment:1 | Rating:0%

[Work Notes] How MySQL Query Cache Operates [Copied] 2009-8-10 11:15am
Queries are compared before parsing, so the following two queries are regarded as different by the query cache: SELECT * FROM tbl_name Select * from tbl_name Queries must be exactly the same (byte..

Read Full Article...

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

[Blog] MYSQL errno: 121 caused by same FK definitions [Original] 2009-6-3 11:42am

In stageDB, there is a table ams_archive which has the following definition:

"ERROR 1005 (HY000): Can't create table './hearst/janetestfk.frm' (errno: 121)"

Read Full Article...

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

1
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