Finding largest tables on MySQL instance is no brainier in MySQL…_schema.TABLES ORDER BY data_length + index_length DESC LIMIT 10; +————————————-+——–+——–+——–+————+———+ | concat(table_schema,’.',table_name) | rows | data | idx | total_size …
Post: Researching your MySQL table sizes
March 17, 2008 By 26 Comments
…SCHEMA query to find largest tables last month and it got a…_schema.TABLES WHERE table_name like “%performance_log%”; +——–+———+———+——-+————+———+ | tables | rows | data | idx | total_size | idxfrac | +——–+———+———+——-+————+———+ | 120…
Comment: Finding out largest tables on MySQL Server
October 14, 2008 By 24 Comments
….com Finding largest tables on MySQL instance is no brainier in MySQL …TABLES ORDER BY data_length+index_length DESC LIMIT 10; +————————————-+——–+——–+——–+————+———+ | concat(table_schema,’.',table_name) | rows | DATA | idx | total_size…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size… to contain largest record in the given table which is held until table is closed. Federated…. For example you may find out increasing sort_buffer_size from 1MB to 4MB …
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…table), I used strace to gather statistics about how the log file writes are distributed in terms of write size…cache for best performance (sorry, can’t find the link right now). This makes intuitive… meaningful for determining the necessary log buffer size? The largest write above is just under 40k,…
Comment: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… (largest index is nearly 1.7GB) running on a box with 4GB of memory. I’ve currently got the key_buffer_size set to 1.5GB, and I’m finding performance on the large tables can vary hugely, presumably dependent on whether the index for those tables is currently loaded…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…largest air carriers must register and report ontime information with the FAA, so there are only 29 air carriers in the table…of the following queries depends on the size of the date range: — Q8.0 …before publication, as a courtesy. All findings are represented truthfully, transparently, and without …
