June 20, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G… socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… comparison purposes, I also include the numbers from the vCache test where the time…requests=0 ­­–percentile=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp… = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size …

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql…bulk insert performance. At the very bottom, the page claims that you can speed up bulk…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

…tables. So first MySQL versions did …bulk inserts (multiple value inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert…to delete binary logs from master. It …_limit, ft_stopword_file FullText search related…

Filed Under: Insight for DBAs Tagged With: ,

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = … = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G …but with a misaligned IO. Here’s diskstats from the two shards running side by side: Aligned:…

Filed Under: MySQL

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

… memory usage might be even larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if…MySQL Server to consume at peak. This can be easily computed by memory needed for OS, File… have unbound memory requirements retriving result sets from remove queries. Blobs may require 3x time …

Filed Under: Insight for DBAs Tagged With: , ,

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

…, so I decided to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I can’t say… adaptive flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb… read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair…

Filed Under: Benchmarks, MySQL

Comment: Linux schedulers in tpcc like benchmark

January 31, 2009 By 19 Comments

… it, MySQL using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data file. Whatever… TOS field) which would allow exposing this to consumers (although MySQL offers INSERT DELAYED). Back to the subject, I don’t know… device layout) or is it more of a “plain sequential bulk insert/update on a very few tables” thing? Seekwatcher (http://oss…

Filed Under: Benchmarks Tagged With:

Post: How many partitions can you have ?

December 5, 2009 By 19 Comments

…(1000001) ); I used MySQL 5.1.41 for my tests increasing buffer pool to 1G and log file size to 128M so… 1000000 of sequential values from 1 to 1million (the C column was set same as ID column) using bulk insert statements – 1000 rows… UPDATE set c=c+1 to my bulk inserts) the regression became even larger. 1 partition insert took 50 seconds to complete, 10…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… rather interesting how is sort file structured for building the indexes -…insert cases – in fact if the insert is single value insert or the number of values in the bulk… in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL …” while many of them come from MySQL limits at the time when …

Filed Under: Events and Announcements Tagged With:
« Older Posts