… large data sets are very expensive. If MySQL supported sort-merge or hash joins, you’d have …because you can write CSV files with any programming language. Naturally, CSV files don’t store as compactly… often justified by a large reduction in table size. I sort of stumbled upon this idea one day….
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row …more. Creating Index by sort is great Creating index by sort can provide over 20x performance…bad with sequential IO, which is what file merge process uses. This is important …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt …are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server… sometimes see unlikely settings, such as making the sort buffer size much too large (a gigabyte comes to…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE …= /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend…_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size =…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:…_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security guarantees is you can… total size is unrestricted. Note you can create tables as TEMPORARY so they would not be easily visible on file system. MyISAM Sort… limit on undo segment size. Another possibility is to use queries which use large temporary tables or sort files which can take up…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… – you have to specify compressed block size, this is the size to which you expect each page to compress… format ? (static record format for sort used by MyISAM may cause sort files to be much larger than table itself… where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is … process, the computer never swapped and I pre-warmed the file cache before the benchmark by doing “alter table sorttest engine…=`mysql -e “set session sort_buffer_size=32*1024*$i;select * from sorttest order by data limit 78000,1;show session status like ‘Sort…
