I just confirmed Ima newb :) ..That is because i was doing 90% of what he said not to do... I definitely learned alot ...Thanks for the upload....this post was awesome :D
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".
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;
I just confirmed Ima newb :) ..That is because i was doing 90% of what he said not to do... I definitely learned alot ...Thanks for the upload....this post was awesome :D
Volver888 9 months ago
MORE MYSQL videos please please
CoreLineager 1 year ago
very useful to me.. thanks
dave1x1 1 year ago
geeeeeks!!!!!!!!
nekinadimak09 2 years ago
This has been flagged as spam show
Checkout my MYSQL Brute Force
watch?v=dMIjDgWbF98
L2DragonHunter 2 years ago
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.
mysqlperformance 2 years ago 3
very much detailed and helpful....
fisher041082 2 years ago
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;
C7B27D7B4 3 years ago
Very informative...thanks
aloktherocker 4 years ago
Wow, thanks guys :)
suyuIdareliHarca 4 years ago