B4J Question Congestion problems with old MySQL 4.0 and connection pooling.

Discussion in 'B4J Questions' started by vfafou, May 24, 2015.

  1. vfafou

    vfafou Active Member Licensed User

    Hello!
    The following refers to changed Custom Web Socket Framework.
    Is it possible to place in a queue the Events called from clients?
    I have a database congestion problem when many concurrent clients are trying to login, because I do some queries in order to return to the clients their current status.
    The number of concurrent clients is between 50 and 120.
    The MySQL version is - unfortunately - 4.0 and it hasn't very good connection pooling support. I'm planning to upgrade it to MariaDB 10.0 or 10.1, within 1 month but I need to temporarily solve the problem because the system is on production.
    Thank you in advance!
     
    Last edited: May 24, 2015
  2. Erel

    Erel Administrator Staff Member Licensed User

  3. vfafou

    vfafou Active Member Licensed User

    Hi Erel!
    Thank you for your response!
    I have already done the configuration of the connection pool.
    A few hours after my previous post, I finally found where my problem was:
    I had created the two tables of the messages with XtraDB (InnoDB) storage engine.
    When the congestion occured, I simply changed the storage engine from XtraDB to Aria (MyISAM) and the congestion disapeared immediately!
    The database is MariaDB 10.0.14.
    The strange case is that I have optimized the database for InnoDB engine.
    It seems that the data flow is so fast that the transactional mode cannot handle it!

    P.S. I've just noticed that I have confused all the readers of this post. I forgot to mention that the old 4.0 MySQL version is the one that holds all my central application's data, and all requests from the websocket server are ended up there!
    The new MariaDB instance is the database of the websocket server.
    I was supposing that the problem comes from the old instance but finally was the new instance that was having a very big delay to deliver the answers from the old system!
     
    Last edited: May 25, 2015
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice