While the function
SQL_CALC_FOUND_ROWS() worked for reference tables in MemSQL versions 4.x and earlier, in MemSQL 5.x, the same function results in a
Feature 'SQL_CALC_FOUND_ROWS' is not supported by MemSQL. error.
SQL_CALC_FOUND_ROWS() function was deprecated as of MemSQL 5.0.6, since it only worked for reference tables and not for distributed tables. MemSQL Engineering is tracking this feature, but there is currently no fixed timeline for its reintroduction.
SELECT COUNT(*) to determine the total number of records for a particular query