How hard would it be to modify the MySQL code, and what sort of
performance hits would I take, if I was to try to run a hundred thousand
MySQL DBs on the same server? Obviously, some tweaks would be necessary
to be able to break up the directory structure of /var/lib/mysql, and I
may be souding un
I've got a table with two indices -- one is a datetime with massive
cardinality, and another is a varchar with only 9 distinct values. The
optimizer seems to choose the varchar over the datetime in all cases
unless I specifically say USE INDEX(). Is there some way to make MySQL
"smarter" in this
