Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Any and All MySQL questions here?
- Jim Carlock
February 16, 2006, 3:35 am
rate this thread
version of MySQL to use.
I'm looking for minimal memory use on a Windows XP machine.
Which version would be best for this? And can anyone tell me
if there's any favored links to MySQL tutorials?
And one more question involves MySQL security issues. Any
one have a favored link for the security issues involved?
And one last question, anyone know how to PULL the MySQL
version via PHP? I'll probably discover this within the next hour
Thanks for your time.
Post replies to the group.
Re: Any and All MySQL questions here?
The version of MySQL matters less than the kinds of server configuration you
apply, and queries you execute. For instance, the MySQL server's key buffer
(a RAM cache that holds part or all of index structures) can be increased to
help performance (some people increase it to hundreds of MB), but if
performance is less important than minimizing memory use, then leave that
You should read this page to understand where the memory goes in the MySQL
There are also some guidelines for server configuration here:
The MySQL docs have a pretty good tutorial:
You can also Google for "mysql tutorial" or "mysql php tutorial" and find
dozens. I don't know if any one is favored over the others. Depends on
what you need to learn.
There's an example given in a user comment on this page:
$result = @mysql_query("SHOW VARIABLES LIKE 'version'",
$row = mysql_fetch_row($result);
$mysql_ver = $row;
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum