New answers tagged mysql-5.5
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, ...
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, ...
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: ...
Top 50 recent answers are included
Related Tags
mysql-5.5 × 1214mysql × 968
innodb × 154
replication × 124
performance × 108
mysql-5.6 × 89
mysqldump × 51
query-performance × 44
myisam × 41
mysql-5 × 38
optimization × 36
mysql-5.7 × 32
mysql-5.1 × 32
mariadb × 30
backup × 29
database-design × 28
linux × 27
stored-procedures × 26
mysql-workbench × 26
index × 25
amazon-rds × 22
windows × 22
upgrade × 21
select × 20
trigger × 19