From: <sinisa
Date: March 23 1999 12:01am
Subject: locking
List-Archive: http://lists.mysql.com/mysql/812
Message-Id: <14070.55782.385536.730022@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Adam Powell writes:
 > 
 > Hi, thanks for all your help in getting this working... I have upgraded to
 > 3.22.20 now, and its a lot better.  However we still have a LARGE problem.
 > 
 > We have an IP table that has SELECTs and INSERTs on the individual rows
 > about 80 inserts a second, and 1 insert every 3 seconds however sometimes
 > all the processes get locked because the selects are taking so long to go
 > through the table.  Does anybody have any ideas how we can configure it so
 > that the SELECTS and INSERTS can work together and not cause anything to
 > hang?  The table can be anything up to 2 million rows.... so it does take a
 > while to select.
 > 
 > Adam Powell
 > Click Agents Corp.,
 > Web : http://www.clickagents.com
 > Email : adam@stripped
 > Tel/Fax : +44 (0) 115 9532989

Hi!

At the moment most that you can do  is skip locking (if you use it),
add memory, CPU and increase all relevant buffers as much as possible.

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+