MariaDB maximum number of tables
I am using MariaDB 5.5 for a local centOS server for a drupal 8 website. I have a problem with the maximum number of tables that mariadb allows me to have. Each time the number of tables is more than 230 - 250, there will be a database error in my website.
I want to know that is there any limitation for the number of tables? And how can I increase the maximum number of allowed tables? Thanks.
Answer Answered by Ian Gilfillan in this comment.
You don't give details of the error, but InnoDB allows something like 4 billion tables, so the limits you are experiencing are due to other resource limits (e.g. filesystem, memory) in your environment.