Not the answer you need?
Register and ask your own question!

select found_rows() returns always 0 if 2 members are up

HenryTheSirHenryTheSir EntrantInactive User Role Beginner

i got Problems with our Wordpressblog and the Pagination function which uses a SQL Function: SELECT FOUND_ROWS(); This functions returns always 0 if both Clustermembers are up. It is no difference if the Statements are balanced to both Servers or only to one server - they will return 0 if they are both up. If I stop one of the members and the cluster_size is 1 the SQL Statement returns the correct numbers.

Any suggestions?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.