June 18, 2013

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… id 728899 localhost root Sending data select sql_calc_found_rows * from b limit …2 log writes are done to OS cache, and being sequential writes these logs …no. 10099, id 88021936, state: waiting for server activity Number of rows inserted 143, updated 3000041, deleted 0, read 24865563 0.00 inserts…

Filed Under: Insight for DBAs Tagged With:

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…| | end | 0.000007 | | Waiting for query cache lock | 0.000002 | | end | 0.000007 | … optimization disabled, and absolutely no effect on the optimized case…fragmented indexes because records are inserted in the correct order … > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real …

Filed Under: Benchmarks, Insight for DBAs, MySQL

Comment: MySQL File System Fragmentation Benchmarks

July 9, 2008 By 28 Comments

… cache, RAM size, front side bus speed, harddrive rpms, harddrive max write speed, and operating system. Also are you doing multiple inserts…-engine=MyISAM sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=100 query_cache_size=0 table_cache=256 tmp… inserts per transaction for 1 innodb table (25 inserts or .2 seconds of data to be inserted) I got 1121, 1133, and 1166 inserts…

Filed Under: Benchmarks Tagged With: ,

Post: Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

… slave.  No slave is chosen more than once.  If no slaves pass the… to use hints embedded in SQL comments, instead of instantiating different wrapper … approach with using a write-through cache? A: The InnoDB buffer pool … Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or …

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…full-text search, in the sense that the SQL required to run a MATCH .. AGAINST is the … Feb 20 16:09 FTS_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql 98304 Feb…, however, MySQL apparently has no problem with either of the following statements: mysql> insert into dir_test_innodb3 …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Comment: Why MySQL could be slow with large tables ?

June 20, 2007 By 141 Comments

…skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=…slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 … :) When we switched to PostgreSQL, there was no such issue. We do a “VACCUM” every *month…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

…used properly) help increase security against sql injection. > For example I have… database connection may become the issue. Caching should be > good help in this…BIGINT UNSIGNED will and gaining no benefit from it. I’ve…references may add processing time to inserts, updates, and deletes but there are …

Filed Under: Insight for Developers Tagged With: , ,
Newer Posts »