Page 1 of 1
best configuration for TMyConnection and mySql server
Posted: Thu 30 Jun 2005 15:42
by 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?
Posted: Thu 30 Jun 2005 16:19
by 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.
Posted: Fri 01 Jul 2005 11:07
by 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.
Geswin...
Posted: Wed 15 Mar 2006 22:02
by eduardosic
GEswin wrote: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...
Posted: Thu 16 Mar 2006 22:09
by 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.