I am right now sitting in Introduction to MySQL Performance Tuning by Tobias.

Re-executing a command

We can use the -r option to re-execute a command.

For instance:

mysqladmin -ri 10 extended

will execute the command every 10 seconds

Open tables is the size of table cache.
Threads cached is caching of threads. When someone disconnects, we don't just throw it away.

If we have multiple queries at the same time, the number of tables opened will go up.

Brad of Live Journal has written a cool script called diskchecker.pl

Analyzing queries: Use the slow query log to obtain information about well, slow queries. One idea is to log all queries to CSV tables and then use them.

When enabling or disabling the slow …

Session by Laura Thomson, OmniTI. Laura is author of a number of popular PHP and MySQL books.

Session will be on security at the developer level and is written from a programmer’s perspective.

Many developers plug along without any knowledge that they have security problems, security awareness is a relatively new thing. This session is not about guru-level knowledge, it is about developer-level practices.

MySQL Security Basics

• Do not run your mysqld as the unix root user. Run it as a purpose-created user.Do not use the purpose-created user for anything else. MySQL root user is not related to the Unix root user.
• Set permissions on DB data files directory so that only mysqld user can access them.
• Disable symlinks to tables with –skip-symbolic-links unless you need them.
• Disable access to port 3306 except to trusted hosts.

…

I am sitting in Arjen's session titled "Optimizing MySQL Applications Using the Pluggable Storage Engine Architecture." Arjen has been covering the basics of how databases work and touching up on issues related to different storage engines.

[Notes that I need to transfer (blogger wasn't working)]

Key Buffers: Are only for MyISAM tables and not for InnoDB tables. Look at the current values
Key reads / Key read requests ratio should be 0.03. If the ratio is higher than this (.10) then increase the buffer. If its better than this (0.1) then we are wasting memory. If at 0.1, decrease it a bit.

The default settings are quite low on Linux. We can have multiple MyISAM key caches.

We can load MySQL key buffers into memory.

Different values of myisam_recover which can either be QUICK or BACKUP (If some corrupted tables are found, they are first backed up).

…

First tutorial of Monday morning at the MySQL Users Conference is Johan Anderson on MySQL Cluster Configuration, Tuning and Maintenance. Found a spot next to Giuseppe (the data charmer) and a power strip (which are in ample supply here).

Johan came with the cluster aquisition from Ericsson to MySQL in 2003 and works mostly as a consultant with other folks using MySQL cluster for telecom, search engines and e-commerce. Likes to keep it simple, or be sure to avoid areas where the cluster isn't the best (ie MySQL cluster isn't great at joins).

Johan starts with a general overview, using the typical diagram of the cluster nodes and walks through the pieces of the cluster. MySQL is currently working on a new feature where you can add a …

At our user's conference this week, Jim Starkey will be discussing his latest database engine, codenamed Falcon.  Falcon brings to MySQL Jim's 30 years of data management experience to create an engine that is optimized for modern scale-out applications with lots of memory. 

Falcon is ACID compliant with a multi-generational architecture that guarantees server-enforced referential integrity.  It's based on MVCC (which Jim essentially invented) so it keeps lock contention near zero, ensuring very high performance.  Falcon uses advanced B-Tree indexing and includes crash recovery.  Jim's approach has also been to make sure the engine is easy to use and automatically manages storage allocation so there's no need to manually reorganize things.

We'll be presenting Falcon in the context of the overall …

that is not beer

Well, I registered a while ago, but I picked up the conference satchel et cetera today. It's a canvas satchel much like LCA 2005, but with fewer goodies (and more paper). There is one cool thing -- I got to pick an O'Reilly book about MySQL to have in the bag. Interestingly, there is a SCAMP CD in the bag. That's Sco, Apache, MySQL, PHP/Perl. Hmmmm. Kinda in poor taste that one me thinks.

Everything else is cool. That is all.

Tags for this post: mysql() mysqluc()

Comment

Well, I registered a while ago, but I picked up the conference satchel et cetera today. It's a canvas satchel much like LCA 2005, but with fewer goodies (and more paper). There is one cool thing -- I got to pick an O'Reilly book about MySQL to have in the bag. Interestingly, there is a SCAMP CD in the bag. That's Sco, Apache, MySQL, PHP/Perl. Hmmmm. Kinda in poor taste that one me thinks.

Everything else is cool. That is all.

Tags for this post: mysql() conference() mysqluc2006()

Comment

So the last few days have been randomly fun. I’ve been to Fry’s several times to grab random bits and bobs. Things I don’t need, but now have. Hung out with Mikal and Stewart quite a bit, which is always fun. Had lots to drink, and have gotten some work done!

All that aside, today was reserved mostly for our CEO’s house party. It was highly fun, there was drink, great food, and even song!

Stewart by the bar

There was Foster’s beer! Haha. Go Australian export beer. And Morgan was caught having some. I got to meet so many MySQLers its going to be hard to remember them all. I’m sure by the time the UC is over, all will be well.

…

Me and my wife arrived safe and sound in San Francisco on Friday afternoon. The flight was long but not too bad. Early in the flight there was a lot of turbulence but the pilot warned us about it.

I have never been to San Francisco and much like Roland, its beauty and landscape swept me from my feet.

After arriving I went straight to Hertz to pick up a car that I had already reserved. Since
they didn't have the car I reserved, they gave me a free upgrade to Sonata, which I must say
is quite a car.

We drove to Monterey, CA to see my sister in law's family. The drive was very scenic. In the
way we saw (but didn't take) the exit for Mountain View, CA (Hint: Google). We were
literally starving by this time as we live about 2 hours away from Atlanta and after being
up since 4:00 AM, I just …