MySQL AB and KernelTrap.org's Jeremy Andrews are partnering up to offer an online presentation titled "Achieving Optimal MySQL Performance For Drupal". Aiming to provide a better understanding of how to properly monitor and tune your MySQL database, the online Webinar will take place on Thursday, January 31st, 2008, at 16:00 UTC (11:00 am EST). The presentation will last 45 minutes, followed by 15 minutes for questions and answers. You can http://www.mysql.com/news-and-events/web-seminars/display-94.html">sign up for the free event here.
The presentation will offer insights into understanding your database's current performance. It will start by detailing some recommended methods for monitoring MySQL, measuring performance and isolating bottlenecks. Next, MySQL storage engines will be briefly discussed, offering tips on choosing between MyISAM and InnoDB. Finally, the talk will offer concrete details on how to actually optimize MySQL for improving Drupal performance.
Additional tips and hints for optimizing Drupal have been collected here and made available under the Creative Commons Attribution-ShareAlike license by the Drupal Performance Agency, a group of independent companies and consultants who are dedicated to improving Drupal performance.
Comments
How technical will this be?
I don't know too much about databases and, after reviewing your links, am wondering how technical this presentation will be.
I know enough to just barely be dangerous. ;)
OK, here's what I know. I know how to get into phpMyAdmin via my shared host's user interface, how to back up my MySQL database, how to add/drop tables, and how to restore a MySQL database. Not much more, but I can follow basic directions and can learn. Also, I'm currently on shared hosting at DreamHost, so I know there are limitations on what I can do to MySQL since I don't have control over the server.
So, will the discussion go over my head, or will someone with my limited database knowledge be able to follow along or at least make sense of some of the material? It it's too technical, thanks but I'll probably pass.
And thanks for the helpful PDF documents. Very helpful.
Walt Esquivel, MBA; MA; President, Wellness Corps; Captain, USMC (Veteran)
$50 Hosting Discount Helps Projects Needing Financing
I think that if you can make
I think that if you can make sense of the PDFs you should be able to follow Jeremy's talk.
--
Drupal services
My Drupal services
--
Drupal services
My Drupal services
How technical will this be?
Hello Walt,
As the presentation is only 45 minutes in length, it will not be as technical as it could be. I will be forced to highlight a number of different tools and procedures without the luxury of going into depth about all of them. I like to think that regardless of your skill level and current needs, the information will be accessible and interesting to all. However, be aware that the talk is certainly geared more toward someone that is managing their own MySQL server.
In the first section, will will be discussing SHOW FULL PROCESSLIST, SHOW GLOBAL STATUS, mytop, mysqlreport, top M, vmstat, sar, slow query log, no index log, and mysqlsla.
In the second section, we will focus primarily on MyISAM and InnoDB, briefly looking at Falcon.
In the third and final section, we will take a deeper look at mysqlreport, as well as discussing various caches and buffers, fixing slow queries, the devel module, and replication.
OK, thanks!
Thanks Killes and Jeremy! I went ahead and signed up.
And for anyone else needing to convert London time to your local time, here's what I use.
Walt Esquivel, MBA; MA; President, Wellness Corps; Captain, USMC (Veteran)
$50 Hosting Discount Helps Projects Needing Financing
Alternative to Java?
Good stuff.
Is there an alternative to having Java Runtime in the browser to participate?
--
Drupal performance tuning, development, customization and consulting: 2bits.com, Inc.
Personal blog: Baheyeldin.com.
--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba
Java
Sadly, no. To join the presentation in real time you will need Java. In a dry run, we verified that the presentation works with Linux, Mac OS, and Windows.
I will make my Open Office Presentation slides available afterwards.
slides
The slides are now available for download. I will upload the audio as soon as I get a copy, it may be a few days.
Audio
Audio files are now also available at the same link. (OGG and MP3 format).
Thanks for uploading the
Thanks for uploading the presentation Jeremy, I missed the Webinar, so being able to peruse the files at my own leisure is really handy. Thanks. :)
Also, someone is asking me for some general MySQL performance tips, I can point them to this presentation!
----
Web Design, GNU/Linux and Drupal.
Error
Broken link, can't download.
Is there any other links to download?
Will this be recorded? I am
Will this be recorded? I am so very interested, but am unable to be online at that time.
recorded
Yes, the audio will be recorded. I hope to make it available along with the slides.
Where can we find it?
I missed it unfortunately. Did you record it?
Read the entire thread.
Walt Esquivel, MBA; MA; President, Wellness Corps; Captain, USMC (Veteran)
$50 Hosting Discount Helps Projects Needing Financing
New Link?
Is there a new link to this? All of the links in the reply posts point to a performance blog which doesn't seem to have the audio or the slideshow.
Found it
http://tag1consulting.com/blog/jeremy/Achieving_Optimal_MySQL_Performanc...