…=oltp –db-driver=mysql –num-threads=1 –max-requests=0 –oltp-dist-type=uniform –max-time=180 –oltp-read-only –mysql-host….sock run [root@localhost msb_ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /dev… small table drops more than 150 times when heavy mysqldump is running concurrently. mysqldump itself also slows down about 2x. What is…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… expand_fast_index_creation, because temporary files for merge-sorting are created in tmpdir…. Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data… in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp…), the slave will create a master.info file, and any later # change in this file to the variables’ values below will be…_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…engine, then I dumped the data to tab delimited flat files using mysqldump. I started by loading the raw data from … of the date dimension: mysql> select count(*), min(FlightDate), max(FlightDate) from dim_dateG *************************** 1. row *************************** count(*): 8401 min(…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…. Another alternative is to dump table with MySQLDump and load it back. It is all… InnoDB: Assertion failure in thread 1158060352 in file btr/btr0btr.c line 3235 InnoDB: Failing … try some higher values mysql> select max(id) from test2; +———+ | max(id) | +———+ | 220 | +———+ 1 row in …
Comment: Why MySQL could be slow with large tables ?
November 29, 2006 By 141 Comments
… to wrong configuration (ie too small myisam_max_sort_file_size or myisam_max_extra_sort_file_size) or it could be just lack… load data into MyISAM table (which was previously dumped as mysqldump –tab) The data was some 1.3G, 15.000.000…
Comment: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…do you mean when importing an export made by mysqldump? And is that different regardless of Also, how …optimizations, they take 3 hours for a 57G .ibd file; after they’re done I’ll try this method…bytes per row. Autoincrement is 12582913, so you have max 12582912 rows: 12582912*45/1024/1024=540.000 …
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… = /var/lib/mysql tmpdir = /tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M…_log_file_size = 2867M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_thread_concurrency = 8 [mysqldump] quick max…
