…with an error. Example: mysql> CREATE FUNCTION this_year() RETURNS INT DETERMINISTIC RETURN YEAR(CURDATE()); mysql> insert into t VALUES(…user-variables and then using it to perform writes. The issue is fixed only in…and we have gaps? Example: Imagine the table has this values on the auto incremental …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…function call. This function reads the meta-data stored in the Flexviews data dictionary. It returns…table. For complete refresh views which are ordered with ORDER BY, such as this one, this creates a ranking function…performance comparison For demonstration purposes, I did the following: Created…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables…table is checked and ready application gets error rather than stalling forever which allows application to become partially functional…CREATE statement with table created in Innodb dictionary but .frm not created… (returning …
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…performance of all caches compared to MySQL Server, by measuring just the time it takes cache to return… for MySQL Performance tuning ? Not surpising associative array cache performs the …) You need to create table test.test for MySQL Cache to work CREATE TABLE `test` ( `k…file with benchmark function…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…that ? Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality …For example you may get queries returning different result or getting different …MySQL version is taking a lot of time you may wish to create… up you can use mk-table-checksum to ensure data is …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…function on a large amount of input. Often times, the same function…parse time, respectively. Actually performance is a little worse… => ffc86c559e06009a743d891ce1e4fc4f [count(*)] => 512 ) 1427 rows returned (0.87930011749268s, 0….create six hash “buckets” in the table. This allows MySQL…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…table by using values of the columns participating in the equijoin condition. The hash table is accessed by using a hash function…table with a large table The SQL used for this test together with its EXPLAIN output as returned by MySQL…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…. It is however bad idea to use > mysql_ functions directly as well – I would go for … InnoDB table can have very serious and negative performance implications. Remember that if you don’t create either … right number of rows are scanned and returned. SELECT * FROM articles INNER JOIN users ON users….
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…was the reason for the high write performance of earlier versions. Traditional transactional implementations …back into MySQL to do things like open a table, create a session structure (THD) or create a … that the init function returns quickly, but the first queries that access PBXT tables may hang …
