Re: Fwd: differance between InnoDB and MyISAM tables ?

I put a change into the import(1) function for PHPList by changing 'replace' to 'insert delayed' and it seems to have actually SLOWED importing records. Thanks for your response. Creigh At 07:33 PM 8/24/2003 +0300, you wrote: Creigh Shank <[EMAIL PROTECTED]>

Fwd: differance between InnoDB and MyISAM tables ?

For example, does 'delayed' work with 'insert' and 'replace' like it does for ISAM and MyISAM tables? Creigh X-MindSpring-Loop: [EMAIL PROTECTED] Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: List-Help: List-Unsubscribe: L

Need For SPEED

Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create an e-mailing list for our 5.6 million book club members. Unfortunately, the import speed for importing records (at record number 150,000) is about 2,000 records per hour. We're running on the following: P4 (1.5 Ghz), 1.

Need For SPEED

Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create an e-mailing list for our 5.6 million book club members. Unfortunately, the import speed for importing records (at record number 150,000 the rate is about 2,000 records per hour). We're running on the following: P4 (1.5

Moving MySQL data to RAMDisk

On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysqld, /etc/php.ini and /etc/httpd/conf/httpd.conf (for DAV-lock)). MySQL seems to start ok, but when I use my

Re: Running MySQL in RAMDisk

wrote: plz forward the my.cnf inline to the mysql list... i got it uuencoded and it doesn't seem to want to decode for some reason... thanks.. On Mon, 18 Aug 2003, Creigh Shank wrote: Here it is. Included php.ini, too. At 10:49 AM 8/18/2003 -0400, you wrote: >If you can post your curren

Re: Running MySQL in RAMDisk

Mike, This is very helpful. Database consists of approximately 220,000,000 records. Raw data total (roughly) 5.5 GBytes. I don't know how large the database will be loaded (don't know about overhead, etc.) Running InnoDb. Probably split 90% read and 10% writees. If nothing else replication

Re: Running MySQL in RAMDisk

/2003 -0400, you wrote: Depends on db size... kinda risky putting it in memory if it's being updated and power goes bye-bye.. You should be able to get alot more performance just tuning my.cnf for a larger memory box.. On Mon, 18 Aug 2003, Creigh Shank wrote: > Have a very large database an

Running MySQL in RAMDisk

Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences? Creigh 305-541-1122 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

myslq.sock

It appears that an application I've been trying to run (RelataMail/Relata CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from the rpm) without having to rebuild the whole system? (Reinstalling MySQL d