I see the expected behavior from INSERT DELAYED, the server returns right
away and a new delayed thread gets created. I have noticed that my
application's internal queue flushes significantly faster with INSERT
DELAYED than it did with just INSERT, as expected.

Andrew



                                                                           
             robby chr                                                     
             <performancecode@                                             
             gmail.com>                                                 To 
                                       Jeff Smelser <[EMAIL PROTECTED]> 
             11/15/2004 04:07                                           cc 
             PM                        [EMAIL PROTECTED]               
                                                                   Subject 
                                       Re: myisam table corruption         
             Please respond to                                             
                 robby chr                                                 
             <performancecode@                                             
                gmail.com>                                                 
                                                                           
                                                                           




Is this accurate?  My understanding from the changelog in 4.0.18 was
that DELAYED is only ignored when using:

INSERT DELAYED ... SELECT ...

But not otherwise.  So unless he's doing that, that portion shouldn't
be an issue.  If you have alternative information, please let me know.
 Thanks!


On Mon, 15 Nov 2004 15:40:42 -0600, Jeff Smelser <[EMAIL PROTECTED]>
wrote:
> On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
> > insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was
taken
> > out.
>
> Course thats 4.0.18.
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to