…_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….02 sec) Each year has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) | +———–+ | 135125787 | +———–+ 1…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… corresponds to pretty significant load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=32 –init-rng=on… on the node TO which updates are being propagated causes largest delay. At this point I remembered there is one more…/mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-table…
Comment: Finding out largest tables on MySQL Server
October 14, 2008 By 27 Comments
…Referenced from: mysqlperformanceblog.com Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still… in a way it presents information: SQL: mysql> SELECT concat(table_schema,’.',table_name),concat(round(table_rows/1000000,2),’M') rows,concat(round…
Post: Getting MySQL to use full key length
January 31, 2007 By 5 Comments
… 0,10 \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: msg132 type: ref possible_keys: group_id,thread_id,groupid… FORCE INDEX actually forces index to be used to largest extent possible: mysql> explain SELECT thread_id FROM nn2_msg132.msg132 force…
Comment: Finding out largest tables on MySQL Server
January 2, 2013 By 27 Comments
Mysql sever version 5 and above has all these posiblities to fetch data from information_schema. But the lower versions like 4.X.X dont have information_schema. Any idea to get the memoy of each schema and largest tables under each schema??
Comment: Finding out largest tables on MySQL Server
August 8, 2008 By 27 Comments
[...] Finding out largest tables on MySQL Server [...]
Comment: Finding out largest tables on MySQL Server
February 28, 2008 By 27 Comments
[...] “Finding out largest tables on MySQL server” [...]
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
September 30, 2009 By 29 Comments
…) file growing even when i have file_per_table and indeed all my tables are created correctly as separate files. when i… new mysql instance. is there any way of avoiding the ibdata file from growing to be as large as the largest transaction effectively? for me the largest transactions would be a data load which…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… a high-traffic commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace… distribution meaningful for determining the necessary log buffer size? The largest write above is just under 40k, which might seem to… needs more research. It’s possible that even if the largest write is quite small, a small log buffer size wouldn…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… Professional (OCP), a Certified MySQL 5.0 DBA (CMDBA), and a Certified MySQL 5.1 Cluster DBA … CFEngine. Ewen has been working with our largest clients, helping them make their data centers more…obscure networking problems, and recovering data from InnoDB tables that are so badly damaged that InnoDB’…
