…of tables locked normally stays 0, unless it is ALTER TABLE or similar statement, or if LOCK TABLES was used. In addition to…in this case database pages will not be equal to total size of…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…how to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add nodes to it) A…servers in different datacenters? thanks! A: Yes, as long as there are at least 3 datacenters, and the total number of…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to rely on SQL tend to get really bogged down. In contrast, moving the processing outside the database lets you parallelize trivially. If you need to…a database. Sharding and Partitioning Sharding is inevitable if your write workload exceeds the capacity of a single server…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…table granularity is not the problem, I have only one server and number of…get data in chunks so it is even harder to implement. Might not work with transactions – Different transactions may see different states of the database…to add Qcache_hits to Com_select to get total number of…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…servers almost always query over a database which is structured as a STAR or snowflake type schema. To go back to the sales analysis example above, in a…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…of memory fatal error, and the Windows 7 server I was testing on prompted me to…in-memory database, you can get a lot of…No, I don’t know of a reference that compares these technologies for different application types. There are books that describe how to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…database About the cluster For best performance, there should be an even data distribution in the system. To get…sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…servers get more and more CPUs and CPU cores. The replication replay process executes in a single thread on the replicas, and thus has no…of the server‘s total capacity. But eventually, it does become a problem if the app gets large enough, no matter how large the read-to…
