A great place to be!

February 2010 Blog Posts (3)

Sarah speaking at the 2010 MySQL User Conference

I'll be giving 2 talks this year. Here's a quick description:

Want Faster Queries?

Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.…

Continue

Added by Sarah Sproehnle on February 22, 2010 at 4:27pm — No Comments

Grant check for query analyzer

While working with the MySQL Enterprise Dashboard I found a small problem when trying to use the Query Analyzer. The test server I am running on had a user used by the dev team that had the following privileges:

GRANT USAGE ON *.* TO 'test_user'@'10.18.%' IDENTIFIED BY PASSWORD 'HASHNOTGIVEN';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW, TRIGGER ON `canoe`.* TO 'test_user'@'10.18.%';

GRANT SELECT on `mysql`.`proc` TO… Continue

Added by Chris on February 15, 2010 at 12:44pm — 2 Comments

MySQL Meetup Group - Back in the Bay!

The recently revived MySQL Meetup group had its first meeting. A big thanks to Venu Anuganti, our host and Schooner our sponsor. If anyone is interested in joining the fun please check out the Meetup.com site here.

During our first meetup we went over basic MySQL topics including configuration, performance tuning, locking, along with running MySQL in the cloud. All in all it was a well done… Continue

Added by Chris on February 6, 2010 at 11:52pm — 1 Comment