very slow restore

Hi: I am restoring a 10 million row table using a dump file created via mysqldump.  On a very fast server, It  finishes in 8 hours. Is it  something normal ?  I know the alternative to copy file directly but here is not an option . So can I say mysql does not have its own way for high performance

Re: very strange slow plain select

Thanks very much. The default mysql behavior is a little unusual. What is the parameter in my.cnf to control the cache size before forcing a flush. I waited for 2 mininutes second before the output came out without the -q option. My server is fast enough to read in more than 2 GB data during this

very strange slow plain select

Hello: I just stumbled on this hard to explain problem. Below select * from BigTable  (BigTable has 5 million rows) takes forever to even print out the first row. as you could see from the sql, it is supposed to print out some rows right away regardless of server config in my.cnf.   What is

RE: set global does not work

  Hi: I open a connection via mysql mysql>show global variables like 'wait_timeout' --> 28800 mysql> set global wait_timeout = 1000; mysql>exit; reopen mysql mysql> show session variables like 'wait_timeout'; --> 28800 I expect session value to be 1000 according the doc, as it should be given the

How to skip reading /etc/my.cnf by mysqld

Hi: I am trying to test mysql options and would like to have mysqld only read ~/.my.cnf instead of using the normal sequence to read /etc/my.cnf $datadir/my.cnf and ~/.my.cnf. This would prevent many unexpected issues in testing. But I could not find the way to disable the /etc/my.cnf. Any help w