One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… with monopolizing replication thread. For example if I need to delete old data instead of DELETE FROM TBL WHERE ts

…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just….commanual Com_dealloc_sqlblogpercona.commanual Com_deleteblogpercona.commanual Com_delete_multiblogpercona.commanual Com_doblogpercona.commanual Com_drop_dbblogpercona.commanual …

… the MV. mysql> select mview$pk as rank, customer_id, total_price, total_lines from demo.dashboard_top_customers limit 10; +——+————-+————-+————-+ | rank… functions. Now I delete some line items from orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query…

… accumulate or fill up the disk. #!/bin/bash # Begin by deleting things more than 7 days old find /root/tcpdumps/ -type… JOIN information_schema.processlist p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ "${host}" ]; then echo “Host ${host} is… port 3306 and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s…