Quote:
Originally posted by The One to Rescue
Quoted from the book "High Performance MySQL", chapter 6, "Server Performance Tuning" : "This all means that the first bottleneck you're likely to encounter is disk I/O."
However, thread handling also seems to be an issue, and it seems to be a FreeBSD flaw : "Another popular free operating system, FreeBSD, has threading problems that are much worse. Versions prior to 5.2 provide rather weak native threading. In some circumstances, I/O-intensive threads are able to get an unfair amount of CPU time, thus keeping other threads from executing as quickly as they should. Given the I/O-intensive nature of some database queries, this has a rather devastating affect on MySQL."
(EDIT : by the way, I don't know what the thread handling scheme is, in Mac OS X. Does it use an approach similar to FreeBSD? Anyway, seems like OS X suffers the same threading performance problems than FreeBSD)
Hope this will help...
Quoted from the book "High Performance MySQL", chapter 6, "Server Performance Tuning" : "This all means that the first bottleneck you're likely to encounter is disk I/O."
However, thread handling also seems to be an issue, and it seems to be a FreeBSD flaw : "Another popular free operating system, FreeBSD, has threading problems that are much worse. Versions prior to 5.2 provide rather weak native threading. In some circumstances, I/O-intensive threads are able to get an unfair amount of CPU time, thus keeping other threads from executing as quickly as they should. Given the I/O-intensive nature of some database queries, this has a rather devastating affect on MySQL."
(EDIT : by the way, I don't know what the thread handling scheme is, in Mac OS X. Does it use an approach similar to FreeBSD? Anyway, seems like OS X suffers the same threading performance problems than FreeBSD)
Hope this will help...
This issue is the thread handling. Disk I/O hasn't been a problem except for Firewire 800 on the Powermac. I forget which, either the reads or writes are slow.







for example using the word 'root' a lot when in australia is not a good idea...

I'll be careful next time!
... in any case you should be careful about learning english from me, because i speak a mixture of californian/ australian/ british/ malaysian/ singaporean english.