Restart MYSQL with @exec command

[waldbauer]

Hello !

I have an error handler for database errors. Now i have the problem that mysql sometimes goes away. For this issue, i reboot the mysql server every night with cron schedule job in taskmanager.

Now, i have a new idea. Why not restart via @ command the server in case of trouble ?

But my code doesn't work:

See:
function mysql_errorhandler($problem, $query = ""){
if ($problem == "MYSQL SERVER DOWN"){
@("net start mysql",$msqc1,$msqc2);
$startcheck="1";
}
}

What's wrong ??

[waldbauer]

..nobody has a solution ? Please, i need urgently information how to restart via command execute the mysql server.

[[deleted]]

WHy don't you just fix the problem with the database instead.

automatic restarting si a very bad idea.

[waldbauer]

...sometimes mysql server crashes completly, so i have to restart low level the service.

I thought a can run an @ command to start the service like above - some ideas ??

[[deleted]]

Restarting is pointless, you have to find what's causing the crashes.

Have you tried fixing the datafiles using myisamchk?

Have you monitorred the server's CPU load and memory usage?

[waldbauer]

...no, i cannot see anything wrong in the logs. Just the server crashes sometimes (not very often) so i decided to make a restart via @ command.

Now, at least do you know if it is possible ? I have admin rights on the server and the server is in house so i can make all neccessary todo's

[[deleted]]

Ofcourse it's possible, stupid but possible.

First, stop using the @ sign, it is not part of the exec() function, it just supresses any error messages, which is not what you want, ever.

Then try it and see what PHP says.

[waldbauer]

..ok thx, i will try it today.

i use it only in case of crash - so i have additional an error handler which checks up the return error code. think this will be the solution for me.