Robbin Zhang writes:
>
> Any detail on how to do this ? Can you give a few examples or a pointer
> to the doc ? Thanks !
>
>
This all is valid, of course fro 3.23.xx only !!
Say you have table Disk. In the startup script of mysql, after loading
a server you add a line of e.g. sleep 1 and then add a line in which
mysql monitor creates a HEAP table Memory, with the same structure as
a table Disk. Then it runs insert into Memory from select
Disk. Thereafter everything update, insert, delete, goes to both
tables, while selects are done ONLY from Memory table.
And continue like this for each table you would like to have in memory
!!
Rather simple !
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
