…an eye on to prevent a problem before it occurs. For example, if you see a large number of long…why would you ever want to use MySQL…insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung on me, so…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…long as they don’t touch the same row. Row locks are held for modifications until the transaction commits and that takes an…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…so we don’t need to update the parent group row so often? INSERT…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… – it is an insert-intensive workload (which… experiment that long. So there we see…take into account: TokuDB results are not quite stable, that is why I also show 5-minute moving averages to TokuDB. So…, as TokuDB does time-based checkpoints….mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…long as the transaction is open. Since an… no wait. Does the fact …will block. Why? Because MySQL sees that …So much for the explanation, now let’s take…so it cannot really apply any other event. This was never an issue when the application was using MySQL…(0.09 sec) session1 > insert into t1 values(null…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…work on rows! Why would you break… is naturally an INSERT-only workload. The insertions into the… sets Shard-Query takes relational algebra to … that Shard-Query does not have to…database administrator. As long as all of… right now only MySQL storage nodes are …algebra rewrites So, here is an example of…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…workload. So benchmark…why to use a flash memory at all, when a battery-backed disk controller write-back cache does…MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an…how long will this take…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…INSERT…take most time to execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of does…so you will be able to see if only in certain cases query takes long…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… (NCPK – an auto_increment column… however it > does not always bring…so you do > not have all these problems with loosing data etc. Read more in my > Why MySQL… time to inserts, updates, and deletes…why you can’t remove the foreign key references on the slave(s) as long… columns will take up tremendous…
