New answers tagged

1 vote

Why did our AWS Aurora RDS spike and lock up?

SELECT thisstuff ( thistime ) AS thestuff , COUNT ( * ) AS count FROM mytable WHERE todo = ? AND someID = ? AND ( ( FIND_IN_SET ( otherID , ? ) ) || ( FIND_IN_SET ...
Rick James's user avatar
  • 2,533
1 vote

Unable to install Nectari's BILicense Server software on Windows Server

I used the SQL Server Profiler built into SSMS to capture the SQL the installer was trying to execute. This provided the filesystem (default) paths and CREATE DATABASE command that it was trying to ...
YDY's user avatar
  • 21
0 votes

MariaDB taking ages to restore backup

You could check the logs for lines like Could not increase number of max_open_files Please check your settings for LimitNOFILE and LimitMEMLOCK in Your /usr/lib/systemd/system/mysqld.service. After ...
sneaky's user avatar
  • 123

Top 50 recent answers are included