New answers tagged

1 vote

What can cause TRUNCATE TABLE to take a really long time?

First of all you should use latest version of MySQL or MariaDB as in these version this bug has been fixed. This bug can come up when you DROP or TRUNCATE a table and you have a large buffer pool, ...
user avatar
1 vote

What max_allowed_packet is big enough, and why do I need to change it?

If you see binlog on the master, binlog positions are wrong. Sometimes error is not what it seems to be. Do not change max packet value. We need to do a little work through here. So, my suggestion, ...
user avatar
0 votes

Optimizing a simple query on a large table

A few questions/observations: Why are you sorting the result on cast_info.movie_id when the WHERE clause only allows for a single movie_id? Likewise, why are you returning the movie_id in the result: ...
user avatar

Top 50 recent answers are included