starting an agent along with the mysql server

[bakardi]

is it possible to start an agent or say an application along with the mysql server.

The libmysqld - embedded mysql server library makes it possible to run the MySql server inside a client application,.But in my case , where i am designing a database monitor, the client application (an agent) needs to run as a background process- while the whole method of using MySql database remains same.

that is u start and use the Mysql database as usual, with the only difference that now something else also runs in the backgound (the monitoring agent).

what are the class of libraries used to implement this, any idea???

 

[sleipnir214]

It sounds to me like all you really need is for both applications to start automatically, but that MySQL starts first.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[bakardi]

to put it simple ,

the database monitor should be implemented within the mysql server without having to restart it.

 

[sleipnir214]

Sounds to me like you're looking to add low-level functionality to MySQL. You can get the source code and modify it, but I don't understand why the monitor must be a part of the server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[bakardi]

ya ! i hope this could me more an integrated part of MySql server.
advantages can be :

all the critical events are tracked down ensuring timely notification!

what do u think would be the correct way to implement the moinitor considering only mysql.

 

[bakardi]

one more main important reason to use the monitor and MySql server as one is that mysql does not support triggers, hence certain events cannot be monitored such as:

dropped tables - names
number of times a table is visited
most quired table with name and count
server - number of restarts
server start up time**
most used database
query statistics - execution time, fasted query....
Connection performance
dropped user
user details - time since connected
table row lock monitoring
cpu usage per connection basis.