…flushed on commit too. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to…to 1TB+ databases. My Take: I view SAN as solution for niche circumstances when it comes to MySQL…
Post: Percona Server and XtraBackup weekly news, March 28th
March 27, 2011 By Leave a Comment
…flushing and LRU flushing, and on and on. We have been benchmarking various types of scenarios for modified neighbor flushing, for example, to investigate how…software to manage backups with XtraBackup. It is called XtraBackup Manager and is hosted on Google Code. We finished preparing XtraBackup to …
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
… nice approach which means database never needs to “stall” to perform total modified pages flush but instead flushing of dirty pages happens gradually in… done to see how much disk IO system is loaded and compare it to constant. However the shared drive at shared MySQL virtual hosting…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…MySQL 5.6 which I thought was worth sharing to give a feel for how… Dictionary Cache – Improved Adaptive Flushing – Page Cleaner/Separate Flush Thread – Group Commit for … Stages Instrumentation – - Aggregations by User, Host etc – - Network IO Instrumentation – - Show Host Cache Contents – - Improved…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…innodb_flush_method=O_DIRECT Test Setup: [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table…–mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare Running Sysbench and MySQLDump. Note we run them in the loop to see how …
Comment: How to track down the source of Aborted_connects
July 10, 2010 By 19 Comments
I have read this somewhere MySQL internally increments a per-host counter it uses to track how many “bad connections†it has seen…_errors MySQL will block the host from connecting again until you issue a FLUSH HOSTS command. By the above statement it seems clear that mysql server stores the bad client hosts somewhere.I would like to see…
Post: Living with backups
November 6, 2008 By 28 Comments
…happens for as long as it does not get flushed. MySQL obviously takes advantage of this functionality just as … is redirected through the pipe over SSH to a remote host where a script reads the standard input … also a utility called ionice. It allows to affect how I/O scheduler will be dealing with I/…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…’, ’20′ ‘Com_show_slave_hosts‘, ’61′ ‘Com_show_slave_status’,…insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands’, ’5′ ‘Handler_commit’, ’19092941′… Lowered from 32M according to MySQL innodb_additional_…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…to give another value. -c config allows you to specify a MySQL config file other than $HOME/.my.cnf, so you can store host…_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing …to my upcoming talks at the Percona Live MySQL Conference in London, UK on December 3-4 2012: How to…
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
… be useful for understanding how much progress a query has made, and potentially how long until it completes…. the best time to fix that. We are working on a new adaptive flushing algorithm that should further…taken without a base backup needing to be present on the local host. This can save even more…
