Multiple CPUs and MyISAM

2009-06-21 Thread Amr Mostafa
ade it to 5.0.x, if any, and whether the improvements are for InnoDB only or MyISAM too. Any suggestions or pointers are very welcome. Thank you. Kind Regards, -- Amr Mostafa

Re: Why is MySQL using /tmp?

2009-06-11 Thread Amr Mostafa
If I understand the manual correctly, it uses /tmp for creating temporary tables if their size exceed the smaller of tmp_table_size or max_heap_table_size, otherwise, it will create the temporary table in memory. So if tmp_table_size is set to say 10Mb, and MySQL needs to create a temporary table i

Re: high performance test data/test query generator

2009-06-06 Thread Amr Mostafa
roblem if it is mysql only. If not, I think >>>> I >>>> will write one. >>>> >>>> Peter Boros >>>> >>> >>> It is by no means the only such tool, but I have often use JMeter as >>> an all-purpose load-generation tool. It has good support for database >>> testing among other things.. >>> >>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html >>> >>> >> > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=amr.most...@gmail.com > > -- Amr Mostafa PHP Team Leader, Egypt Development Center amr.most...@egyptdc.comhttp://egyptdc.com +(2012)1700502 +(202)24052355/6

Re: Mysqldump alternative due to bug

2005-03-13 Thread Amr Mostafa
Check this one too: http://dev.mysql.com/doc/mysql/en/backing-up.html - Amr Scott Klarenbach wrote: Ya, all my tables are InnoDB unfortunately, and they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa <[EMAIL PROTECTED]> wrote: There is the mysqlhotcopy, it&#x

Re: Mysqldump alternative due to bug

2005-03-13 Thread Amr Mostafa
they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa <[EMAIL PROTECTED]> wrote: There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server

Re: Mysqldump alternative due to bug

2005-03-13 Thread Amr Mostafa
There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from tabl