25.06.2018, 11:42
Post the table structure and what needs to be fetched.
Some documentation about what will be required for the query:
Limit rows to N: https://dev.mysql.com/doc/refman/5.5...imization.html
Order by asc/desc: https://dev.mysql.com/doc/refman/8.0...imization.html
It does not. The log plugin is threaded while writing to file but will still need to read from files in PAWN thread to show the last lines and as it was mentioned, this is not suitable*
*reading whole file once to know the number of lines, reading the file for second time to extract only N last lines.
Some documentation about what will be required for the query:
Limit rows to N: https://dev.mysql.com/doc/refman/5.5...imization.html
Order by asc/desc: https://dev.mysql.com/doc/refman/8.0...imization.html
Quote:
|
Originally Posted by Sew_Sumi
 even the logging plugin uses MySQL IIRC...
|
*reading whole file once to know the number of lines, reading the file for second time to extract only N last lines.