Hi Dan I have an application that doing huge insert over web (HTTP) handled by PHP, when i use MySQL 4. Multiple thread doing insert to table is not really a problem. But NOT in MySQL 5.
You may test it self, imagine you have 1000 concurrent HTTP connection that hit your PHP script. Each PHP script is creating concurrent connection to MySQL and doing insert. And boom......in a few minute/seconds your MySQL will be hang. It's terrible for me. For MySQL4 yes, there's bug for multiple thread doing concurrent insert, but > Ady Wicaksono wrote: >> Dear Mr. Heikki and Team, >> >> Currently we hit by this bug >> >> http://bugs.mysql.com/bug.php?id=15868 >> >> It got worse on MySQL5 rather than MySQL4, since i failed to downgrade >> MySQL. Please give me idea to minimize the impact >> >> My client is very dissapointed with this issue >> >> Thank you very much >> >> > > Hi - > > I'm sorry, maybe I don't correctly understand the extent of the issue at > hand. > > Is it just the test that is failing? Is it possible that the test is > wrong, and you are just seeing erroneous results? > > Thanks > -dant > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
