diff --git a/core/core.api.php b/core/core.api.php index 9f2f7f7..8f05ef1 100644 --- a/core/core.api.php +++ b/core/core.api.php @@ -607,12 +607,13 @@ * @endcode * * For cache bins that are stored in the database, the number of rows is limited - * to 5000 by default. This can be changed for all database cache bins: + * to 5000 by default. This can be changed for all database cache bins. For + * example, to instead limit the number of rows to 50000: * @code * $settings['database_cache_max_rows']['default'] = 50000; * @endcode * - * Or per bin (in this case we all infinite entries): + * Or per bin (in this example we allow infinite entries): * @code * $settings['database_cache_max_rows']['bins']['dynamic_page_cache'] = -1; * @endcode @@ -620,8 +621,8 @@ * For monitoring reasons it might be useful to figure out the amount of data * stored in tables. The following SQL snippet can be used for that: * @code - * SELECT table_name AS `Table`, TABLE_ROWS as 'Num. of Rows', - * round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM + * SELECT table_name AS `Table`, table_rows AS 'Num. of Rows', + * ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM * information_schema.TABLES where table_schema = '***DATABASE_NAME***' and * table_name LIKE 'cache_%' ORDER BY (data_length + index_length) DESC * limit 10; @@ -632,7 +633,7 @@ * Finally, you can chain multiple cache backends together, see * \Drupal\Core\Cache\ChainedFastBackend and \Drupal\Core\Cache\BackendChain. * - * @see https://www.drupal.org/node/1884796 + * @link https://www.drupal.org/node/1884796 @endlink * @} */