2

There is a reason you will need more RAM ... the INFORMATION_SCHEMA database. What has to get populated in it ??? Let pick just two tables as an example: INFORMATION_SCHEMA.TABLES INFORMATION_SCHEMA.COLUMNS Imagine (all the columns in the tables + the number of tables) multiplied by 3000 ??? The metadata would be need lots of RAM to map them out. This is ...


1

So you have 100GB of data held in 3000 databases? Each of those database is trivially small (I'd guess about 30MB each). I would seriously suggest that you need to reconsider your desire to segment / segregate your data in this way. It's almost certainly not the best way to do things. You're trying to run a Windows Server with only 4GB of RAM? I'm ...


1

This issue is related to the Search value not being a _ci charset. Json_search() allows case insensitive searches as long as your collation of datatable is _ci and you search parameter is _ci as well. To solve this in a stored procedure using prepared statement i had to do the following SET @theQuery = "select * from `theTable` where json_search( `...


Only top voted, non community-wiki answers of a minimum length are eligible