June 20, 2013

Post: How much memory can MySQL use in the worst case?

February 12, 2009 By 17 Comments

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

Filed Under: Insight for DBAs Tagged With:

Post: Trying Archive Storage Engine

November 12, 2006 By 7 Comments

…what table compression gives us: *************************** 1. row *************************** Name: requests_061111 Engine: ARCHIVE Version: 9 Row_format: Dynamic Rows: 8048913 Avg_…information about size on disk and compression buffer stage in memory should be readily available. So we have to go …

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… `INNODB_FT_DEFAULT_STOPWORD` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=MEMORY DEFAULT CHARSET=utf8 The docs tell us that we need… TABLE `innodb_myisam_stopword` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=InnoDB DEFAULT CHARSET=utf8 But, when we try to use…. Calculation of match score is completely different between the two engines; sometimes this leads to wildly different results. If you were…

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

Post: MySQL Performance on Memory Appliance

March 31, 2008 By 23 Comments

… a chance to check out MySQL 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 and also had a chance to… this nice hardware and may be check out other storage engines and other workloads or get some profiling results.

Filed Under: Benchmarks Tagged With: , ,

Post: Memory allocation in Stored Function

August 26, 2007 By 8 Comments

…auto_increment, `name` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=20971521 DEFAULT CHARSET=latin1 mysql> select …name))) from testf; and here is vmstat 5 output: procs ———–memory———- —swap– —–io—- –system– —-cpu—- r b swpd free buff cache…

Filed Under: Insight for DBAs Tagged With:

Post: 5.4 in-memory tpcc-like load

May 1, 2009 By 11 Comments

…-54-io-bound-benchmarks/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, and… no dips, and average performance is better. If Sun Perfomance engineers read this – I call attention to this problem and do… Sun started to make changes to InnoDB anyway. If InnoDB engineers read this and are interested – then, yes, we are ready…

Filed Under: Benchmarks Tagged With:

Comment: How fast can MySQL Process Data

April 11, 2008 By 3 Comments

I see you use the ENGINE=MEMORY. This also means that the count(*) you are doing is … wondering why you didn’t use an innodb storage engine and using the MEMORY storage type. I think every serious database user…

Filed Under: Benchmarks Tagged With:

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…

Filed Under: Insight for DBAs, MySQL

Post: XtraDB storage engine release 1.0.2-2 (New Year edition)

December 29, 2008 By 20 Comments

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

Filed Under: Percona Software Tagged With: , , ,

Comment: Flexviews is a working scalable database transactional memory example

May 19, 2011 By 3 Comments

… learn to do the very same for you…..Create a MEMORY table which is replicated with a single UNSIGNED BIGINT and… transaction…CREATE TABLE trx .trx id BIGINT UNSIGNED NOT NULL. ENGINE memory ..INSERT INTO trx VALUES 0 ..When ever you commit a…

Filed Under: MySQL
« Older Posts
Newer Posts »