… DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. …allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded … in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…. It does NOT mean you can’t modify data on multiple cluster nodes simultaneously. You can. It does NOT set an…_user_id=100 WHERE id=1; COMMIT; How often might multiple users join the same group? Results In both of the…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… RAID is perfectly aligned to disk sectors (again due to the fact operations are done in multiples of 512-bytes), outside of… so in these cases there would be fewer pages spanning multiple disks so the effects of misalignment would be less significant. Here…’s no striping, with RAID0 number of bearing disks is actual number of disks (N), with RAID1+0 (RAID10) it’s N…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… is IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to requires look… by the thread and so can result in multiple outstanding requests to the disk. Though this does not help dramatically for many…. Let us get back to multiple outstanding IOs case – Matt points out the issue of disk contention people constantly forgot about. If…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… which make certain disks to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for multiple user load. See… you have multiple disks they will not be used effectively as replication SQL thread will typically submit IO requests to the disk one…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… you should consider two things – disk space and restart time. The core file will dump all MySQL Server memory content including buffer… be looking at many times the amount of memory MySQL consumes worth of disk space. You have to do couple of changes…/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your system. I also enable multiple…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work from 32…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…, but the key recently expired. The stampede impacts performance because multiple requests try to recompute the contents at the same time… unpredictable performance of the MySQL query cache, since the rate of invalidation can not be controlled, and multiple cache entries may be… data usually face two bottlenecks: disk IO and CPU usage. Disk IO is expensive, and even if the disk bottleneck is eliminated, the…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…, then worst case you could be reading the same page multiple times into the buffer pool. So considering this drawback, Batched… that the disks are 4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5.6… disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… row which means you get about 100 rows/sec. Note multiple drives do not really help a lot as we’re…, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL is lack of advanced… have whole bunch of problems solved just doing so. Use multiple servers to host portions of data set. Store portion of…
