June 19, 2013

Post: Using MMM to ALTER huge tables

March 27, 2008 By 11 Comments

…to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied…to apply application changes, the longer is the downtime. Our customer built his application so it automatically detects the new …

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

Post: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

… later more caution is required because you could screw your data, for example by specifying utf8 as default character set together… added more issues to the pile with a lot of data type and sort order related changes, this is why long needed… happening in area of marketing and taking money from the customers and have limited technical side ? Today I spent another quite…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Analyzing air traffic performance with InfoBright and MonetDB

October 12, 2009 By 50 Comments

… (e.g. time, lead owners, salesreps, territories, campaigns, prospects, customers, opportunity type/status, pricing, partners, discounts, on and on…), and in fact… SQL (you’ll see a lot of star joins). The data volume is piddling though. For schema complexity, I’m not…

Filed Under: Benchmarks, MySQL Tagged With: , , ,

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

April 4, 2011 By 20 Comments

… methods are complete refresh and incremental refresh.   The view type/refresh method are interchangeable since a refresh method is selected….get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41 min 52.04 sec) Data dictionary Here is a quick… stored in the data dictionary: mysql> select * from flexviews.mview_table where mview_id= flexviews.get_id(‘demo’,'dashboard_customer_sales’)\G…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… for data mining.  I wrote an earlier blog post which describes the differences between major schema types. I used the SSB data set at scale factor 1.  Scale factor 1 results in 587MB of raw data, mostly…_brand; And the schema: DROP TABLE IF EXISTS customer; CREATE TABLE IF NOT EXISTS customer ( C_CustomerKey int primary key, C_Name…

Filed Under: MySQL Tagged With: , , , , ,

Post: Beware the Innodb Table Monitor

November 29, 2011 By 2 Comments

…_ID: DATA_SYS prtype 257 len 6; INDEX: name ID_IND, id 0 11, fields 1/6, uniq 1, type 3 root… be stable, right? So, to my customer.  It may be important to note that this customer had a few hundred tables.  I… knew about were correct, and that the error messages the customer saw was apparently only transitory. However, as I was writing…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… being the magic bullet that would help these sorts of customers realize all of the benefits that have been engineered into… public-records-type information about each person. We’ll call this data set “DIR”, and it’s about 155MB of actual data. NOTE… type BIGINT UNSIGNED NOT NULL with a unique index on it, loading your data, and then creating the FT index after the data…

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

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

….89G 1.53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_… execution plans. a. Bad Plan id select_type table type possible_keys key key_len ref rows filtered … Rowid-ordered scan; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY,i_c_nationkey PRIMARY 4 …

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

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… index type that supports direct row-by-row updates.  But you would still have to update the RT index as data changes… all the data from the database into Solr and make it queryable from a browser within four days plus some customization on… of a reference that compares these technologies for different application types.  There are books that describe how to use one technology…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

…based on our analysis of several hundred customer downtime incidents, and their causes and preventions….replication is functioning correctly. Replicas have different data than their master. In addition to delay …will include more plugins to monitor more types of problems, but the current plugins …

Filed Under: Insight for DBAs, MySQL
« Older Posts
Newer Posts »