…Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB…aggregating per-day, an ad that gets a million impressions takes one row, and an ad that… can have the clicks column record the total, and the blue_clicks column record only blue clicks; to…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
… your suggestions about explain and force index use. The mysql 5.1 Manual Section 18.4 says –> This section …DB at all. The second App server has to interact with both the DBs, storing records @ 800 rps. deletion from NDB … – 4 secs for Query 1. Total Disk space used: 800 million records – 95 GBs.
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… some performance issue sine at least 10 months on a MySQL server. I am not an expert, I am doing some tuning… 4Go but the whole database size is almost 8Go (~60 millions records). This database contains some real-time information, so if the…/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…sec) Each year has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) …environment consisting of a single commodity database server with 6 cores (+6ht) and 24GB …, followed by a response time table recording the actual response times for each …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…Innodb updates buffer pool pages in memory and records page operations in the transaction (redo) log. …, etc., while a transaction may modify 1 or millions of rows. Also realize that a single modified…method in Percona server. In any case, if you run any kind of production MySQL server, you should be…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…, insert buffer which temporary stores records to be inserted in the… is about 4 million which means there are 4 million of transactions…you’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… table containing 4 million rows and one secondary key: mysql> CREATE …min 1.97 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+———–+ | Status | Duration | … post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…INSERTS: 1,000 2. UPDATES: 200 3. SELECTS: 1 million Since this is a predominantly SELECTed table, I…server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql…or come to its knees with the transaction record as mentioned above (a small fraction of …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…and Paul Elliott for access to modern multiCPU servers, without them I would not be able …/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records (about … The hardest query performs a scan of all million rows. General notes In general PBXT looks pretty…
