Question : I have enabled SQL SLOW LOG Queries in my.cnf file but i need to restart mysql and when […]
Tag: mysql-5.0
Audit DML operations on MySQL Tables
Question : We have several MySQL 5.0 databases. We’ve been having security problems, like records being modified without authorization. We […]
Calculating percentage of count and adding it to the count in MySQL table with the query [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Audit DML operations on MySQL Tables
Question : We have several MySQL 5.0 databases. We’ve been having security problems, like records being modified without authorization. We […]
Cross Join and Left Join within a query
Question : I have query which has a cross join and also a left join which produces an error Unknown […]
Replication from MySQL 5.0 to MariaDB 10.2.8 – Unknown system variable ‘binlog_checksum’, Internal MariaDB error code: 1193
Question : We are finally upgrading our MySQL 5.0.90 environment to MariaDB, and we would like to enable replication from […]
How to know the current log sequence number in 5.0.X
Question : I would like to test the optimal value for iblog files on my mysql which is 5.0.77 I […]
Replication Setup what’s the value of MySQL auto_increment and offset in my.ini
Question : I have setup master master MySQL replication to sync changes in both servers. Now I want to setup […]
How to find dependencies on a table in mysql 5.0?
Question : I am trying to drop a table in MySQL but its complaining about “Cannot delete or update a […]
MySQL Table rename and Grants
Question : We are in the process of spring-cleaning our production MySQL 5.0 database, and this includes the renaming a […]