mysql + cache



Hello, I call  many requests select and insert with JDBC Connector.
Actually, my program is not blocked while the request is not processed.

So MySQL works with memory that explodes because I try to call about thousends queries by second. The updates are enqueued and mysql trys to work with the RAM.

So I would like to be able to manage mysql and desactivate this cache that tell it to write all requests on disk and block the caller while it's not done .

Can somebody help me ?

Thanks.
.



Relevant Pages

  • MySQL and cache
    ... I call many requests select and insert with JDBC Connector. ... So MySQL works with memory that explodes because I try to call about thousends queries by second. ... So I would like to be able to manage mysql and desactivate this cache that tell it to write all requests on disk and block the caller while it's not done. ...
    (comp.lang.java.databases)
  • MySQL and cache ?
    ... I call many requests select and insert with JDBC Connector. ... So MySQL works with memory that explodes because I try to call about thousends queries by second. ... So I would like to be able to manage mysql and desactivate this cache that tell it to write all requests on disk and block the caller while it's not done. ...
    (comp.lang.java.programmer)
  • Re: asp + mysql and simultaneous requests result in IIS 500 error
    ... > ASP pages send out simultaneous requests to another ASP page which in ... > ASP pages that put out requests to ASP pages which in turn try to ... > retrieve data from the MySQL database, I get a 500 error code. ... > caused by the DSNless connection? ...
    (microsoft.public.inetserver.asp.general)
  • Re: Why does SQL express 2005 take so much RAM?
    ... Have you checked your requests are not creating duplicate temp tables. ... We have both ms sql server & mysql acting as large warehouses for highly ... enough RAM!, but even that can be configured in mysql). ...
    (microsoft.public.sqlserver)
  • Re: Mysql does not answer to Java anymore!!!
    ... Rhino wrote: ... >> No, as i said, i can normally acces mysql from remote and from the ... > Perhaps the JDBC connector has an incompatibility with SuSE 9.1; ... > perhaps you should post to the MySQL mailing list and see if others have ...
    (comp.lang.java.databases)