distal-attribute
distal-attribute
distal-attribute
distal-attribute

Cannot use 'Data View' on large tables

User, date Message
Written by patrickgrantham
1 year 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
1 year 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.