PDA

View Full Version : Unneeded SQL databases and processes.



Armadillo
02-23-2004, 12:27 AM
I've got four MySQL databases and four SQL processes running.
Only one of the databases is mine.
The others are called "mysql", "spheradb" (empty), and "test" (empty).
Can I delete them and/or stop their processes or are they needed for something?

Sometimes PHP and SQL is slow.

wildjokerdesign
02-23-2004, 07:36 AM
I'm not sure about all of them but I am pretty sure you need mysql for your other databases to work. Sphera is used by your Site Manager I think. The only one you may be able to get rid of is Test. I think that one is created when you install mysql and I think it is just that a test to see check that the install worked but not sure if it is not used by something.

FZ
02-23-2004, 10:30 AM
Don't touch the "mySQL" database! I think it holds username/password info, amongst other things. As for the others, as they are blank, I see no harm in deleting them, BUT if they are there, they must be there for a specific purpose - future usage maybe? If you can live with it, don't touch them either ;) As for the processes, they're all required as well. I think I have 2 or 3 mySQL processes running as well. I've tried killing the ones that appear to be redundant, but always landed up killing mySQL... Meaning all of them seem to be required. I think it's the same thing with Apache.

torrin
02-23-2004, 09:12 PM
I'm not sure about mysql, but the apache processes are not required. They are there for optimizing multiple connections, I think. You can change how many apache process are started in the config file. I'd assume that mysql is the same way, but I'm not sure. A search of the documentation on mysql.com doesn't get me any results.

In case you're wondering about apache, check out maxspareservers (http://httpd.apache.org/docs/mod/core.html#maxspareservers) and minspareservers (http://httpd.apache.org/docs/mod/core.html#minspareservers).

jalal
02-24-2004, 03:41 AM
I've got four MySQL databases and four SQL processes running.
Only one of the databases is mine.
The others are called "mysql", "spheradb" (empty), and "test" (empty).
Can I delete them and/or stop their processes or are they needed for something?

Sometimes PHP and SQL is slow.

Don't touch them!

Deleting the databases will make no difference to the speed of your machine. You can, if you want, delete the 'test' database, but you will not gain anything by doing so.
'mysql' contains all the permissions for your databases and MySQL won't run without it.
'spheradb' contains (or can contain) information for your Site Manager. It may be empty now, but it could be used either temporarily or for upgrades.

You gain nothing by changing the way things are, and run a very real possibility of disabling your site.

HTH