my-medium vs my-huge cnf files
Hi, I'm quite new to mysql and I have a question regarding the server configuration files. I have a server with 2 go of memory and I would like to know the reason why when I run a query (select * from Mytable) that returns 400k rows the my-medium configuration always runs the query in 30 sec and the my-huge configuration runs it in about 35 to 50 sec its never the same. Doesn't the my-huge suppose to be more efficient and faster when you have the memory to handle it? Or will I only see a difference running a test with multiple concurrent queries? Thanks in advance! Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my-medium vs my-huge cnf files
Stephane Savage wrote: Hi, I'm quite new to mysql and I have a question regarding the server configuration files. I have a server with 2 go of memory and I would like to know the reason why when I run a query (select * from Mytable) that returns 400k rows the my-medium configuration always runs the query in 30 sec and the my-huge configuration runs it in about 35 to 50 sec its never the same. Doesn't the my-huge suppose to be more efficient and faster when you have the memory to handle it? Or will I only see a difference running a test with multiple concurrent queries? Thanks in advance! Stephane You may be starving the operating system disk cache. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]