Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » mysql restart problems....please help!!!
mysql restart problems....please help!!! [message #1383] Fri, 08 June 2007 08:37 Go to next message
JOKER78 is currently offline JOKER78
Messages: 2
Registered: June 2007
Junior Member
Hi guys,

Got some problem with mysql startup. I apologize for mistakes but i'm new of mysql.. so i need some help.

My machine:

P4 3.0 ghz
1024 mb ram
1tb hdd
windows server 2003
Myisam

I tried to configure the startup variables renaming my-huge.ini in my.ini.

But when i restart the service from Mysql administrator i get an error like : could not reconnect... or restart, or something like tht.

in the log the error is identified like this:

InnoDB: Error: Log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
Cant initiate database.
Aborting.

When i start with the my.ini file tht was created after the first (default) installation mysql starts without problems.


whats wrong with it.

some help??

thks

[Updated on: Fri, 08 June 2007 09:31]

Report message to a moderator
Re: mysql restart problems....please help!!! [message #1389 is a reply to message #1383 ] Fri, 08 June 2007 17:30 Go to previous messageGo to next message
JGilbert is currently offline JGilbert
Messages: 31
Registered: May 2007
Location: Chicago, IL
Member
sounds like you have permission / filespace issues.

Report message to a moderator
Re: mysql restart problems....please help!!! [message #1390 is a reply to message #1389 ] Sat, 09 June 2007 04:51 Go to previous message
JOKER78 is currently offline JOKER78
Messages: 2
Registered: June 2007
Junior Member
Hi JGilbert,

thks for your answer, i solved the matter erasing log file 0 and 1 from mysql folder.

The biggest problem now is tht (like before) mysql takes my cpu to 99% of utilization even for just one simple query.

I don't know how to optimize it...the system seems to hog!!

some help please?

thanks
Report message to a moderator
Previous Topic:SELECTs to slave, INSERTs to master by application?
Next Topic:connection optimization - simple question, I think
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 03:15:54 EDT 2009

Total time taken to generate the page: 0.05835 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.