We are using mySQL for a data entry application. The application has 4 stages of data entry, whereby each one updates different table of the same database.
The number of columns available in each of the 4 tables is around 300. Insert statements are fired in during each stage of processing.
Per day (10 hour working day) around 3000 inserts are fired on each table. This happens in a sequence (stage 1 → stage 2 → stage 3 → stage 4).
The point to note is that over 10 days the number of records in each of these 4 tables will grow to anywhere between 30,000 to 50,000 records.
The number of connections to this database is roughly around 120-150. Concurrency might be in the range of 30-40.
Would like to know if there are any conditions under which the MYSQL server may fail? As the amount of data stored increases, will fresh data inserts start taking time? Will there be timeouts?
Any help in this regard would be of great help.
I am attaching the my.ini file that we are using.