… Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5….) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE =… performance, so I went ahead to choose a table structure with no secondary indexes…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M… lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… Observations Sometimes both for MariaDB 5.5 and MySQL 5.6, the optimizer chooses the wrong query execution plan. Let’s take…
Page: Consulting for MySQL
July 31, 2006 By
… new versions to old ones. Storage engine development assistance If you’re developing MySQL Storage Engine, Appliance or Extensions we’re … application needs. Platform advice and support for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related …
Post: Indexes in MySQL
June 2, 2006 By 27 Comments
…) default NULL, `SUBNAME` varchar(32) default NULL, KEY `ID1` (`ID1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 SELECT COUNT(*) FROM t2; 250001 (V1… as I know Oracle alway chooses a full table scan if selectivity over 25%. What with MySQL: mysql> EXPLAIN SELECT COUNT(SUBNAME) FROM… scan is faster by 4.6 times. Why does MySQL choose index access? MySQL doesn’t calculate index selectivity, just estimates count of…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… it works with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of… combination with Shard-Query. Data set It was important to choose a data set that was large enough to create queries….02 sec) Each year has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) | +———–+ | 135125787 | +———–+ 1…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in… of problems in the server as well as the storage engine. For example, a pile-up of connections all trying to…, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL, replication… all the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL replication. The…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the … be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer pool size to something… the comments. By the way, if you’re looking to choose a good log file size for your workload, an arbitrary…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and …a cost-benefit equation. What are your priorities? Choose the solution that meets them. Be Careful …work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…length: 17217646764 Index_length: 11993816064 mysql> show table status like ‘dim1′\G *************************** 1. row *************************** Name: dim1 Engine: MyISAM Rows: 453193 Avg_…do index lookups in the two dimension tables. MySQL doesn’t want to choose this join order, so we’ll force it…
