June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4… a battery-backed disk controller write-back cache does the same thing. PZ: First …buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, …

Filed Under: Insight for Developers Tagged With:

Comment: MySQL Server Memory Usage

December 20, 2012 By 21 Comments

…_size = 8M bulk_insert_buffer_size = 8M query_cache_limit = 254M query_cache_size = 254M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = …mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended…

Filed Under: Insight for DBAs Tagged With: , ,

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

February 26, 2013 By 1 Comment

…mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql…mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql…MySQL 5.6, and that was to change innodb_ft_min_token_size… have a hard time recommending this feature to my…

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

Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server

December 29, 2008 By 6 Comments

…size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL…size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size…rare already and recommendation to fit at…

Filed Under: Benchmarks Tagged With: ,

Post: Goal driven performance optimization

December 22, 2008 By Leave a Comment

… For small and medium size applications you can log all requests to MySQL table for larger ones you…cache it, tune it, get more hardware in this order. It is often it is possible to get rid of some queries, cache…enough but for large scale application I’d recommend to looking down to 5 minutes or even…

Filed Under: Insight for Developers Tagged With: ,

Post: Percona XtraDB Cluster Feature 1: High Availability

January 17, 2012 By 20 Comments

…1. The Cluster consists of Nodes. Recommended configuration is to have at …that you can convert your existing MySQL / Percona Server into Node and…, you can continue to run queries on working nodes. The biggest …using caching mechanism on nodes. Each node contains a cache, ring-buffer, (the size is…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: Percona Server 5.1.58-12.9

August 17, 2011 By 2 Comments

… metadata of the file also (size, name, access time, etc.), but… not widely used. Instead, we recommend using the much safer LRU … adding a table to the cache, the server may evict and…MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying…

Filed Under: MySQL, Percona Software

Post: MySQL Replication vs DRBD Battles

April 28, 2008 By 12 Comments

…crash, meaning if your production database size growths load changes or you happen…memory and CPU cycles on double caching. Even in this case DRBD …the same time as running reporting queries on last month. All last month… recommend to use DRBD with MySQL ? There some good reasons to use DRBD with MySQL…

Filed Under: Insight for DBAs Tagged With:

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

…by case basics before recommending the move. Is MyISAM…for all long reporting queries. In case MyISAM …caching data, higher concurrency, background flushes while on the drawbacks side we see significantly large table size (especially if data size…common paths in the MySQL server – in particular …

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