On concurrent updates in mysql

On concurrent updates in mysql

am 02.08.2010 01:04:45 von tristartom

--0016e64711a029130d048ccb1cac
Content-Type: text/plain; charset=ISO-8859-1

Hi, All,
Regarding mysql, I have problems on concurrent updates in the following
settings. I get a mysql server containing one database with 512 tables.
There is also a client who send concurrent updates to the server, each
update by a thread. As I increase the number of concurrent updates, I have
found the client program complains error
"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'test.viewtable_610_611' doesn't exist". However, as I checked afterwards on
the server, table "test.viewtable_610_611" do exist. I am a bit confused
about the problem here, and any idea is appreciated. Thanks
Regards,
Richard

--0016e64711a029130d048ccb1cac--