If your MySQL server has hundreds of clients (applications) and tens of thousands of queries per second, MySQL default network settings may NOT be for you. Network performance is not often a significant factor in the performance of MySQL. That said, there are things to consider.
If you are building new applications make these changes now. Developer expectations are hard to change. My example below will break your application if developers open a database connections and then spend ten[Read more...]