… card. What does that mean? Apparently PCIe specification has a limitation on available power. If I …sync mode, and only 64 threads are getting close. Response time: In the conclusion, from all tested …s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…many prepared statements are allocated on server and Com_stmt_send_long_data to see whenever … really not the total any more as Innodb has moved allocating memory from operation system directly …memory usage continues to grow even if you close connections and tables regularly. Another common thing …
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… the subject of “Oracle has killed MySQL and made it closed-source”, whilst they haven’t made it closed-source, what they do… the change around this time last year: http://mysqlha.blogspot.com/2011/02/where-have-bugs-gone.html and it’s… for people to back-port patches. As an alternative Ubuntu has decided to just keep rolling out the latest version of…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
…. This was brought to my attention recently http://oss.sgi.com/archives/xfs/2012-01/msg00325.html and this was the… to fix the overwrite DIO performance problem: http://oss.sgi.com/archives/xfs/2012-02/msg00219.html Now that the prerequisite… testing I’ve done on this machine with this patch has given close to a million 4k overwrite IOPS to a single…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_sqlblogpercona.commanual Com_flushblogpercona.commanual Com_grantblogpercona.commanual Com_ha_closeblogpercona.commanual Com_ha_openblogpercona.commanual Com_ha_readblogpercona.commanual Com_helpblogpercona.commanual Com_insertblogpercona.commanual Com_insert_selectblogpercona.commanual Com_install…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_execute_sql’, ’0′ ‘Com_flush’, ’108′ ‘Com_grant’, ’0′ ‘Com_ha_close‘, ’0′ ‘Com_ha_open’, ’0′ ‘Com_ha_read’, ’0′ ‘Com_help’, ’0′ ‘Com_insert’, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill’, ’47′ ‘Com_load’, ’0′ ‘Com…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…| 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 |…see that something is disconnecting ungracefully (without closing the connection properly). This is … to use a server that has the Percona patches for microsecond …
Post: Write performance on Virident tachIOn card
December 13, 2010 By 10 Comments
… I wrote about this before (http://www.ssdperformanceblog.com/2010/07/free-space-and-write-performance/), … might be tempted to say that Virident just has a lot of space reserved internally which … * Virident card maintains very good throughput level in close to full capacity mode, and that means you…
Comment: Open Development vs Making a Big Splash
May 22, 2009 By 28 Comments
… – it’s not “newâ€, it’s something that has been in the worklog system for a long time,… the Maria instrumentation late last year: http://lists.mysql.com/commits/56225 They’ve all been out in the… does not mean we were doing it entirely behind closed doors. Sure, I admit there was not a tree …
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…is getting more and more complicated. MySQL architecture has to be additionally complicated to support modular …there were no bugs.mysql.com – bugs were reported to bugs@lists.mysql.com which meant both it…? I guess because MySQL 5.1 release was closed for any significant changes for years. Now how…
