… volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout session. Tell… variants at the code level? Share your perspective about the internals or explain how specific features work in depth. These stories…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… level via a lightweight python app (using multi threading and internal queues) that accepted connections from the app (php, java, python… over time (as I have spare time for non-work related fun load tests that is..) which is going to show…
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
… ago we posted a call for interns to work with us on various MySQL Performance related things. We got good number of… mentor and sponsor your work. Generally the tasks we see Interns working on are either Open Source projects or research which…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…_File is in fact VERY typical. I’ve seen multiple “internal instructions” for cloning the slave or slave recovery from backup…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, every SQL query is really a cleverly disguised relational algebra mathematical expression. With relational algebraic substitution, every aggregate expression, even non-distributable…” is a SET created by the output of a relational algebra expresion. Relational algebra expressions always produce sets as output. Just to… the coordination node, and this projects the final result set. Intern-node communication One or more gearman queues are used to…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and all… – “reservation count” and “signal count” show how actively innodb uses internal sync array – how frequently slots are allocated in it and… of log/io operations allows to separate tablespace related IO from log related IO so you can see how much IO your…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…reduces memory consumption to be withing the reason. Connection Related Allocations Another set of buffers correspond to connections – …———————- Total memory allocated 132183490560; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash …
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… operations, but when they do, they must work. Many recovery-related bugs are not easily reproducible and it is difficult to… InnoDB forums. Most of the bugs were found through extensive internal testing. And, on the other hand, some of the earliest… bugs and the idea of publishing them. Most of our internally-detected bugs involve complex testing scripts and workloads, and logs…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… and then you have a lookup table which stores the relation between wordid and docid. The problem with this method compared…: 24.0 seconds Reversed index with cheating (limit each word internally to 2000 hits): 1.66 seconds Sphinx: 16.31 seconds…: 0.01 seconds I dont know how sphinx stores data internally but hopefully something of what I have said above might…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…. There are still possibilities for sorting order and data type related changes, so you still need to run mysql_upgrade to… one is Barracuda? It should not be the problem. Innodb internal format is rather low level and it rarely impacts application… statistics (ANALYZE TABLE) or disabling some of the optimization/statistics related features in new version. Innodb statistics can especially be the…
