… SPEC} Other … # Disk Schedulers And Queue Size ############################# …having files created using…table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table…table, but proper alignment options on the file system. This is what we get when file system tries to balance writes but is…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…What is a result set? This isn’t really a trick question. The “result set” is a SET created… disk, power,etc) then split the problem up into more chunks. Each Shard-Query instance is…delayed` FROM `aggregation_tmp_74082863` GROUP BY 1 –POST EXEC: DROP TABLE IF EXISTS `aggregation_tmp#74082863` ; Edit…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… of things like sort_merge_pass, full joins and tmp tables on disk so you could actually better find the queries causing slowdowns… it is now for novice or intermediate developers/admins. Out of 801,000 tmp tables created, only 3,762 of those were on disk. It…_join and 0 Sort_merge_passes though finally. What is most confidence inspiring is thinking about the day when i can take the…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
…:56:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’; try to repair it 120326 16…: Sort aborted: Error writing file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that mess is this bit: (Errcode: 28). Now… the key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled up, MyISAM…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…what airline offered those flights and the flight number of the flight. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE…disk to use on-disk…TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 30 Comments
… million rows at a time. Here’s the CREATE TABLE: CREATE TABLE load_test ( col1 bigint(20) NOT NULL, col2 …Note that the file mentioned in LOAD DATA INFILE is /tmp/my-fifo, not infile.txt! After I was … disk activity and rows-per-second to see what the progress was. Here are some graphs. This one is …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… is to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it…. So what then? I discovered that InnoDB will still create the status file on disk even if…path as in 12 -> /tmp/iblnLBhO. One of these entries is what you are looking for, it’…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…extensive list of suggestions for what to monitor in MySQL. … you try to create or drop a table, or the database …/tmp can do the same thing. If the PID file is…is too small. The server is approaching max_connections. Overflowing the max_connections setting is a bit like a lack of disk space: it is…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… showcase I have created a function “whatstheweatherlike”. Let’s call it and see what shows up in …_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 … tree based Percona MySQL builds since it is part of MySQL community version ever since …
