… impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed… MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona …(Raghavendra D Prabhu). In case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, in some cases first…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed… MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… InnoDB, mysql tunning script gives below results for temp table , …TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables, 44% were created…table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL… better, coming in at an … buffer pool memory but still fits…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…in memory anymore. How does this affect performance? A: Typically you do not need all your indexes to be in memory… is 64 per table in recent MySQL versions. However …creating an index in every table you create? Example: CREATE TABLE user_competition_entry user_id (INT), competition_id(INT); The table…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…Table and the new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL…in memory. Furthermore I filled up the bufferpool enough to make sure that the server represents one that is in…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… row in set (0.00 sec) You can even go deeper to check which sessions have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…memory barrier, that is when we read the waiters field next, the read must be serialized in memory…sys_create_doublewrite_buf (trx0sys.c:265) ==9090== by 0x6BC76AD: innobase_start_or_create_for_mysql (…9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:6238…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…
