From: Javi <ja...@gs...> - 2004-03-20 18:20:20
|
Hi all. I enclose an improved version of MySQL plugin. New features: -Now MySQL plugin is configured through a MySQL section in lcd4linux.conf. (See sample lcd4linux.conf attached) -It uses persistent connections: connect on init and disconnect on exit. -Connection trackin: It checks whether the connection to the server is working. If it has gone down, an automatic reconnection is attempted. TO DO list : -Add a function to fetch data (not only the number of rows) from the database. -MySQLquery() function should allow either one or two arguments, if there is only one, use the database value from the config file, if there are two, use the second one as the new database name. -Add an argument to mySQLstatus funtion. The argument will indicate what to return:Uptime, Threads, Questions,Slow queries, Flush tables,... If uptime, return it Like: Days,hours,minutes Please send comments and feedback. Bye Javi. |