Search results for query: *

hi! i am working as a developer in an orgnization, and i have been assigned an extra duty to maintain the MySql database used for production purpose. As a database administrator what are the important things that i must keep track of to ensure that the database is healthy always! for i think...

hi! i am working as a developer in an orgnization, and i have been assigned an extra duty to maintain the MySql database used for production purpose. As a database administrator what are the important things that i must keep track of to ensure that the database is healthy always! for i think...

does mysql support ACID properties of transaction. i am working on version 3.23.52. How can i get informations regarding trasactions that take place in mysql server.

is there any way to calculate the execution speed of the query executed in mysql. where are the informations regarding the sql queries stored in mysql. in oracle we have system views v$sql etc. to provide such inforomations. is there any such similar way in MySql ?

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

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.

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

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)...

hi ! i shall make it a bit clear! i am designing a database monitor for mysql database using agent architecture! ie another application that takes these informations to be monitored from the mysql and produces necessary notifications . i will be creating the agent using c API's . Now which...

thanx william, but is there anything particular that can be obtained right at the moment when the database is started.

ya i have to create the agent using c.

hi ! apart from my previos post, i would also like to know the list of metrics that could be collected when the database server is started. ie. the informations obtained when the database just starts.

hi i am designing a software that would keep track of Mysql database health and notify any critical events ... i have two options at the very high level! - whether to start the agent <information provider> when the Mysql database is started or to keep the agent independent of Mysql.ie...