… performance of the splitter. It is multi-threaded(actually multi-process) and is able to hash split up…latin1 COMMENT=’Contains information on flights, and what airline offered those flights and the flight… shard-query #generate a config for 20 shards (adjust to your number of nodes) php genconfig 20…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… on “Read/Write Splitting with PHP” for Percona Webinars. If you missed …not executed synchronously. Because of features like multi-threadeded apply, changes are executed more…What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split only read queries…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…find some queries which are slow but it is hard to go back from them to what is really important…CPU available to do processing. For multi-thread application it is a bit more complicated but you …what performance gain potential is. For example in this case we could spend a lot of time optimizing PHP…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch …multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an individual case, is…work through the adaptive hash index! What is your database like? Do you …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there… were known for years. The good thing is now with multi-cores coming even on laptops these issues…. What is really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… with the new one. Note that ALTER is a multi-step process, the old table is locked in shared mode and then something….com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from the Query Cache, let’s see what happens in that case. Metadata Locking and Query Cache How does metadata locking behave with query_cache? That is an important question. If Query…
