…database After that finishes, the ‘index_usage’ database contains several tables: mysql> show tables; +———————–+ | Tables_in_index_usage | +———————–+ | index_alternatives | | index_usage | | indexes | | queries | | tables…

…MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In…look at Prepared_stmt_count to see how … buffers 1 Database pages 8252672 Old database pages 3046376 Modified… in “Total memory allocated” line yet they are seen in one …

… database that has about 400GB of indexes. The indexes can’t fit in …total size or less to almost 100%. When your go from working set what fits in… have, which is 64 per table in recent MySQL versions. However it is often… a SELECT competition_id, COUNT(user_id) AS user_count FROM user_competition…

…in the database…total_price’); CALL flexviews.add_expr(@mvid,’COUNT‘,’*',’total_lines’); CALL flexviews.add_table(@mvid,’demo’,'orders’,'o’,NULL); CALL flexviews.add_table…

… not just for new connections as in MySQL. This is very helpful for …57 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 149 # … # Tmp table 100% yes, 0% no # Tmp table on 100% yes, 0% no # String: # Databases wp…

…constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently,…commanual Qcache_not_cachedblogpercona.commanual Qcache_queries_in_cacheblogpercona.commanual Qcache_total_blocksblogpercona.commanual Queriesblogpercona.commanual query_alloc…