MySQL Forums
Forum List  »  Performance

MySql Crashes - need a good my.cnf
Posted by: Javier Ciocci
Date: January 26, 2011 01:00PM

Hi There,

I am having issues with mysql server. Crashes few times a day and I think that Selects + Join are the problem.

This is the background and what is happening:

- I have 10 different websites that are connected to one databases.
- all websites are hosted in a share hosting and the databses is hosted in a dedicated server
- I recently moved the database from the Share hosting to a dedicated server, since then, i have been having this issue.
- I have a 40MB database where I have players, ages, cities, countries, events, etc. When I run the Select with Join it seems that mysql crashes.

I was wondering if anyone can provide me with a good my.cnf file to see the configuration.

the server is dual core with 2gb of memory.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySql Crashes - need a good my.cnf
2928
January 26, 2011 01:00PM
760
January 27, 2011 11:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.