RE: best mysql optimization tutorial and/or quick start guide?

2009-03-05 Thread Stephen Edberg
> I've been poking around google looking for tutorials and/or quick start > guides on optimizing the mysql server. We just upgraded our DB server from > 2 > Gb of RAM to 16. But I don't know how to reconfigure mysql to take full > advantage of it. Although, just installing the RAM seems to have

Re: Show Databases issue

2009-02-15 Thread Stephen Edberg
On Sun, 15 Feb 2009, John wrote: > How do I disable showing ALL the databases on the server for a normal user > that only has access to a single database? So that when a user runs show > databases, they only get a list of ones they can access. I've seen this done > before. > > Sorry if it's a newb