Title: 네이버 메일
 |
|
|
박찬민 (naracom2002) 님께 보내신 메일 <Re: Inserts during a long select?>
이 다음과 같은 이유로 전송 실패했습니다.
|
| -------------------------------------------- |
|
|
수신자의 메일 보관 용량이 가득차 있습니다. 나중에 다시 시도하십시오.
|
|
| -------------------------------------------- |
|
--- Begin Message ---
On Mon, Jan 21, 2002 at 06:32:28PM -0800, Eric Mayers wrote:
> I have a large amount of date that I need to select from in order to
> generate reports (might take 20 minutes). I also have data
> continuously being inserted.. I don't mind if the select results
> doesn't contain the recently added rows (or it can -- I don't care).
>
> I've searched the archive and found some promising leads.. (relevant
> snippets quoted below)
>
> "There is one expection, later 3.23 versions under special conditions
> can insert and select concurrently, but this is done in such a way as to
> avoid dirty reads."
>
> and
>
> "Note that this patch will allow you to have concurrent inserts as
> selects are running, but only if there is no holes after deleted rows in
> the able. In this case the insert changes to a normal 'locked' insert
> until all holes are filled. I have alread updated the online manual
> about this!"
>
> I just can't figure out what the syntax is (or patch I need to
> apply) in order to do this. Any help in this area would be
> appreciated.
Well, it's "built-in" now. No patch required.
If your table is a MyISAM table with fixed-length rows and no "holes"
from deleted records, you should be able insert and select at the same
time.
Does your table fit that description?
If not (and it cannot), you might consider using InnoDB tables which
have non-locking SELECTs. INSERTs will run just file while you're
doing other things.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 19 days, processed 440,704,157 queries (264/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--- End Message ---
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
