Anyone using TONS of Query Cache for a high-traffic site?
Our search server is really sweating.
I was about to jump through a LOT of software loops to program
query caching at the app level, when I realized that MySQL had
it built-in already. (We're using newest: 4.0.18)
Seems we've got plenty
If I've got one computer with MySQL client and server on it, running everything
localhost,
but I want to reach out to another MySQL server, through an SSH tunnel, for some
things,
does anyone know how to differentiate between the two?
Usually, for SSH tunnelling, you access a port # at
Ack - sorry - can someone remind me the SQL format for this?
if you have a linked CLIENTS and INVOICES table...
...what's the query to find CLIENTS with NO INVOICES?
(say 'clientid' is the name of the field in both clients and invoices table)
I think it's some kind of join=NULL but I'm stuck.