Hello everyone, I have a slowdown in my osticket system when searching for a specific name or moving from one page to another. Is there a solution?
luningarcia
There are a couple of things you can do:
ROW_FORMAT=DYNAMIC
innodb_buffer_pool_size
ANALYZE TABLE table_name PERSISTENT FOR ALL;
table_name
If you do all that and it's still slow you will just have to optimize MySQL/MariaDB (or give your server more resources so it can handle more load):
Cheers.