abdfahim Posted February 19, 2008 Share Posted February 19, 2008 I have a table in my server which has abt 0.3 million row with 130 columns. The problem is when ever I try to export/rename/copy or do anything with the table, even if I run a query which may return some amount of data, the mysql service just stopped and so server lost connection. What can I do? Link to comment https://forums.phpfreaks.com/topic/91832-server-connection-lost/ Share on other sites More sharing options...
aschk Posted February 19, 2008 Share Posted February 19, 2008 Are you getting a MySQL pid deadlock? Do a EXPLAIN before your SQL query to see what the problem might be regarding the query you're running (i.e. no index usage), and also check SHOW FULL PROCESSLIST; on the server to see what's running already. Also check your log files, you might find something in the query log, binary log, or server syslog or messages. Link to comment https://forums.phpfreaks.com/topic/91832-server-connection-lost/#findComment-470378 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.