Bookmark and Share
Last Updates
Display: 1 - 5 of 5, Total Pages: 1
1
[Blog] How does "LOAD DATA LOCAL INFILE" work? [Original] 2012-9-6 12:46pm

How does "load data infile" work in different binlog_format?

Read Full Article...

Section:MySQL DBA | Read:1172 | 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:2713 | Comment:0 | Rating:0%

[Blog] InnoDB: Error number 37 means 'No locks available'. [Original] 2010-2-18 2:23pm

I used "innodb_file_per_table" in my.cnf and failed to load a database which has about 280 innodb tables. I can load the data if I disable "innodb_file_per_table". With this parameter, I got the following errors in mysqld.log.

Read Full Article...

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

[Blog] How to logrotate mysq slow log files? [Original] 2009-6-10 1:12pm

using lilnux logrotate to remove and rotate the log files.

Read Full Article...

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

[Blog] 如何定期删除MySQL的bin log 文件 and expire_logs_days = 30 [Original] 2005-8-4 2:59pm

我是编制了一个script,放在linux的crontab中,用于定期删除MySQL的bin log 文件,我的所有的bin log文件保存一个月。

Read Full Article...

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