… different sets of MySQL configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it make more sense to configure MySQL as if it were using SSD storage or to just…_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
….2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb… = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also … Innodb team will put on their roadmap. With SSD coming this will be important. And it is …sending it back to the client. I tested MyISAM with myisam_use_mmap option which did not seems to …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding…IO at the time if Innodb or MyISAM tables are used. There is read-ahead…should also evaluate external directly attached storage, SSDs, Increasing system memory as well as …
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably… to stick to old optimizer behavior with new MySQL Version. Make Cost Model Adjustable MySQL Optimizer looks at query plan in terms…% in RAM (even for Disk tables such MyISAM or Innodb) others keep database on SSD which has completely different ratio between CPU…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed… to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer…, 8GB of RAM, and two SSD drives: one for the Windows partition, and one for the MySQL data partition. I performed all…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… 4x 80 GB SSD MLC CentOS 5 x 64 bits RAID-5 HW In this server is installing MySql 5.5.21… = 512 [Buffers] join_buffer_size = 32M key_buffer_size = 640M myisam_sort_buffer_size = 64M sort_buffer_size = 4M read_rnd…/mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… Keep’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some… read-write tests, and the server has two Intel SSDs, 64GB of memory, and 4 x 12-core AMD … another machine, instead of taking 12 cores away from MySQL and giving them to sysbench. That way we could …
