Recently with the select query a more than 30 data tables, but finally show only about 10000 lines of interface, want to ask what this is because, is that the data buffer pool memory than the Mysql? Or is there any other parameters in the limit?

CodePudding user response:

Page is what language, Java or PHP or else, look at the background of the log,
Often, even if the page shows more than 10000 records, who see detailed look,

CodePudding user response:

Is the mysql database, is at the command line window of the query

CodePudding user response:

Query results above have a limit line attribute, is off by default and remove the hook can show all the lines