…MIN_TIMER_DELETE: 0 AVG_TIMER_DELETE: 0 MAX_TIMER_DELETE: 0 *************************** 3. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: sbtest OBJECT_NAME…SUM_NUMBER_OF_BYTES_READ: 361611264 SUM_NUMBER_OF_BYTES_WRITE: 326303744 or we can get top tables that required read IO mysql…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
… dynamic rows, however it is not very significant if number of columns is small. For large number of columns dynamic rows become …the query: mysql [localhost] {msandbox} (test) > select max(t1+0) from t99v1; +———–+ | max(t1+0) | +———–+ | 0 | +———–+ 1 row in set (3.26 sec) mysql […
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… number of concurrency tickets used for each: mysql> CREATE TABLE test_table ( -> id int -> ) ENGINE=InnoDB; — 0 Tickets Used Query OK, 0 rows… –num-threads=16 –max-requests=0 –oltp-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author_… | | 6739223639 | 1 | 2735703 | 139448919 | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,author_…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…time: 0.002886 Rows_sent: 1 Rows_examined: 655360 Rows_affected: 0 Rows_read: 655361 # Bytes…:10 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 … MySQL. The end result might be that you end up limiting the number…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…. mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | +———+———+ | 1 | 3088896 | +———+———+ 1 row in set (0.00 sec) How to factor numbers create table dataset ( id bigint auto_increment primary key, prime_number bigint…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…row count (the first number…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…: mysql> select count(*), min(FlightDate), max(FlightDate) from dim_dateG *************************** 1. row *************************** count(*): 8401 min(FlightDate): 1988-01-01 max(FlightDate… the degree of parallelism is controlled by the number of shards. — Q9 select Year ,count(Year) as …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet =… Amount of rows used was 20M, transactions were not used (autocommit), number of threads – 1,…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… numbers …rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m –max-time=900 –num-threads=8 –max…
