… terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row ***************************… latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec… larger than amount of memory. Blue Columns in this case is the default …
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…. These are covered pretty well in the MySQL manual here. Put simply, the events can … thread currently is, check the following in “show slave status\G”: Master_Log_File – last file … see if it is “r” or “b” column that is “scoring” most of the time. … – in the order of 10,000 iops. Questions? Comments…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…inspect the mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql_execute…, query_strip_comments = {buffer = 0×0, length = 0, buffer_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name = …{m_mutex = { mutex = [...] Great! The query is showing in there: “INSERT INTO testdb_N …
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…tool for visualizing collected data from the MySQL Slow Query Log. The name comes …first seen date; * custom reports, choosing which columns to show; * filtering queries by hosts; * filtering … displaying table status and CREATE statements; * reviewing and commenting on queries. Despite its lack of …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…add a where clause and search individual columns, and a ton more “database options” …almost 2x faster then combining memcached and MySQL, and about 20% slower then the all…to database based solutions. I think showing the performance of a couple of …#’s, but what else? Drop a comment and let…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…show index from antest; +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…have hundreds of such columns. Lets see how things look for MyISAM for same tables: mysql> show table status like “%bool%”… NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 2. row *************************** Name: cbool Engine: MyISAM Version: 10 …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… ADD COLUMN v VARCHAR(1); Query OK, 4194304 rows affected (1 min 1.97 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW…_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.01 sec) mysql> SET expand_fast_index_creation=ON; Query… Create_options: Comment: 1 row in set (0.01 sec) mysqldump Quoting the fast index creation chapter in the MySQL manual: “… you…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… would it be the right choice. I will show the results of executing benchmarks for different queries…DEFAULT NULL, `l_shipmode` char(10) DEFAULT NULL, `l_comment` varchar(44) DEFAULT NULL, PRIMARY KEY (`l_orderkey… to fetch the columns that are not part of the secondary key. Even though MySQL 5.6 uses…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…There are interesting results I want to show graphics with comments READ_PK_POINT Query: SELECT name … with only different the values of accessed column is stored in key. MyISAM and InnoDB…
