You are heremysql
mysql
minor glitch installing mysql 5 on lenny
Looks like the mysql system tables were missing on my fresh install of Debian Lenny on my Acer Aspire 5520 laptop.
just run mysql_install_db , after this you'll need to get your mysql debian credentials back in line, these are usually stored under /etc/mysql/ (this is so mysqladmin etc will work again)
/usr/bin/mysql_install_db
WARNING: The host 'nine' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
Cheap and easy Drupal MySQL query log analyses and profiling
One thing that will definately improve in Drupal 6.x and onwards is the performance relating to database queries, It is not uncommon for a site which has the usual formula of a few views generated blocks, translation module and a couple of other miscellaneous views entries to suddenly push your site into the 200 to 600 database queries just to generate *one page*.
Fortunately Drupal is continously improving with its caching methods and data abastraction models so it doesnt always have to hit the DB for something simple, or get it to return multiple items in one hit, but i digress.
