…problem…mysql tables in use 1, locked 0 is number of tables used by transaction in question (meaning it was accessed) and number of tables…many inserts were done in insert buffer, how many recs were merged and how many merges did it took. Ratio of number of merges…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…conclusion, splitting a problem up into many small problems and then putting the… into the coordination node when maintaining the “materialized view” of …SQL, but right now only MySQL storage nodes are supported. …the base table: `origin_airport_id` * storage node result set merge optimization enabled:…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
…many tables of same format rather than one monster table these rare corruptions did not cause too much problems…MySQL with innodb_force_recovery=4 (SRV_FORCE_NO_IBUF_MERGE). So in my case probably Insert buffer merge…I could rebuild affected tables my “normal way”. So when dealing with Innodb recovery…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… only problem. There are fair amount of issues with MyISAM and generally on MySQL level which needs to be taken care of. Many… databases and handle data merging on application together with high availability and all kinds of problems. The dream for many MySQLers is to… there are summary tables and other tricks we use when such need arises but we still can’t deny – MySQL does not handle…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems…tables dramatically – merging say 1000 of users to the same table… table MySQL tries…table – generally there should be only few places when insert happens so it should not be big problem…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… will in many cases see…tables or sort memory. Though I’m not expecting this to come in the near future nor it would solve all problems – Storage Engines for MySQL quite commonly use its own memory allocation policies which may be hard to merry with MySQL… which is when merged together to show…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…tables, a secondary index reserves different extents from the clustered index. Q4: Does Innodb ever merges…the cases when self tuning gets it wrong. Q10: When Innodb …causing problems every so often. Q16: How Innodb decided how many …- it is global MySQL Server option, though it may have problems on …
