Tag Info

New answers tagged

0

This should give you a more nuanced view of the limits and usage select resource_name, current_utilization, max_utilization, limit_value from v$resource_limit where resource_name in ('sessions', 'processes'); From here


2

MyISAM or InnoDB? Your link does not say anything about SQL_CALC_FOUND_ROWS being slower. And I would expect it to be faster if for no other reason than having one fewer round trip to the server. The risk comes when you have thousands of rows. Then either method may be spending more time than you can afford. Come back when you encounter that; we can ...



Top 50 recent answers are included