…in choosing a solution. David S. asked: Q: If searching on multiple…updated the index. You can use the DataImportHandler to import the result of any SQL query, and if you can form a SELECT query…table-scans. Jessy B. also asked: Q: Were these tests performed on a single machine and a…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…a single machine, and doesn’t sacrifice consistency during a network partition. It is an in-memory shared-nothing system, and tables are partitioned across multiple…update to a partition in one server is synchronously replicated to all other copies in…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…multiple reasons why application falls behind and why we see those lag spikes: Slave Server Load – MySQL Replication goes in single…query chopping making sure all your update queries are short. If you need to update 1.000.000 rows you do not do it in…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
…updates/s, 0.00 deletes/s, 24860.96 reads/s The stats are rather interesting. There are 8 queries…tables which were inserted in PK order we have relatively sequential IO and so read-ahead is constantly triggered which makes…multiple threads doing scattered O_DIRECT (so no OS read-ahead) single…
