Cannot use 'Data View' on large tables
| User, date | Message |
|---|---|
|
Written by patrickgrantham
4 months ago Category: General 3 posts since Fri, 25 Mar 11 |
Folks, When click the data tab on tables that have a large number of records 20,000 + Heidi SQL hangs and then does the 'Not Responding' thing that windows programs do..! This has only started happeing since updading the dedicated server to CentOS6 64bit / MySQL version 5.5.28 All existing databases where backed up and restored without any issues. Is there a setting or configuration changes that I need to look at on the MySQL server as I do not believe it is a problem with Heidi SQL? This was never an issue before and I could view tables with 50,000 + records. |
|
Written by patrickgrantham
4 months ago 3 posts since Fri, 25 Mar 11 |
Forgot to mention... I have a MySQL server running on my local (internal) network that has a copy of all the database running on the dedicated server and HeidiSQL has no issues when viewing the data n this server. This is what makes me think it's a MySQL config thing on the dedicated server. Thanks for any help you can provide Patrick |
|
Please login to leave a reply, or register at first. |