I have hit a snag with our Omeka instance. We currently have 53,474 records in Omeka Classic Version 2.6.1. Last Tuesday, I uploaded 900 additional records via the CSV importer. Everything seemed cool until our cataloger started working. She notice that performance was sluggish, especially when saving. Yesterday, we were getting the error
omeka_db already has more than ‘max_user_connections’ active connections. Confirm that the information in your db.ini file is correct.
My server admin restarted mysql and httpd daemons as they were using a large amount of server resources. This didn’t help the situation. I also increased number of max_user_connections in my.cnf and that didn’t help either.
I undid the import of the 900 additional records and things seem better now. So my question is, have a I reached a limit with how many items the database can handle? would upgrading to omeka classic 2.7 extend things for me or perhaps migrate to Omeka-S? Any advice for where to go from here would be much appreciated. We are using Omeka as our image cataloging interface and access interface.
Thank you in advance! Jen AMNH Library Systems Librarian