Tag Info

New answers tagged

1

wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm sudo rpm -Uvh MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm sudo rpm -Uvh MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm sudo service mysql start ...


0

Not strictly an answer, but perhaps a very long comment: MySQL is very similar to Mac OS X versioning. Mac OS X was first released in 2001. MySQL 5.0 in 2005. It would be just as unfair to compare OS X El Capitan to 10.0 as it would MySQL 5.7 to 5.0. The History: Version 6.0 of MySQL was canceled, and 7.x is the versioning scheme of MySQL Cluster, ...


0

If you mean is MySQL Replication supported between 5.1 and 5.6, I have a very strong warning !!! DATETIME in MySQL 5.6 now has microseconds represented. When it comes to MySQL Replication, row-based binary logging on 5.5 Master cannot be properly handled on a 5.6 Slave processing a DATETIME. I wrote about this and provided an error log that demonstrates ...


1

I've confirmed this is a bug with MySQL/Oracle Support. They will update the public tickets when the internal fixes are ready. To summarize: MySQL replication is only supported between one release level (the second digit) and the next; e.g. between MySQL 5.1 and 5.5; 5.5 and 5.6 but not between MySQL 5.1 and 5.6. The documentation is mistaken when it says ...


1

That error is nonsequiter with regards to MySQL. This would especially be true if your Windows server crashed for reasons other than MySQL. There are ways to fix IRQL_NOT_LESS_OR_EQUAL. However, if you are reloading a mysqldump and it is the only reason Windows crashes, you may have to accommodate Windows until you fix the IRQL_NOT_LESS_OR_EQUAL error by ...


1

Yes you can use innodb_file_per_table = 1 for your slaves. Additionally take below points in your consideration If you have same version on MySQL on both Master and Slave. You can directly take backup and setup replication from Master to Slave by adding innodb_file_per_table = 1 on slave in my.cnf Please have a look at How to set Master Slave ...


1

They do the same thing, but there is a difference and a grave danger. Here is the difference: OPTIMIZE TABLE is done in the mysql client or in a mysql session. myisamchk is a utility, not a client. Thus, there are no table locking safeguards. Therefore, you should never run myisamchk -r -a -S in a live system. Otherwise, you can quickly (in fact, ...



Top 50 recent answers are included