SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:21 AM
| ||||
| ||||
 Sharing memory tables... Hi... Maybe this is not possible in MySQL, but what I want to do is as follows: in database D, create a table X with engine=memory, and, assuming it's loaded at server startup, if another user is using database W for example, they could do a select against X in database D. Can do this in other databases, but couldn't find a reference in MySQL. Can it be done? TIA, Joe      |
|
02-28-2008, 10:21 AM
| |||
| |||
| Re: Sharing memory tables... You can reference the table using the db name: select count(*) from D.X. On Aug 2, 10:52 am, JoeT <trub...@yahoo.com> wrote: > Hi... > > Maybe this is not possible in MySQL, but what I want to do is as > follows: in database D, create a table X with engine=memory, and, > assuming it's loaded at server startup, if another user is using > database W for example, they could do a select against X in database > D. > > Can do this in other databases, but couldn't find a reference in > MySQL. > > Can it be done? > > TIA, > Joe |
|
02-28-2008, 10:21 AM
| ||||
| ||||
| Re: Sharing memory tables... On Fri, 03 Aug 2007 06:01:46 -0000, petersprc <petersprc@gmail.com> top posted like a moron and wrote: >You can reference the table using the db name: select count(*) from >D.X. > That directly selects on the database which looks at engine=memory to know how to work and yes, it will work, but I'm not sure that's what Joe means. Joe? >On Aug 2, 10:52 am, JoeT <trub...@yahoo.com> wrote: >> Hi... >> >> Maybe this is not possible in MySQL, but what I want to do is as >> follows: in database D, create a table X with engine=memory, and, >> assuming it's loaded at server startup, if another user is using >> database W for example, they could do a select against X in database >> D. >> >> Can do this in other databases, but couldn't find a reference in >> MySQL. >> >> Can it be done? >> >> TIA, >> Joe > -- gburnore at DataBasix dot Com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ | ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³ Black Helicopter Repair Services, Ltd.| Official Proof of Purchase ================================================== ========================= |
Linear Mode
