Hi Rick,
we are speaking about a 10 year old lagacy CMS System with over 1 Million PHP Files - so absolutely no - swapping mysql_* Interface is no option! ;-)
(I wish I could swap it ... for several reasons ...)
This CMS is running fine for 10 years now - but I try to tune some parts of it for better performance until a complete rewrite is done.
It's running fine with "SET NAMES" Query.
As you say - it's only called once per connection - but still is responsible for about ~11% of all Queries sent to MySQL Server. (See
http://temp.in.futureweb.at/option.jpg) - I know it's a minimal thing - but if I could get rid of this Query it still would be about 50+ Queries per Second less sent to MySQL ...
So my Question still stands ... it's not about "best practices" or how the CMS in general could/should be made better ... it's simply "can i configure MySQL Server so that it behaves 100% the same way as if i sent SET NAMES to it - without actually sending it ..."
Thx
Andreas