tag:blogger.com,1999:blog-6480555434853676325.post5676757080930180221..comments2023-07-13T04:04:51.867-06:00Comments on MySQL DBA - An Oracle DBA's Journey: Setting the MySQL Temporary DirectoryAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6480555434853676325.post-14985182313064450542009-05-22T11:48:02.706-06:002009-05-22T11:48:02.706-06:00Why not set the MySQL tmpdir to /dev/shm on Linux ...Why not set the MySQL tmpdir to /dev/shm on Linux systems? This is a 'partition' in RAM space and could speed up I/O considerably.<br /><br />Do note that the size of these partitions is limited to about half the size of total installed RAM memory. On properly scaled database servers this should normally not be a problem.<br /><br />Cheers,<br />Dennis van ZuijlekomAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-56205350844958813132009-05-22T10:30:52.717-06:002009-05-22T10:30:52.717-06:00Hi Greg, Its not just an issue of balancing the I...Hi Greg, Its not just an issue of balancing the I/O. Its also about making sure if a lot of temporary space is used that it cannot fill up the file system where the data resides.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-58590840185503384532009-05-22T09:14:25.278-06:002009-05-22T09:14:25.278-06:00Make sure to NOT set the TMPDIR path to the MySQL ...<I>Make sure to NOT set the TMPDIR path to the MySQL data directory filesystem.</I>Does this advice apply to RAID setups?<br />If so, why? I would think that data is being written to all disks by all file systems so the placement of tmpdir, or any other dir, shouldn't matter.<br /><br />GregAnonymousnoreply@blogger.com