…what exactly are you trying to get by…meaning concurrent transaction commits will need to be serialized. Second, MySQL is often not able to submit a lot of outstanding IO…not just a speculation, some clients really had it) Even if you do not run any “Cluster” having SAN you…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…you can’t do…mean…mysql-bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql-bin.000007′, master_log_pos=207; slave1 > show slave…slave, what‘s logged — not what executes on the master — is what…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…slave…What to do…do if not you would either use MyISAM table as counter table (can well work if you do not run…meaning it just caches stuff and you…MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…IO schedulers should be better with this. So what can you do about it ? Do reporting on the slave Doing reporting on the slave is great idea if you…do not slow things to bad. In some environments which do not run…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…not fit into memory. As benchmark software I tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What…not put yet TokuDB on customer production boxes, but it may good fit to non-critical slave where you can run…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…slave) which is very IO bound showing 100% IO subsystem utilization on 5% of CPU usage ? This is the true challenge becomes because MySQL…means there are higher demands for IO subsystem performance. By far the best method is trying, if you…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…slave…IO resources which may not be available, especially for CPU bound MySQL Load. The benefit in this case is less space requirement if you…What…by default already. With real server grade CPU deployment the performance should be even better, meaning you should get over +-100MB/second you…
