Number of SQL Queries on different OSes
Hi guys,
I have 2 servers with MySQL. First on Windows 2003 server and second on Linux Ubuntu. Also, I have equals DB on these (InnoDB). It's abount 50 tables and views. so, when I run the query (select from different tables and views with joints) on these DBMS instances I get the different result for Number of SQL Queries (u can see it in the SQl Administrator->Server status). As I understand, this variable present the current number of queries. So, the values for Windows and Linux servers are very different. On Linux it's about 250 000 and time for query about 1 sec. On Windows it's about 500 and time about 20 sec. Why?
How can I get result for Windows same to Linux? I need in fast dbms
Subject
Views
Written By
Posted
Number of SQL Queries on different OSes
2181
March 10, 2010 09:19AM
1127
March 11, 2010 06:33AM
1255
March 11, 2010 09:20AM
1179
March 11, 2010 11:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.