busy site w/ high cpu usage on mysql

Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? thank you in advance

MySQL+InnoDB

hi i'm trying to setup mysql w/ InnoDB i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html and i'm end up with this in my log every time i run mysql and in addition it ends here is log file from first time i run mysql 010827 17:07:07 mysqld started InnoDB: The first

Re: MySQL+InnoDB

i deleted everything and re-run again and it started fine now.. weird.. - Original Message - From: ryc [EMAIL PROTECTED] To: alexus [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 7:56 PM Subject: Re: MySQL+InnoDB Yes. delete all ib_ files and all data files

Re: inaccesable mysql db from other users but root

not true.. one of the user was able to give himself all the rights inside of mysql db in user table - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: alexus [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 06, 2001 12:03 PM Subject: Re: inaccesable mysql db from

inaccesable mysql db from other users but root

hi is it possible to make mysql db inaccessable from other users but root? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

user accessing his/her own database only

hi again another security related question... is it possible to do so user won't be able to access anyone else's database but his or her own? thank you in advance. - Before posting, please check: