MySQL performance Windows 7 64 bits 5 and 5.5

Asked By Robert Patrick 30 points N/A Posted on - 11/07/2012

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?

• Status: Open
• Question Views: 855
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By parker_carter 0 points N/A #138796

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.

About parker_carter

Questions
1

Answers
98

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 11/08/2012
• Question Category: MySQL Server