Geek Answers Handbook

Phpmyadmin freezes on request, is db too big?

I have two tables (one with 33k rows and the other with 7k rows). I want to compare two tables and delete rows in which the two identifiers do not match. But when I submit the request, it freezes phpmyadmin. Can tables be too large?

SELECT * FROM likes LEFT OUTER JOIN uploads on likes.upload_id = uploads.upload_id WHERE uploads.upload_id IS NULL

I know that databases are designed to handle millions of data, so I'm not sure where the error is.

Regards, Mathias

+2
source share
4 answers

I would do an explanation so you can see what mysql is doing. This will give a good idea of ​​how many lines are used.

 EXPLAIN SELECT * FROM likes LEFT OUTER JOIN uploads on likes.upload_id = uploads.upload_id WHERE uploads.upload_id IS NULL

you can also use another browser or another session to use show processlist to see how the request is being executed.

+3
source

The tables are probably not too large, but the PhpMyAdmin request timeout can be a problem if the script takes a long time. Try changing the timeout or not using PhpMyAdmin at all. See if you can execute the query using the command line on the server (or some other tool).

See also:

+1
source

Does Freeze mean that it works, but never updates / never completes a task?

If yes, then I had a similar thing, and I found that they were related to having more than one index in the column, for example, the column has a PRIMARY index and an index named after the column, so check your indexes

0
source

Sometimes I run large import “requests” that can take several hours. (I will disable "Partial import → Allow interruption of import ...".)

phpMyAdmin will not respond in the browser. I started the requests, even if I try to reload the page, but if I go to the browser on another machine with (I assume) a different IP address, then phpMyAdmin will respond perfectly.

In another browser, I then issue the SQL SHOW FULL PROCESSLIST command in monitor and, if necessary, delete this long query.

0
source

More articles:


All Articles