PHP and MySQL for Dummies (For Dumm By Janet Valade
 | US $10.62 End Date: Friday Jul-30-2010 3:47:43 PDT Buy It Now for only: US $10.62 Buy it now | Add to watch list |
Google TechTalks April 28, 2006 Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website. ABSTRACT Learn where to best focus your …
December 21st, 2009 on 4:06 pm
Checkout my MYSQL Brute Force
watch?v=dMIjDgWbF98
December 21st, 2009 on 4:07 pm
This is a really great presentation from a true MySQL pro (thanks Jay). It is a must for anyone interested in MySQL Performance.
Most of it still holds true, although it is 3 years now. A few things have happened, though, for example a number of new tools exist to make it easier discovering bad queries in your database – e.g. Jet Profiler for MySQL or Enterprise Monitor.
To stay updated with more performance stuff, do check out “MySQL Performance blog” and “Planet MySQL”.
MySQL rocks.
December 21st, 2009 on 5:01 pm
very much detailed and helpful….
December 21st, 2009 on 5:52 pm
i love the fact that the top three categories of performance issues are all related to the SQL code (DML & DDL) which is used to build and query the database; this has always been my experience; if properly programmed, even an unscalable server (MsAccess, SQLite, dBase, …) can be pushed to its theoretical limit of performance; if poorly programmed, even a scalable server (Oracle, MsSqlServer, Sybase, …) can bog down and become unresponsive;
December 21st, 2009 on 6:07 pm
Very informative…thanks
December 21st, 2009 on 6:51 pm
Wow, thanks guys