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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.