For database maintenance recommendations, see the appropriate sections below.
The browser interface performance is poor (that is, it responds slowly). | |
The diagnostic snapshot for the Management Server shows that it is overloaded. | |
Increase the innodb_buffer_pool_size to 1 GB or more (up to 80 percent of the free memory). The default is 512 MB. |
For more information on MySQL performance, you can try
http://www.mysqlperformanceblog.com and http://www.oracle.com/technetwork/index.html.
Exception: com.quest.nitro.service.topology.LockTimeoutException: Error obtaining cache lock for object
Cause: This exception is thrown when a thread that is trying to update a topology object from a Canonical Data Transformation (CDT), times out waiting for a write lock on the object. If it takes a long time for the object to be updated, it is probably because the database is dealing with a heavy load.
That setting is beneficial in cases like the one described above.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center