June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

…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, …

Comment: MySQL Server Memory Usage

…_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

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

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

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

size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQLsize=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…

Post: Goal driven performance optimization

… 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…

Post: Percona XtraDB Cluster Feature 1: High Availability

…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…

Post: Percona Server 5.1.58-12.9

… 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

Post: MySQL Replication vs DRBD Battles

…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

Post: Should you move from MyISAM to Innodb ?

…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 …