Atomicorp

Hi,

Have a little problem:

After I upgraded mysql 4.0 (art) --> 4.1.12-1 (art) on FC2 / PSA 7.5.4 I have the following errors in mysqld.log:

050925 00:22:50 mysqld started
050925 0:22:50 [Warning] Found invalid password for user: 'chiara@localhost'; Ignoring user
050925 0:22:50 [Warning] Found invalid password for user: 'dbuser@localhost'; Ignoring user
050925 0:22:50 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone' doesn't exist trying to live without them
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Same problem on my 2nd server, also FC2.

Any idea ?
EDITED-----------------------------------------------------------------------
FIXED: forgot to run /usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
-------------------------------------------------------------------------------
sorry
Kind Regards,
Bart

I tuned my.cnf and httpd.conf a little bit, because mysql process was running at >90% cpu (1000 qps in mytop) and slowed down the whole server. I have 1GB Ram, but the recommended setting by Ivalics & others didn't make it and I had to limit max_connections to 200.

Now I wonder that I can't restart or stop postgresql, nor thru Plesk CP, nor by command line. Anyway, plesk is now running at 0.1 - 1.0 % cpu, yesterday (before the performance tuning) it was at 46% and almost freezing.

Also the last plesk update killed my httpd.include (blank !), happily I had took a copy before the update (recommended).

Bart

Id also suggest turning on query caching if you havent. Notes are on the mysql Projects page.