June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I… to is this example: WHERE (k1.keyword, k2.keyword, k3.keyword) = (‘espionage’, ‘nuclear-bomb’, ‘ejector-seat’); This is okay because each correlation name (k1, k2, k3) is an index lookup.  Look at the EXPLAIN…

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

Post: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

…to customers of  your product. Namely, if your product is Open Source, you provide the …in. Customers should be able to choose who provides services for your product. Independent expertise…is not because everybody likes “free beer,” but because customers like freedom of choice. Everything here is my…

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

Post: Percona Live MySQL Conference 2013 wrap-up

April 29, 2013 By Leave a Comment

…great keynote, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related… Research very insightful. My major takeaways from those talks were: Oracle is investing a tremendous amount… and the Santa Clara Convention Center, to name just a few. Please mark your calendars…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , , , , , , , , , , ,

Post: SQL Injection Questions Followup

July 26, 2012 By 2 Comments

… in parameter naming are solved by ODBC interpolating parameter values before it sends the query string to be prepared. This is different… to find a security bug in my code? This is a big topic.  One simple answer is that you can try embedding a… did that, how would we store the legitimate name of a Mr. Order, who lives at 123 Union Street? If you are…

Filed Under: Insight for Developers, MySQL

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

Thanks for all, who attended my webinar, I got many questions and I wanted to take … is configuration for the arbitrator? A: You should use the garbd binary for that, is takes wsrep_cluster_address and wsrep_cluster_name as an argument. It will join the cluster, but won’t store or serve data. Q: Is the configuration file my…

Filed Under: MySQL, XtraDB Cluster

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

March 4, 2013 By 7 Comments

… | 0 | +——-+————————–+——-+ And with 5.6: mysql: SELECT id, full_name, MATCH(full_name, details) AGAINST (‘+james +peterson +arizona’ IN BOOLEAN MODE) AS… of it. My concern is that there are likely going to be people who believe that switching to InnoDB FTS is simply a matter…

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

Post: Quickly finding unused indexes (and estimating their size)

December 5, 2012 By 2 Comments

… customer recently who needed to reduce their database size on disk …their master and slave and loaded them into my schema as separate tables.  Then I simply created…name as index_name from all_indexes left join used_indexes using (TABLE_SCHEMA, TABLE_NAME, INDEX_NAME) where used_indexes.INDEX_NAME is…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…you’re not. It’s just like a mechanic who listens to the car and says “I hear …[percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without seeing all …is often more important than what’s included. For example, the absence of skip-name-resolve is easy to miss, as is…

Filed Under: Insight for Developers Tagged With:

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…important the patch is available for all the recent MySQL releases. To remind anyone who has not yet…file scripts/mysqldumpslow.sh patching file sql-common/my_time.c patching file sql/filesort.cc …SET or SET GLOBAL command. log_slow_filter=name Log only the queries that followed certain execution …

Filed Under: Percona Software Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

… have to do some awkward backpedaling with customers, who now expect realtime data.  The database giveth…do with the non-aggregated data?  My answer is usually simple: just don’t store it … is to build “flexible schemas” with tables that contain name-value pairs or something similar. The thought is…

Filed Under: Insight for Developers Tagged With: , , , ,
« Older Posts