I have the database MySQL performance windows 7 64 bits 5. When I run a query sometimes is quick and sometimes takes more than 120 sec and freezes. If I change it and put the 5.5 will the query run better?
MySQL performance Windows 7 64 bits 5 and 5.5
Hi Robert,
Â
The MySQL 5.5 is an improved version of the MySQL 5.0. The newer version gives better support to multi-core CPUs and large numbers of threads, causing a significant boost in performance, making query time shorter. Recovery and diagnostics are improved. The integration of InnoDB as a default storage engine will deliver better input/output performance and scalability.
Â
There are several modification made to improve the MySQL Server operation on Solaris. Also, MySQL Server can accept IPv6 TCP/IP connections from clients.