Question : We have a master & multiple slave replication in our production environment. At first, I found this error […]
Tag: myisam
Disk full of mysql .mad and .mai files
Question : On a (owned) shared server sometimes mysql writes alott of .mad and .mai. This happens since i think […]
How to determine the optimal sort_buffer_size?
Question : I read from a sample configuration file which says the following: # Sort buffer is used to perform […]
How to optimize a table/db with 200 insert/sec
Question : I’m facing a very hard problem. I have a mysql DB (MyISAM) with a main table (user) where […]
Why is MySQL is creating so many temporary tables on disk?
Question : Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows Current max_heap_table_size = […]
InnoDB query duration inconsistent
Question : I am running a series of UPDATE commands on a nearly empty InnoDB table, and around 1 out […]
MySQL QPS debugging?
Question : I see 5 Kqps on my DB server during 5 mins interval on zabbix dashboard. But sum of […]
What is branching factor of mysql myisam’s b-tree
Question : I am doing some research but I am struggling to find what is branching factor of MYISAM’s b-tree, […]
Query databases that have MYISAM tables that do not have only fulltext index tables
Question : I am trying to query from the information_schema where the database (table_schema) has MYISAM tables but does not […]
TRUNCATE TABLE statement sometimes hangs
Question : Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? I […]