Filr users experiencing delayed logins and MySQL appliance showing 100% CPU spikes
This document (7014283) is provided subject to the disclaimer at the end of this document.
Novell Filr 1.0.0
Novell Filr MySQL
- Connect to the Filr database (MySQL appliance) as user root:
mysql -uroot -p
Enter the MySQL root user password:
- Switch to use the filr database:
- Drop and then Create a new index for the SS_Forums table:
drop index internal_Binder on SS_Forums;
create index internalId_Binder on SS_Forums (internalId);
- (Optional) To verify that the new index has been created, use the following query:
show indexes from SS_Forums where Key_name = 'internalId_Binder';
- Exit mysql:
Note: Be aware that 'internalId' in all lowercase reads 'internalid'. Please make sure to write it as 'internalId'
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7014283
- Creation Date:12-DEC-13
- Modified Date:24-APR-14
Did this document solve your problem? Provide Feedback