… try how much archive storage engine could help me in this case. Original Table: *************************** 1. row *************************** Name: requests_061111 Engine: MyISAM Version: 9… information about size on disk and compression buffer stage in memory should be readily available. So we have to go and… used by MyISAM. Summary: Archive storage engine does compresses your data and should be good for log storage or storing something which needs…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… we announce release 1.0.2-2 of our XtraDB storage engine. Here is a list of enhancements: split-buffer_pool_mutex… you have performance drops when data does not fit in memory. innodb_extra_undoslots InnoDB has a concurrent transaction limit of… further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’…; they contain a lot of useful information about compression, decompression, memory management, fragmentation etc. Beware that selecting from the tables whose…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… closed. Federated Storage Engine. This may have unbound memory requirements retriving result sets from remove queries. Blobs may require 3x time of memory. This… blob may require 768MB of memory. Storage Engines. In general storage engines may have their own per thread or global memory allocations which are not tuned…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of… in the documentation. What of course interests us is the MEMORY engine performance with this feature added. For that we run a…_INCREMENT, c VARCHAR(4096) NOT NULL DEFAULT ”, PRIMARY KEY (id)) ENGINE=MEMORY ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1; Also we modify the…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory… with this nice hardware and may be check out other storage engines and other workloads or get some profiling results.
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to…` tinyint(4) default NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=MEMORY and populated it with 1.000.000 rows ALL of… could delay writes and do all the changes directly in memory. MyISAM however had to perform number of random writes to…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… sort memory. Though I’m not expecting this to come in the near future nor it would solve all problems – Storage Engines for MySQL quite commonly use its own memory allocation policies which may be hard to… amount of memory allocated for current thread in addition to global memory allocation. As MySQL is progressing the problem of memory allocation transparency…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… storage engines, which was before most of us remember. And at a minimum, most servers these days need to consider the added memory… keep going! Any stored code (triggers, stored routines, etc) uses memory to execute; so do temporary tables. The following query creates… there simply is no formula to compute the maximum possible memory usage, and there cannot be because there are some things…
Post: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
…`.`table_name` trx id XXXX lock mode S” in SHOW ENGINE INNODB STATUS. Another is created when adding or dropping an… only MySQL storage engine I’m aware of having fully crash safe DDL is MySQL Cluster (NDB). Proving that MEMORY is/isn’t…
