… to start really worry for most CPUs. innodb_sync_spin_loops can be used to ballance between wasting CPU time running…, process no 3946, OS thread id 1151088992 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock… 368, undo log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign…
Comment: Using MyISAM in production
June 23, 2006 By 36 Comments
… size does not change so there is no “garbage collector”. MySQL may need to flush dirty key blocks every so often… inserts going in the table. What if you use –skip-concurrent-insert option ? This would show if it is related to concurrent inserts at all. Also MySQL running in the tight loop is actually…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
MySQL has useful extention to the GROUP BY operation: function GROUP_… without looping inside PHP: Table: CREATE TABLE services ( id INT UNSIGNED NOT NULL, client_id INT UNSIGNED NOT NULL, KEY (id)); INSERT…_concat: This should work faster, as we remove loop from PHP to MySQL server side. Also it can be handy to use…
Comment: To UUID or not to UUID ?
October 27, 2008 By 28 Comments
… as well. We are using MySQL 5.0 and InnoDB, we got badly lock conflict when inserting rows into InnoDB tables with…, which has a loop to insert a row into a table. the results for InnoDB are shown as below: inserting 100,000 rows…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
June 5, 2007 By 48 Comments
…(and confusing) way of doing things. In a typical MySQL way, when this does get invoked, it returns “2…on me — OLD WAY: 1. Insert 2. If error, then UPDATE. NEW WAY: 1. Insert 2. Engine discovers if it… http://php.net/ip2long – you can do a simple loop microtime test to see some STARK and REAL …
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…, a simple loop in the not at all exciting mysqltest language that will create 30,000 identical tables, insert a row into… reason. Without libeatmydata and using the default options for the MySQL test suite, I noticed that I was only creating about… 30,000 tables in a similar InnoDB configuration as default MySQL is pretty easy (easier than writing the mysqltest language that…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script to run whole loop of benchmarks http://www.mysqlperformanceblog.com/files….163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and… about. It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such…
Comment: Mystery Performance Variance with MySQL Restarts
February 20, 2013 By 18 Comments
I’d say it is unlikely to be MySQL itself, as obviously the code has not changed between restarts … system or even hardware behavior is triggered when the old mysql process shuts down (or perhaps when the new one starts… does not know about the insert buffer and the flushing of dirty pages, and the idle loop, it may seem counterintuitive that…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 23, 2012 By 33 Comments
… page needs to be freed – when readahead is done – when insert buffer merges happen and at other places. So its definitely…_seconds loop. The fixes you mention that are part of MySQL 5.6, should certainly decrease a lot of contention issues. MySQL 5…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…50, to match the client’s version of MySQL; they are very careful about upgrades. The RDS…innodb_buffer_pool_size 55050240000 innodb_change_buffering inserts innodb_checksums ON innodb_commit_concurrency 0 innodb…OFF innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_…
