| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 3 years, 7 months |
| seen | Jan 15 at 7:03 | |
| stats | profile views | 32 |
|
Jun 24 |
awarded | Popular Question |
|
Jan 29 |
awarded | Notable Question |
|
Dec 16 |
awarded | Notable Question |
|
Nov 21 |
awarded | Popular Question |
|
Nov 19 |
awarded | Popular Question |
|
Oct 28 |
awarded | Yearling |
|
Aug 31 |
comment |
MySQL stop responsing when modify main tables current innodb_buffer_pool_size is set to 3GB, and innodb_flush_log_at_trx_commit is already set to 2. |
|
Aug 28 |
accepted | More than 1 billion rows in a MyISAM table |
|
Aug 28 |
accepted | Install anonymous proxy on Ubuntu |
|
Aug 28 |
accepted | Blank graph for some munin plugins |
|
Aug 28 |
accepted | Install python-psycopg on Ubuntu 9.10 |
|
Aug 28 |
asked | MySQL stop responsing when modify main tables |
|
Aug 19 |
accepted | MySQL failed to start after killed a long running “LOAD DATA INFILE” process |
|
Aug 19 |
revised |
MySQL failed to start after killed a long running “LOAD DATA INFILE” process added 378 characters in body |
|
Aug 18 |
awarded | Commentator |
|
Aug 18 |
comment |
MySQL failed to start after killed a long running “LOAD DATA INFILE” process I checked mysql-error.log and it shows only logs like "100818 8:53:07 [Warning] /usr/sbin/mysqld: Forcing close of thread 15677304 user: 'root' ". My server has 8GB RAM and it was running very well before I tried to load the 9GB .csv file to database (it took 6 hours to load a 3GB .csv file before which was not bad). |
|
Aug 18 |
comment |
MySQL failed to start after killed a long running “LOAD DATA INFILE” process I did a check with "free" command, the Swap figure is very high. I killed memcached service and the Swap figure is declining now. What should I do at the moment? Maybe wait for MySQL server to be shutdown is the best option? |
|
Aug 18 |
comment |
MySQL failed to start after killed a long running “LOAD DATA INFILE” process I tried "mysql -A DATABASE" and "mysql", all the same as without "-A" switch. I'm now shutting MySQL server down. It's still in progress after 20 minutes. |
|
Aug 18 |
asked | MySQL failed to start after killed a long running “LOAD DATA INFILE” process |
|
Jun 28 |
awarded | Popular Question |