 |
How much slowness do you observe (in terms of seconds or milliseconds)? |
 |
Hi, thanks for response, I see 26 seconds to load the full rackspace page and currently i have below entries. Rows: 126 Racks: 2461 Objects : 3500 |
|
|
This is much slower than expected for this amount of data. It looks like the database server does not have enough resources, please make sure it allocates enough RAM (at least 4-8GB). Here is a starting point to get this done: https://serverfault.com/questions/321805/best-mysql-cache-settings-for-8gb-ram-dedicated-mysql-server-using-only-innodb This may improve the performance a few times. In addition to proper memory sizing consider enabling query cache, which is off by default in MySQL 5.7. MySQL 8 lost the query cache feature, so if you need it, it will take either to downgrade to 5.7, or to migrate to MariaDB. It will also improve performance a few times. If the database server is the main cause of this slowness, the two measures above should make it about 10 times faster than what it is now. |
|
|
I am using MySQL5.7 and query cache is enabled, still i see the delay. Appreciate if you can help me to have multiple Rackspace Tabs main page, i may not need other tabs like...IPv4, IPV6 and other tabs in main page. |
|
|
It would help to understand the exact cause of the problem before trying to work around it. Does the MySQL server have enough RAM? During the 26 second delay what is the busiest element of the server (mysqld CPU, input-output, other process)? Did the problem happen at once or the performance has been degrading over a long time? |
|
|
If the problem is not important enough to explain, it is also not important enough to keep the issue open. Closing. |
- Anonymous
