June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than…

Filed Under: Insight for Developers Tagged With:

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…buffer pool. mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8192 FREE_BUFFERS: 1024 DATABASE_PAGES: 7163 OLD_DATABASE_PAGES: 2624 MODIFIED_DATABASE…

Filed Under: MySQL Tagged With: , , , , ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… Buffer pool hit rate 999 / 1000 This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb (… buffer pool is sized well – if you have constantly a lot of pages free, it probably means your active database size is smaller than allocated buffer pool size …

Filed Under: Insight for DBAs Tagged With:

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

…innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb…

Filed Under: Benchmarks

Post: How innodb_open_files affects performance

November 18, 2009 By 4 Comments

…than MyISAM tables. Though the difference can be related to the size of set of empty tables which is about 10 times smaller…innodb buffer pool which had to be flushed before recycling. First ran however was done with clean buffer pool…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… buffer hit ratio, and a host of smaller ones…we might make the database server faster overall,…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…buffer_size setting, but there are many unscientific approaches that are better than…

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

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

February 26, 2013 By 1 Comment

… here is to note that the InnoDB buffer pool for my 5.6 instance is 128MB – smaller than the size of my DIR data. So, with… “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw… change to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the default…

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

Comment: COUNT(*) vs COUNT(col)

April 25, 2007 By 45 Comments

…col) may actually be a lot faster than count(*). Consider this example (restarting … buffer pool usage: Total memory allocated 589194920; in additional pool allocated 714496 Buffer pool size 32768 Free buffers 32332 Database… if there is a smaller secondary index on the table, innodb is smart enough …

Filed Under: Insight for Developers Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…databases…smaller than…InnoDB buffer pool is set to 22GB, it’s much easier to see 22GB than…

Filed Under: Insight for Developers Tagged With:

Post: How much memory Innodb locks really take ?

July 13, 2006 By 11 Comments

…background – in Innodb row level locks are implemented by having special lock table, located in the buffer pool where small …), heap size 503104 So 503104 bytes are used to lock 1638400 rows, making it less than 3 bits … want to lock every row in your table/database which makes it even smaller problem…

Filed Under: Insight for DBAs Tagged With:
« Older Posts