best configuration for TMyConnection and mySql server

[eduardosic]

Hi, all,

please, when Tmyconnection is very fast?

with Option.Direct := True or
with Option.Direct := false or Protocol = mpMemory.


based in the coreLab`s experiency with mysql, what the best configuration
for my.cnf and variables for a system with 512 mb ram?

[GEswin]

From my experience, using mysql 4.1.x under Suse Linux, i only change

max_allowed_packet = 16M

and add

skip-name-resolve

The first one if you work with medium/large blobs or retrieve lot's of records, and the second one is that when you connect mysql server doesn't lookup ip to find it's name (for user account settings). We had some experiences that when internet was down it takes minutes to connect.

I have more than 15 servers in production at different customers and they run very fast and smooth without any other change. Machines vary from p3/p4 servers to dual xeon's etc. Almost all with scsi drives, and from 512 mb to 2 gb mem.

mydac settings i just set Direct := True, and if they work over wan i active compression, nothing more.

[Ikar]

Usually Option.Direct := True is quicker.

> based in the coreLab`s experiency with mysql, what
> the best configuration for my.cnf and variables for a system
> with 512 mb ram?

It's hard to say. Try to ask this question to MySQL developers.

[eduardosic]

From my experience, using mysql 4.1.x under Suse Linux, i only change

max_allowed_packet = 16M

and add

skip-name-resolve

The first one if you work with medium/large blobs or retrieve lot's of records, and the second one is that when you connect mysql server doesn't lookup ip to find it's name (for user account settings). We had some experiences that when internet was down it takes minutes to connect.

I have more than 15 servers in production at different customers and they run very fast and smooth without any other change. Machines vary from p3/p4 servers to dual xeon's etc. Almost all with scsi drives, and from 512 mb to 2 gb mem.

mydac settings i just set Direct := True, and if they work over wan i active compression, nothing more.

Geswin, mySQL 5 running under linux is free?
or need a comercial licence? for my customers...

thanks...

[GEswin]

Well 5.x is opensource, the same as previous versions. Licensing issues i don't know them, but they are the same for 4.x as 5.x afaik.