I've been running Drupal on OS X server and it works well. However I've had a problem that has been reported on the Drupal site as well.
SELECT mode, COUNT(*) FROM users GROUP BY mode; causes problems. The count returned is way out of bounds.
It returns a count of 864691128455135232. While a
SELECT COUNT(uid) FROM users ;
returns 12 - the correct number. The problem is that there are some places (in the import module for example) where there is a COUNT() instead of a COUNT(DISTINCT). For example in the import module the following change will resolve the issue. Change:
db_query("SELECT f.*, COUNT(i.iid)
db_query("SELECT f.*, COUNT(DISTINCT i.iid)