TMyServerControl exsample needed

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
TheLion
Posts: 39
Joined: Thu 25 Nov 2004 11:28
Location: Copenhagen/Denmark

TMyServerControl exsample needed

Post by 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

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

Post by 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

Guest

Post by 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

Post by 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.

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

Post by GEswin » Thu 18 Aug 2005 21:40

Attach a TDatasource+TDBGrid to the TMyServerControl and you'll see it filled with the variables.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by 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

Post Reply