…I was testing high volume replication today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=sbsmall –init-rng=1 –max-requests=100000000 –max-time=600 –oltp-test-mode=nontrx –oltp-nontrx-mode=update…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… by a single mutex. On servers with many cores, a high volume of queries can cause extensive mutex contention. Percona Server even… summary tables can be updated with only the information that changed since they were last populated. MySQL includes two statements that make… each time (like a memcache miss) or they must be updated. Updating the summary tables efficiently is a hard problem to solve…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes… available RDS instance, which is listed as “High-Memory Quadruple Extra Large DB Instance: 68 … various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly pointed out …
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… always “insert only”. Data is very likely never updated or deleted in these databases and they are …a highly normalized database schema. It is particularly difficult to build such a model that scales as the volume … than it may be on MySQL, but it is definitely possibly to use MySQL as long as the …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…delayed table update as explained below. At this point we’ve optimized update complexity significantly however sheer volume of updates may be very high and…efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or …
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… to query the cluster status. root@monitor:~# crm status ============ Last updated: Tue Jun 29 13:56:04 2010 Stack: Heartbeat Current… by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup script controlled by… will not manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes since it…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… of customers have reported the LVM gives very high penalty when snapshots are enabled (leave along if … – it is not something MySQL related. I tested things on RHEL5, RAID10 volume with 6 hard drives (BBU disabled… be 3 writes (if we assume meta data updated each time) but how ever it could reach …
