Monitoring MySQL queries

12 May

Monitor All SQL Queries in MySQL is a very nice (though short) posting about how to debug and monitor what’s going on inside your DBMS. There’s supposed to exist a similar tool for MSSQL called “Profiler”.

installing Funambol on ubuntu 9.10 x86_64 using MySQL as a backend

13 Feb

NOTE: this posting is still very incomplete!! make sure the 32-bit variants of Java and the corresponding MySQL-connector are installed: sudo aptitude install ia32-sun-java6-bin libmysql-java then, adjust the to use MySQL: —- ds-server/ 2010-02-13 16:54:13.000000000 +0100 +++ ds-server/ 2010-02-13 … Read More »

MySQL backup user

20 Jan

to create a user for doing automated backups of a MySQL installation that doesn’t have more than the necessary privileges, use the following statement: GRANT RELOAD, SELECT, LOCK TABLES ON . TO ‘backup’@‘localhost’ IDENTIFIED BY ‘some_reasonable_password’;