Program - Mysql hangs
Posted by: Philipp Druyts
Date: January 15, 2010 02:27AM

Hi all,
Let me explain the situation:
I have created a c# program which is an indexer, this indexer inserts rows in a Mysql DB. In the beginning everything went fine but after a month of indexing the program begins to hang randomly (it hangs at the insert command).
The database that is being created is very large (about 10 million rows a day), these are split over multiple tables (depending on what is being indexed). So now I have about 60 tables with some tables containing about 50 million rows.
I noticed the hang is resolved by making the the memory pool larger (now 7GB) but I will definitely run into it again when the DB grows ...
Does anyone know how to prevent/solve this?
It's a Mysql 64bit that is running on a Core I7 with 8GB of ram.
Can it be that the speed of the HD's isn't fast enough?
Or my DB design is flawed (as some tables contain millions of rows).

Any suggestions are welcome.
If more info is needed please ask.

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Program - Mysql hangs
January 15, 2010 02:27AM


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.