Hi all



We are using mysql server for our project. We are seeing a serious issue
with MySQL.



When the volume of records is of good size say 30K-40K every day, MySQL
Server starts crashing with some driver error. The log Shows

071011 5:31:24 InnoDB: Operating system error number 995 in a file
operation.



Based on our initial investigation we found that this issue comes if we do
frequent selects on tables with large volume of data. And in our application
we need to fire frequent select queries. There was a bug in MySQL around it
but its closed without any solution [ http://bugs.mysql.com/bug.php?id=3139
<https://webmail.clarussystems.com/exchweb/bin/redir.asp?URL=http://bugs.mys
ql.com/bug.php?id=3139> ].



If anyone is aware of this problem please let me know.

Do we have any workaround to avoid this problem.







Kailash Kanojia

Persistent Systems LTD.

Pune.

Tel +91 (20) 25678900

Ext : 5356

Cell : 9764164380,9850351499

"Real Happiness lies in making others Happy"






DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

MySQL LazyDBA home page