View Issue Details

IDProjectCategoryView StatusLast Update
0000396XMB1New Featurespublic2020-10-19 09:07
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionno change required 
Summary0000396: Optimization: SQL_CALC_FOUND_ROWS
DescriptionInteresting article here. I learned something new about MySQL.

[broken link]

This other article shows some pitfalls in that technique

[broken link]
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision

Activities

miqrogroove

2020-09-01 14:31

administrator   ~0000396

The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated as of MySQL 8.0.17 and will be removed in a future MySQL version.

Issue History

Date Modified Username Field Change
2010-12-07 15:26 miqrogroove New Issue
2010-12-07 15:42 miqrogroove Description Updated
2020-09-01 14:27 miqrogroove Description Updated
2020-09-01 14:31 miqrogroove Assigned To => miqrogroove
2020-09-01 14:31 miqrogroove Status new => resolved
2020-09-01 14:31 miqrogroove Resolution open => no change required
2020-09-01 14:31 miqrogroove Note Added: 0000396
2020-10-19 09:07 miqrogroove Status resolved => closed