User:Urban/MySQL

From Hastur
Jump to: navigation, search

This article is imported from the Hastur wiki. See the import log for details. Warnings:

  • Buried links.

I run several MySQL databases on my server. These are used for PhpWiki sites as well a mail account database.

Problems

Performance

The MySQL server has shut down on serveral occasions since no connections were available. This means that the PhpWiki pages are not available, and that the MTA cannot lookup email accounts.

Possible solution:

  • Increase number of connections from default 100 to 500-1000. Change the varaible max_connections.