On concurrent updates in mysql

--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--
tristartom [ Mo, 02 August 2010 01:04 ] [ ID #2045388 ]
Datenbanken » gmane.comp.db.mysql.general » On concurrent updates in mysql

Vorheriges Thema: query results group/summed by interval
Nächstes Thema: strange authentication issue