…to complete. Here is example how it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… how Shard-Query will perform on each database. To… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show…hosts.internal [host list omitted] Now you need to set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts…-flush-log-at-trx-commit=1 innodb-flush-…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…help for hosting providers to produce detailed reports on how each…the users to some newly purchased hardware. But how to …to help you with some strategic decisions. Sample outputs: mysql>…FLUSH command (e.g. FLUSH INDEX_STATISTICS). All that can be fed into scripts to bring you automated reports or to…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH…MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to saved binary log position: change master to master_host…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… are a SaaS hosted application for data…how to read these, there’s a full explanation in our book, High Performance MySQL…162626 | | Uptime_since_flush_status | 162626 | +———————————–+———————-+ +———————————–+———————-+ | Variable…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…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: 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 …
