RT, I use the same query, explain the results
Mysql 5.5.8 5.6


But another server,
10.1.19 - MariaDB


Table structure is synchronous, mysql5.5.8 database to perform this operation only need to 2 seconds, 10.1.19-340 seconds of MariaDB also didn't come out, the results of a timeout, seek advice, 10.1.19 - MariaDB index ran to where go to? Don't how to explain? This is just a count (1) the query

CodePudding user response:

Don't need to think so much, who know the synchronization time what's the problem?

On the first reference to mysql, add the index to the MariaDB to say again,

CodePudding user response:

reference 1st floor yenange response:

don't need to think so much, who knows what it into the synchronous problems?

On the first reference to mysql, add the index to the MariaDB to say again,

In fact, I have to check, I wonder if the index is not the same, but the result is the index completely consistent,,,,

CodePudding user response:

The building Lord this two reads table, data is not the same?

CodePudding user response:

refer to February 16 reply: 3/f

the building this two reads table, data is not the same?

Yes, one is my test environment database, an online environment is a customer database, not as much as a natural data, but because the customer is a new customer I test environment data is more is that mysql 5.5.8 data is more

CodePudding user response:

MySQL and MariaDB, the data is different also, execute the plan may be different, of course

CodePudding user response:

What kind of SQL to stick