… executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You… you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory…that could cause a memory leak if query cache was used together with InnoDB. Bug …log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2…, and only have a log file for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log-stdin command-line option… looked like this (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with chunk 3. The…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… workload that made it scale poorly. This is when the ‘SHOW FULL PROCESSLIST’ captures generated by pt-stalk come in handy…: the ‘raw’ log parser. If you specify –format rawlog, then the tool expects the input to have one query per line, and…-format profile, to get just the ranking of queries. To my luck, one query stood out right away, always appearing many times…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other… now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query… for MySQL wouldn’t reconnect or log the error if the connection was broken during the query. Bug fixed #1080654 (Vlad Lesin…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…_host=”; Query OK, 0 rows affected (0.02 sec) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave…_host=”; Query OK, 0 rows affected (0.03 sec) mysql> reset slave; Query OK, 0 rows affected (0.03 sec) mysql> show slave… Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…graph as the blue line – SSD config) which shows the most consistent performance. The others all …DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_…size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len =…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the more general descriptors optimization in Percona Server showed fairly close results in our tests. In… of updates to the database, all SELECT queries, even those participating in read-only transactions,…innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…that is why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better …_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####plugin…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…performance issues around mutexes and Percona Server shows much better results Configurations and how to run…O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_…cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=…
