2
votes
1answer
43 views

What is the differnent between transaction log and redo log in MySQL

I have read about MySQL. In my opinion, I see two log type is very similar. MySQL save how and when data is changed in log. Information is used for recovery of MySQL. I am confusing the function of ...
0
votes
0answers
63 views

How many days old log is stored in .mysql_history

I would like to know how many days old log is stored in .mysql_history in mysql server and also i want to know is it possible to find the date or time when the particular command or query is executed ...
5
votes
1answer
3k views

Whats the difference between Transaction logs and Binary logs?

Coming from a SQL Server shop, I now work with MySQL and I was curious. What are the differences between MySQL's binary log and MSSQL's transaction log? By the outlook thus far, it seems that there ...