…never recovers. When you have expiration based cache you increase the chance of conditions when system will not …learn from this, besides cache design related issues I mentioned in the previous post. Include Rollback …cache. Does it recovers or does it just dies with the high traffic ? How high is …
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… existing MySQL database server, I‘d encourage not jumping on a new version immediately when it comes out. Let some … to the previous version. So if you’re not dying from the lack of a new feature that’s … old now, and although Percona still supports it and will as long as we’re asked to, the reality …
Comment: FusionIO 320GB MLC benchmarks
January 12, 2010 By 19 Comments
… sections of memory die data is routed to the extra memory (that can not otherwise be accessed). Unfortunately when the extra memory is used and any other memory is lost the solid state drive completely fails. What I‘m… could be some technology I don’t know about in SSD), is that the meantime before failure will generally be shorter in…
Comment: Performance impact of complex queries
January 22, 2007 By 11 Comments
…cache [for some tables] every time small update will be processed). But yes, sometimes batch jobs are…another pain — ‘thandering horde’ effect, no? I mean the situation when a long-long-time query locking a…only to mysql itself, i‘ve seen frontends with only apache running dies for a few seconds …
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… bugs in release” when it was changed to “no known serous bugs in release” and I think later it died off completely, at… MySQL 5.0 They are now much better than were when MySQL 5.0 just came out (aka minefield) but still… a test suite to ensure queries which you’re using will not break. You would not catch trigger bug this way…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… run checking “/Server-Status” checking if script dies after specified timeout. As the next step I pressed “STOP” button in the browser… attempted connection abort from client will not be discovered. This is unfortunately very serious limitation in practice when you’re using MySQL…_execution_time and so script will be terminated within few seconds. This is NOT the case. I‘ve tested it with 2…
Comment: Finding your MySQL High-Availability solution – The questions
October 18, 2009 By 36 Comments
… issues with replicating correctly via internal Replication. 2.4 I think it worth pointing out NDB is less than … a good bit of thought into what happens when a API node dies. One way or another a complete solution …Need to add a user or update a sproc? You will need to hit every API node. 2.10 Join …
