Any and All MySQL questions here?

[Jim Carlock]

I have a couple questions about MySQL involving which
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
or so.

Thanks for your time.

Jim Carlock
Post replies to the group.

[Bill Karwin]

"Jim Carlock" <an*******@127.0.0.1> wrote in message
news:Fp*******************@tornado.tampabay.rr.com ...

I'm looking for minimal memory use on a Windows XP machine.
Which version would be best for this?
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
configuration low.

You should read this page to understand where the memory goes in the MySQL
daemon:
http://dev.mysql.com/doc/refman/5.0/en/memory-use.html

There are also some guidelines for server configuration here:
http://dev.mysql.com/doc/refman/5.0/...arameters.html
http://dev.mysql.com/doc/refman/5.0/...variables.html
And can anyone tell me if there's any favored links to MySQL tutorials?
The MySQL docs have a pretty good tutorial:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

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.
And one more question involves MySQL security issues. Any
one have a favored link for the security issues involved?
http://dev.mysql.com/doc/refman/5.0/en/security.html
And one last question, anyone know how to PULL the MySQL
version via PHP? I'll probably discover this within the next hour
or so.

There's an example given in a user comment on this page:
http://www.php.net/manual/en/function.mysql-connect.php

....
$result = @mysql_query("SHOW VARIABLES LIKE 'version'",
$this->Link_ID);
$row = mysql_fetch_row($result);
$mysql_ver = $row[1];
....

Regards,
Bill K.