… behind and why we see those lag spikes: Slave Server Load – MySQL Replication goes in single thread so it is…pass through the replication. If you happen to have IO bound load and have 20 hard drives on the… lot to see when you’re close to the limit. To manage replication lag and to understand what is…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their limits…MySQL Proxy to help with sharding or dealing with use not fully up to date slaves….used with MySQL to get very fast IO and so consolidate system suffering from IO bound workloads….
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…improvements available in MySQL 5.6 …(MRR) – Faster ORDER BY nidxcol LIMIT N – Persistent Statistics for Innodb…- Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog…Instrumentation – - Aggregations by User, Host etc – - Network IO Instrumentation – - Show Host Cache …
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…”warm up” time. If provisioning a slave, this means your new slave will end up with a warmed… now possible to stream incremental backups, lifting a limitation from previous versions where it was only …parallel=4 –compress –compress-threads=2′ will create 4 IO threads that will read the data and …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…limits but because your application logical serialization problems. So what if we have very IO bound application without serialization issues (say reporting slave) which is very IO bound showing 100% IO subsystem utilization on 5% of CPU usage ? This is the true challenge becomes because MySQL…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_… vmstat 5 2 procs memory swap io system cpu r b swpd…mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize…IO schedulers should be better with this. So what can you do about it ? Do reporting on the slave…long time. If you delete things do DELETE … LIMIT 1000 and insert sleep 10; in between. By…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…limit scalabilty? A: It depends how you store $_SESSION. I have audited sites that stored $_SESSION in the MySQL… of “unsafe” slaves going to be a high performance cost? A: Connecting to a MySQL database isn’t … the SQL thread is caught up and the IO thread is waiting. A: Yes, the “seconds behind …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…- mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql…patching file sql/set_var.h patching file sql/slave.cc patching file sql/sql_cache.cc patching …rate_limit) session. With high traffic coming to your database, the slow logging may consume a lot of IO …
Post: Looking at Redis
August 27, 2009 By 27 Comments
… a lot of applications. This however limits it scalability to single core. Still …write Redis does not an expensive IO subsystem. Also because this dump is… conflicts etc. Redis also supports master/slave replication out of the box and… which are hard to batch. With MySQL/Innodb I got server being able…
