June 20, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…when I know the relationships between tables versus observing queries only.  An additional benefit is …6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0…. output A completed Relationships view of these three tables should look like this: Final Thoughts …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

…log enabled. The flexibility comes from the three variables that can be set to control…in MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables, according…”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

…. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or …query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query… in addition to those highlights.  For example, three tools were removed, and there were several bug…

Filed Under: Percona Software, Percona Toolkit Tagged With: , , , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… MySQL (configuration A, listed at the bottom of this post) and then tried three… –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL…query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

…-table ‘test_concat’ Data records: 3 – Fixing index 1 Data records: 6 And then, back in mysql: mysql> use test Database changed mysql> flush tables; Query OK, 0 rows affected (0.00 sec) mysql> select * from test_concat… Duplicates: 0 Warnings: 0 mysql> insert into test_concat (id,data) value (1,’one’),(2,’two’),(3,’three‘); Query OK, 3 rows affected…

Filed Under: MySQL

Post: On Character Sets and Disappearing Tables

June 21, 2012 By 1 Comment

…table in place.  The first table certainly proceeds well enough: (root@localhost) [oops4]> set foreign_key_checks=0; Query…tables; +—————–+ | Tables_in_oops4 | +—————–+ | dos1 | | dos3 | +—————–+ 2 rows in set (0.00 sec) “Oops” indeed. Where we once had three tables…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

….02 sec) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT… | 0 | +———+——————+——————-+ There’s only one row in the table that actually matches all three search terms, and in this case, both MyISAM…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Data mart or data warehouse?

July 15, 2010 By 14 Comments

… schema. The three table item/category/item_category tables in the warehouse schema example would be considered a snowflake. A dimension table (item) must… query execution, clustered tables and materialized views. These features make working with a star schema much easier than it may be on MySQL…

Filed Under: Insight for Developers, MySQL

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 Comments

…: mysql> create table > test.demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql… notice that the source table only has two columns, but the changelog contains five. All change logs contain three additional metadata columns…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 Comments

…and customers tables directly (the tables on which dashboard_customer_sales is built), then the query would take significantly longer (40+ minutes): mysql> SELECT…number of lines in the order_lines table, three orders of magnitude more quickly than COUNT(*). mysql> select count(*) cnt from order_…

Filed Under: Insight for DBAs, MySQL
« Older Posts