June 18, 2013

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

April 4, 2011 By 20 Comments

…of the data at the time of the backup, upon restoration the backup may be ‘out of date’ since changes to the database… flexviews.add_expr(@mvid,’GROUP’,'customer_name‘,’customer_name‘); CALL flexviews.add_expr(@…time. Both of these views build in about the same about of time: mysql> call flexviews….

Filed Under: Insight for DBAs, MySQL

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

February 26, 2013 By 1 Comment

…are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20… According to the documentation, if we specify the name of a table that has a FT index …the behavior of my application unless I also make a nontrivial number of code changes. In part 2 of this…

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

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

March 4, 2013 By 7 Comments

… InnoDB results change? No, they are exactly the same, although the scores did change slightly. …database, and I used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name… the “WITH PARSER” modifier to specify the name of a UDF which references your own …

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

Post: How to create/restore a slave using GTID replication in MySQL 5.6

February 8, 2013 By 7 Comments

…MySQL keeps two global variables with GTID numbers on it: gtid_executed: it contains a representation of the set of…all-databases –single… variables like ‘gtid_purged’; +—————+——-+ | Variable_name | Value | +—————+——-+ | gtid_purged | | …of GTID: slave1 > CHANGE…

Filed Under: MySQL

Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera

November 26, 2012 By 4 Comments

… (>=51%) of the remaining nodes will remain Primary.  Non-primary clusters are the remaining minority and will not allow database operations. cnf This is wserep_cluster_conf_id — the version # of the cluster configuration.  This changes every time a… local node that the tool happens to be connected to. name The name of this local node (first 5 characters).  This is handy…

Filed Under: MySQL, XtraDB Cluster

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

…run MySQL 5.0 database with MySQL 5.1 with no problems in most cases. When storage type changes, … changes which got a lot of publicity over years is change of TIMESTAMP output format in MySQL 4.1 or changing …like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL version …

Filed Under: Insight for DBAs, MySQL

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

February 25, 2013 By 10 Comments

…for wanting a small MySQL database server: You’re a uni student who… assigned, usually together with a host name. While there, you could also assign…Re-connect to see if your password change worked as expected, and install Percona…, but those are outside the scope of this article. To check if mysqld is…

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , ,

Post: Be productive with the MySQL command line

December 21, 2012 By 14 Comments

… for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select count(*) from sakila; ERROR 1146 (42S02): Table ‘sakila.sakila’ doesn’t exist mysql> select count(*) from…

Filed Under: Insight for DBAs, MySQL

Post: Edge-case behavior of INSERT...ODKU

October 27, 2012 By 6 Comments

… the majority of the database was …. So, MySQL checks our…*** some rows omitted *** +—————————-+——-+ | Variable_name | Value | +—————————-+——-+ | Handler_rollback | 1 | | …of related unpleasantness. There is, of course, a trivial solution to this: just change…

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

Post: More on MySQL Error Messages

April 6, 2011 By 9 Comments

…of more annoying examples I ran into during last couple of days. mysql> drop database test; ERROR 1010 (HY000): Error dropping database…mask=”r::” fsuid=0 ouid=0 name=”/usr/share/mysql/english/errmsg.sys” The bad… because there are a lot of simple changes needed, plus many of message files would need …

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