MySQL performance Windows 7 64 bits 5 and 5.5

Asked By 30 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #138796

MySQL performance Windows 7 64 bits 5 and 5.5

qa-featured
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.

Related Questions