Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted … so I can save on counting zeros. The last column shows how much does the index take compared to the data… whatever database you have active. It does not work with MySQL before 5.0 still of course 
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… the queries and shows the top queries with largest impact – longest sum of run time which typically (not always) shows queries causing highest… gather more data about the underlying tables involved and the query execution plan used by MySQL. The end result might be that… # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_terms`\G # SHOW TABLE STATUS FROM…
Post: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
… server. This will show up as something like “TABLE LOCK table `schema`.`table_name` trx id XXXX lock mode S” in SHOW ENGINE INNODB STATUS…). The largest part of ALTER TABLE not being completely crash safe in MySQL is the MySQL server manipulating FRM files. The only MySQL storage engine…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…_id in the fact table, respectively. There are nearly 400 major airports included in the data set. mysql> select count(*) from dim… largest air carriers must register and report ontime information with the FAA, so there are only 29 air carriers in the table: mysql… BY 1 ORDER BY c LIMIT 10; The next queries show how performance is improved when Shard-Query adds parallelism when…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients …EC2 servers with EBS. I benchmarked the largest available RDS instance, which is listed as…400,000,000 rows. This creates a table+index data size approximately twice as big… the line is steady enough to show that we did not cross a …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…which updates are being propagated causes largest delay. At this point I …thing happens. The script does not show any data propagation delays but it…mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-table…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…traffic commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), …of just written. Vadim did some benchmarks earlier showing that the log files need to be …for determining the necessary log buffer size? The largest write above is just under 40k, which …
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…of forum posts being large, is however not the largest we’ve got to deal in the project – …in MySQL using partitioning by domain which link was pointing to. So “mysql.com” links were stored in one table …forum sites) pointing to the given URL or graphs showing number of links per day. To fight this …
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
… the data+log files, but when I start mysql again the log shows: 100601 09:08:30 mysqld started InnoDB:…created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100601 9:08:30 InnoDB…files at least 10 times bigger than the InnoDB: largest such …
