…, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual SCSI RAID: [mysqld] long… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority… this check in the application. Just my experience. I know some big websites are using MySQL, but we had neither the budget…

… running MySQL 4.1 on RedHat Linux. The box has 2GB of RAM, it has dual 2.8GHz Xeon processors, and /etc/my.cnf… new row). Up to about 15,000,000 rows (1.4GB of data) the procedure was quite fast (500-1000 rows…