Hi, I'm using MySQL 4.0.20 on a fairly loaded server, running OpenBSD 3.5 (P4 3Gz, 2GB RAM, SCSI U160 36GB disks), and the database itself is around 8GB. There are a couple of large tables (>2.000.000 rows), but most of them are small.
The data is retrieved intensively, so we can build reports and manage our system. In order to gain performance, I thought that I could map the tmpdir to a MFS directory (512MB). I really think that this would speed things up. Although, I have come to a couple of questions that I was not able to find the answer at MySQL documentation... maybe you guys can help me: 1) How do I know, how much space am I using at the TMPDIR (when it is used, that is)? 2) What would happen in case of space starvation? Is that likely to cause a MySQL crash? Or it would just abort the resource-eater query? Thanks a lot! Best regards, RV Tec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]