20 million records is a lot of records!
Also, don't forget to change the memory settings for InnoDB in my.cnf.
InnoDB is a different table manager to MyISAM, and as such, has its own memory settings... so if you convert everything to InnoDB, allocate more memory to it, and less memory to MyISAM.
Maximo.
At 20:05 6/1/2003 +0200, you wrote:
Maximo Migliari wrote:Sameh,Thanx for ur help. But does the size enlarge by this amount? Also what about the time 10 hours I got to convert the table?
The right table manager to use (MyISAM or InnoDB) really depends on the type of work you are requiring of MySQL.
If you are mainly doing selects, and hardly any updates/deletes/inserts, then MyISAM is faster. Its indexes, as far as I know, are smaller and more efficient. However, when you start doing a little bit more inserts and updates, MyISAM starts to bog down your system. This is because MyISAM locks the entire table in order to perform a modification on it, only after the modification is "commited" does MySQL unlock the tables for read/write.
InnoDB on the other hand, does row-level locking. This means when a record is being updated/inserted/deleted, only the relevant row is locked, and the table can still be concurrently read and insert/update/delete operations can still take place for other rows.
This can majourly increase the speed of a database if there is big "mix" of queries. If you are working on something simple, and don't make too many inserts/updates/deletes, then MyISAM is best, as it takes almost twice as less space to store the data - and as you should know, the more data there is, the longer it takes for the physical hard drive to seek up the data and spit it out to MySQL.
Hope this helps!
Maximo Migliari.
--
Sameh Attia
Senior System Engineer
T.E. Data
--------------------------------------------------------------------- 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
