… is yet unknown – how transactional system implements logging and dirty buffers flushing has serious impact on performance. The other gotcha which… spawning multiple databases – this might not even add too much overhead as XA already used for synchronizing with binary log. The… a lot of question about details, such as index structures, buffer management locking implementation and so on. As we already seen in…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… could be a lot different. Manageability SAN allows you to manage storage easily, compared to directly attach… more efficient in its memory while write buffering can too be done by MySQL and local…it). It often would offer snapshots with low overhead allowing to take a backups conveniently. Also …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… only controls memory which passes via PHP memory management which does not apply to MySQL result set….. Sharing connection no more works If you use buffered query you can use same connection to run… services and so on – in this case the overhead of creating yet another temporary table is not so large…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…and the difference in the index length with all overhead is not going to be huge. I think …optimizer knowing index is UNIQUE the drawback is insert buffer will not be able to be used, which … from DBA point of view ? Is there any management required or server does everything itself. Especially when …
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… locally, no need for remote access. No central management. You can loose any node at any point …put read queries to any of the nodes Drawbacks: Overhead of joining new node. The new node has …mechanism on nodes. Each node contains a cache, ring-buffer, (the size is configurable) of last N changes, …
