…used. Let’s seen an example, first we enable User Statistics in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select * from user_statistics where user=’root’\G *************************** 1…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…_id` (`country_id`,`state_id`,`city`) ) In this benchmark we used only read (SELECT) queries with different typical data access patterns: primary…(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… knowing everything about you (only one is billable, though)….CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core id : 3 cpu…elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If…not possible to use a patched binary, we can use MySQL Proxy, …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…audit often we log every query to find not only slow queries. A query may take less than … It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU- …terms of database size. The test was run with 1, 20 and 100 database connections Results To reduce …
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…R900, running Percona-Server-5.1.57-rel12.8 (…Using 24GB of memory for buffer_pool will give us fully in-memory CPU…only=on –rand-init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql…only CPU bound, let’s check CPU stats: regular tables: —–cpu—— us sy id wa st 1…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…5.00 sec) Since the data fits in memory speed is near constant and the single threaded operation burns one CPU… I’ll operate in only one dimension for the first example, just like the MySQL client. This … dataset where id between 1 and 1024 ) parallel_work; This allows you to use data flow semantics …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…MySQL 5…only Innodb tables so you may think there is no use…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…N possible index choices but only one index actually used. To some extent, MySQL 5.0 and later changed this…parent_id=0 AND t.status = 1 LIMIT 1 Finally, we can use index hints. Index hints are … graph had dropped several orders of magnitude and CPU utilization on the machine had dropped by about…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL… unsigned NOT NULL, `num_links` smallint(5) unsigned NOT NULL ) ENGINE=…only number of rows it needs to reach the LIMIT Sphinx mysql… to scale almost linearly using multiple CPU cores and multiple nodes…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…Intel(R) Xeon(TM) CPU 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (revision…field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE …use hint COMMENT ‘lookup’ for fields in InfoBright that have less 10.000 distinct values. I tried that, and it affected only…
