TMyServerControl exsample needed

TMyServerControl exsample needed

Postby TheLion » Thu 18 Aug 2005 12:01

Hi :-)

I am using Delphi5 and MyDac 3.55.0.22

I need to know how to get and set system variables like Max_Connections using TMyServerControl or something similar :-)

Best regards
Flemming Brandt
TheLion
 
Posts: 39
Joined: Thu 25 Nov 2004 11:28
Location: Copenhagen/Denmark

Postby GEswin » Thu 18 Aug 2005 13:07

Do a

Code: Select all
show variables


from a TMyQuery and you'll obtain variables from mysql server. Refer to mysql docs for more details about this.

Regards
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Postby Guest » Thu 18 Aug 2005 14:17

Hi :-)
I know the show variables command.

In the help file under TMyServerControl it only sais:
procedure ShowVariables;
Description
Use this method to show the current state of the server.
See Also
ShowStatus


I would like to know if it was posible to list/get a single variable and then set the variable to a different setting.
Guest
 

Postby Guest » Thu 18 Aug 2005 14:29

Hi :-)

I don't know what is wrong with the forum today!!! I look up in the corner and I can see that I (TheLion) am logged in. But when I submitted my answer It was as a guest!!!

But I would still like an exsample on how to set a system variable. I thought that it could be done through TMyServerControl.
Guest
 

Postby GEswin » Thu 18 Aug 2005 21:40

Attach a TDatasource+TDBGrid to the TMyServerControl and you'll see it filled with the variables.
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Postby Ikar » Mon 22 Aug 2005 08:14

Use SHOW VARIABLES LIKE 'Max_Connections' to get values and SET Max_Connections for setting.

Please see MySQL Reference for details
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components