If it’s a GC issue (shouldn’t affect reads that much though, but it’s …? I know it’s not normally an environment to run MySQL on, but IF there’s reasonable advantage with SSDs, then… consumer drives. And at least it should show if these issues are related to the GC or the internal cache…
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 27, 2012 By 10 Comments
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
…. I request to all please help me to resolve the issue. I shall be thankful to you. regards Tariq Masood SQLException… at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… to assert that XFS is the way to go for MySQL, but I’m not sure how frequently they benchmark XFS…-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4, and it’s been working great for… that XFS had some bottleneck internally, maybe the lock contention issue that Dave was referring to above. Disclaimer: I’m just…
Comment: Make your file system error resilient
April 26, 2012 By 8 Comments
…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway … count: 0″ is nearly full, this generates file fragmentation, performance issues, unless you manually apply e2defrag regularily. Not a good idea…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.21, including all the bug fixes in it… milestone at Launchpad. We are doing another release based on MySQL 5.5.21 as we have a couple of important… 5. Bug fixed #962940 (Laurynas Biveinis). Fixed MySQL upstream bug #64160 that was causing issues on upgrade to 5.5.20 and…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
… a File System on the basis of ONE fairly small issue is short-sighted in the extreme. Take a look at… matter look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will… in the first count, you are reacting to a patch issue in a way that is “fussy” in the extreme. The…
Comment: InnoDB's gap locks
April 4, 2012 By 14 Comments
… around a few months ago! I just went through this issue recently and there weren’t a lot of resources available… a post how we worked through the issue at http://insatiabledemand.ideeli.com/post/18850015294/diagnosing-mysql-auto-inc-and-gap-locks
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what…’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases have never included new features… the case that distros would only want to patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… for ext4 is a signal that there still are contention issues. I was pointed that ext4 has an option dioread_nolock… one more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5…: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
Hi, I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its… = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool…
