…’Com_update_multi’, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables’, ’0′ ‘Created_tmp_files‘, ’4001′ ‘Created_tmp_tables’, ’669137′ ‘Delayed_errors’, ’0′…’ ‘Not_flushed_delayed_rows’, ’0′ ‘Open_files‘, ’95′ ‘Open_streams’, ’0′ ‘Open_tables’, ’512′ ‘Opened_tables’, ’183240′ ‘Qcache_free_blocks’,…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –… I’m examining the status values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql…. It’s like knowing openings in chess — the great chess players study openings exhaustively, but they …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M… to # connect), the slave will create a master.info file, and any later # change in this file to the variables’ values below will…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc…log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path =…500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M …min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id = 10 …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… still create the status file on disk even if you do not specify innodb-status-file option. The file is … but not-yet-closed files (file is physically removed only after it is no longer open by any process). … 11886 mysql 5u REG 253,10 130932 12 /tmp/ibuQBSgo (deleted) mysqld 11886 mysql 6u REG 253,…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0.002255 | | After create | 0.000050 | | copy to tmp …fast_index_creation, because temporary files for merge-sorting are created in tmpdir. The constant “copying to tmp table” part will not be…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain open via a filehandle…create or drop a table, or the database itself. Likewise, if a system administrator leaves a temporary file… to delete old files in /tmp can do the same thing. If the PID file is missing, …
Comment: xtrabackup-0.3, binaries and stream backup
March 20, 2009 By 11 Comments
… mysql server version 5.1.31-percona-log innobackupex: Created backup directory /tmp/2009-03-21_00-40-56 090321 00:40… 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: File name /tmp/2009-03-21_00-40-56/var/lib/mysql/ibdata1 InnoDB: File operation call: ‘open‘. InnoDB: Cannot continue…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…you have it all in place, we can begin. Open command line (shell) on the server and go …my.cnf file, the remaining part of the configuration will not matter, because the log file won’t be created. … string. [qc_miss, full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] It …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…0.9.1 The table I loaded data is: CREATE TABLE `ontime` ( `Year` year(4) DEFAULT NULL, `Quarter` …I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock …100GB, which is significant economy of space. I am open to run any other queries if you want …
