Sounds like a very nice idea to me, but this could be a problem if temp
tables need to be bigger than RAM+Swap, which could easily be the case
in a table with 100,000,000 rows.
Gabriel PREDA schrieb:
For this table this is to late... leave it running...
If you want to do this on another table(s)... and in general on huge
loaded MySQL servers I recomend the following...
Create a directory let's say /mnt/mem_fs
Mount in it /dev/shm use "tmpfs" as filesystem...
Now you have a directory that stores all the info in memory... if the
available alocated memory in consumed then it will start swaping...
but compute all values so that it dosen't...
In my.cnf set a MySQL directive like:
tmpdir = /mnt/mem_fs
This way MySQL will create temporary tables in memory rather than
creating them on disk !!!
I'm pretty sure you can figure out the speed improvment !
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
