List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:January 6 2000 3:15pm
Subject:RE: CONCURRENT_INSERT?
View as plain text  
Steven Roussey writes:
 > Hi!
 > 
 > We are thinking of moving to 2.23.8 ahead of schedule, so I have even more
 > questions. :)
 > 
 > 1. Does the concurrent insert/select also work with replace/select?
 > 

Yes, if replace does not delete a row !!

 > 2. Is it better to mark records as deleted from an application point of view
 > (add a status column) rather than actually deleting them, so that their are
 > no empty slots?
 > 

Yes, but it will require lots of changes in your applications. If you
do not have too many programs, and have lot's of INSERT's, then do
it. Depending on your setup, may be 'deleted' column should be indexed.

 > I think we will still need to break our table into 50 subtables soon.
 > Breaking them into 10 has worked so far, but increased traffic has made that
 > solution stop working. MySQL jams, but once a table gets locked up too
 > often, all the threads start filling up and it never can catch back up. But
 > I think the update to 23.8 and the breaking the tables will let us survive
 > the next 2-3 months. :)
 > 
 > Monty and everyone else at TcX - thanks for all your work!
 > 
 > Steven Roussey
 > Network54 Corporation
 > http://network54.com/
 > 

You are welcome.

Try to avoid LOCK TABLE's if you can. 

Regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
CONCURRENT_INSERT?Dylan Neild13 Dec
  • Re: CONCURRENT_INSERT?sinisa13 Dec
  • Re: CONCURRENT_INSERT?Tonu Samuel14 Dec
  • CONCURRENT_INSERT?Michael Widenius5 Jan
    • Re: CONCURRENT_INSERT?Tim Bunce5 Jan
      • Re: CONCURRENT_INSERT?Michael Widenius5 Jan
        • Re: CONCURRENT_INSERT?Tim Bunce5 Jan
        • RE: CONCURRENT_INSERT?Steven Roussey6 Jan
          • RE: CONCURRENT_INSERT?sinisa6 Jan
          • RE: CONCURRENT_INSERT?Michael Widenius6 Jan
            • Re: CONCURRENT_INSERT?elble6 Jan
              • Re: CONCURRENT_INSERT?Michael Widenius7 Jan
RE: CONCURRENT_INSERT?Andy6 Jan