Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ … easily find it later, plus it is quite handy in a way it presents information: SELECT CONCAT(table_schema, ‘.’, table_name), CONCAT(ROUND(table…, 2) idxfrac FROM information_schema.TABLES ORDER BY data_length + index_length DESC LIMIT 10; +————————————-+——–+——–+——–+————+———+ | concat(table_schema,’.',table_name) | rows | data | idx…
Post: Researching your MySQL table sizes
March 17, 2008 By 26 Comments
I posted a simple INFORMATION_SCHEMA query to find largest tables last month and it got a good response. Today I … goes: Find total number of tables, rows, total data in index size for given MySQL Instance SELECT count(*) tables, concat(round(sum(table_rows… row in set (0.03 sec) Find biggest databases SELECT count(*) tables, table_schema,concat(round(sum(table_rows)/1000000,2),’M') rows, concat…
Comment: Finding out largest tables on MySQL Server
October 14, 2008 By 24 Comments
…Referenced from: mysqlperformanceblog.com Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ … easily find it later, plus it is quite handy in a way it presents information: SQL: mysql> SELECT concat(table_schema,’.',table_name),concat(round(table_rows/1000000,2),’M') rows,concat(round(data…
Comment: Finding out largest tables on MySQL Server
March 17, 2008 By 24 Comments
[...] posted a simple INFORMATION_SCHEMA query to find largest tables last month and it got a good response. [...]
Comment: Finding out largest tables on MySQL Server
August 8, 2008 By 24 Comments
[...] Finding out largest tables on MySQL Server [...]
Comment: Finding out largest tables on MySQL Server
February 28, 2008 By 24 Comments
[...] “Finding out largest tables on MySQL server” [...]
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For OLTP applications with… which is large enough to contain largest record in the given table which is held until table is closed. Federated Storage Engine. This… consumption reacts to changing various variables. For example you may find out increasing sort_buffer_size from 1MB to 4MB and…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… a gaming workload (mostly inserts to the “moves” table), I used strace to gather statistics about how…OS cache for best performance (sorry, can’t find the link right now). This makes intuitive sense… for determining the necessary log buffer size? The largest write above is just under 40k, which might…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… has some hard-to-find skills, such as experience with CFEngine. Ewen has been working with our largest clients, helping them make… a system architect he helped build two of Poland’s largest internet portals serving billions of pageviews a month. It’s… toolkit, debugging obscure networking problems, and recovering data from InnoDB tables that are so badly damaged that InnoDB’s own recovery…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… fast and efficient queries, which just happen to do full table scans – for example if you would be having drop down… log As I already mentioned besides finding slowest queries it is important to find queries which cause largest load on the server, which… normally require you to keep the other window open and find query sample with real constants which matches query with placeholders…
