36 reputation
3
bio website
location
age
visits member for 2 years, 9 months
seen Aug 3 '12 at 7:55

Apr
8
awarded  Popular Question
Jun
4
revised Lost connection to MySQL server during query
added 721 characters in body
Jun
4
comment Lost connection to MySQL server during query
Well thnks for your reply....i have updated my actual query..can u tell me how to rewrite my query using mysqldump
Jun
1
awarded  Editor
Jun
1
revised Lost connection to MySQL server during query
added 67 characters in body
Jun
1
asked Lost connection to MySQL server during query
May
2
comment FLUSH TABLES stays in the processlist even after execution
and is dere any way to check how many file handles are open at a particular time in mysql
May
2
comment FLUSH TABLES stays in the processlist even after execution
ok but i still cant understand the colliding part..
May
2
comment FLUSH TABLES stays in the processlist even after execution
and one more thing if i run the command SET GLOBAL bulk_insert_buffer_size = 1024 * 1024 * 256; will dere be any need to restart mysql
May
2
comment FLUSH TABLES stays in the processlist even after execution
"it could be the two commands colliding into one another, especially if there are a lot of open file handles in mysqld"...can u explain further...i am new to dba
May
2
comment FLUSH TABLES stays in the processlist even after execution
MySQL version 5.1, Tables are MyISAM and bulk insert buffer size is 8388608
May
2
asked FLUSH TABLES stays in the processlist even after execution
Feb
16
awarded  Student
Feb
16
asked Does the max_allowed_packet variable have any effect on LOAD LOCAL INFILE?