…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql> select sum(total…

…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But …_not_cachedblogpercona.commanual Qcache_queries_in_cacheblogpercona.commanual Qcache_total_blocksblogpercona.commanual Queriesblogpercona.commanual query_alloc_block_sizeblogpercona.commanual…

… the remote server, and store the results in my MySQL sandbox instance. The new option is –save-results-database. The full mk-index…,D=index_usage \ –create-save-results-database After that finishes, the ‘index_usage’ database contains several tables: mysql> show tables; +———————–+ | Tables_in…, tbl, SUM(cnt) AS total_cnt, COUNT(*) AS variations FROM index_usage GROUP BY query_id, db, tbl HAVING COUNT(*) > 1 ) AS qv…

… to look at Prepared_stmt_count to see how many prepared… confusing as “Total Memory Allocated” is really not the total any more…to global memory allocation and will result in increased memory allocation until …where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can…

… be evaluated as math expression and the result will be IN(-2) which is …I also would note there are some MySQL optimizer restrictions in how well it … and can range from 5% of total size or less to almost 100%. … doing a SELECT competition_id, COUNT(user_id) AS user_count FROM user_competition_entry …