June 19, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…to 18000 tps, but InnoDB can’t make 5h run. After 3h the disk is full, and InnoDB data…selectivity is not good for fast inserts, but it is suitable for range selects by `id`. However it will interesting how….x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_…

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

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

February 26, 2013 By 1 Comment

…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to…mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql> select… DIR data sets back to their …

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

Post: How adding another table to JOIN can improve performance ?

August 1, 2008 By 12 Comments

…to analyze over 300.000 of rows which is relatively fast…to trick around equity propagation to make it work) mysql> explain select… to get better performance by joining data to yet…to learn about MySQL Optimizer gotchas :) At the same time I figured out how to make MySQL Optimizer to do what we want to…

Filed Under: Insight for Developers Tagged With: ,

Post: How to debug long-running transactions in MySQL

March 8, 2011 By 6 Comments

…fast queries that you can’t capture them in the processlist. The steps I use to…mysql -ss -e ‘SELECT…to make sure you haven’t caught a false-positive). I also like to…data, unless you make them commit between iterations. And watch your server to…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

…MySQL for binary backups. Strong Points: It can restore an entire server very fast. Often the limiter of how fast this can be restored to…to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to restore mydumper data…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

…SELECT * FROM TBL WHERE hash=crc32(‘string’) AND string=’string’ The other thing you need to consider is string comparison in MySQL…to see if you can make them work well. You might need to redesign schema and queries to make it work well. Q: how…data in index order MySQL gets data…

Filed Under: Insight for DBAs, MySQL

Post: Should we give a MySQL Query Cache a second chance ?

April 10, 2011 By 64 Comments

…makes it hard to understand how exactly MySQL Query Cache is working in many cases. This however can be improved and data…to Query Cache to make it cool again. The question is whenever anyone from “MySQL…

Filed Under: Insight for DBAs, MySQL

Post: How to load large files safely into InnoDB with LOAD DATA INFILE

July 3, 2008 By 29 Comments

…to load this data on many servers without putting it into the binary log. While this is generally a fast way to load data…SELECT queries might have to scan through lots of obsolete, but not-yet-purged, row versions. Later, the purge thread will have to clean these up. This is how you make…

Filed Under: Benchmarks, Insight for Developers Tagged With: ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB_ROWS_READ | 910844 | +—————————————+—————-+ 10 rows in set (0.01 sec) mysql> select…

Filed Under: MySQL Tagged With: , , , , ,

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

…data out of memcached to make room for new records I am reading from the database. Remember memcached needs repeatability to…MySQL to using MySQL + Memcached, and then to…to memcached to be successful. This application selects…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,
« Older Posts