From: Adam Powell
Date: March 23 1999 6:04am
Subject: Re: locking
List-Archive: http://lists.mysql.com/mysql/826
Message-Id: <003f01be74f3$55fd6f60$94937ed4@laptop>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Thanks a lot, this has helped, however now another problem has reared its
ugly head, and I suspect it could be a bug with mySQL is it happens every
time.  I have split up our IP table into 8 sub tables (this is working very
well - we are getting less records and correspondingly less load).

I run the command 'DELETE FROM <ip_table>' on a PHP script using a lynx
browser set up to go off every day.  This just clears the table for the day
and lets us start afresh.  However every time this runs mySQL crashes.  This
problem never occurred with 3.21, but since we have upgraded doing a 'DELETE
FROM x' where is there a large number of rows (some of the tables have
150,000 rows - but then again its not that much is it?) crashes the entire
system and leaves me with a phone call from irate people and having to get
up at 5am to fix it :(  It crashes when I use mysqladmin

I will look into some way of taking the table offline before I try to do
anything major to it... but has anybody found a good way of getting around
this?

Adam


-----Original Message-----
From: sinisa@stripped <sinisa@stripped>
To: Adam Powell <adam@stripped>
Cc: mysql@stripped <mysql@stripped>
Date: 22 March 1999 23:57
Subject: locking


>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   |
>+---------------------------------------------------------------------+
>