Performance Management - myisamchk: [ERROR] unknown variable 'read_buffer=2M'

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

We are facing the issue described in "Can't launch NetOps Portal URL".

However after running the command to repair the database tables we get the following error:

[root@test]# myisamchk --recover /opt/ca/MySql/data/netqosportal/*.MYI
myisamchk: [ERROR] unknown variable 'read_buffer=2M'

Environment

Any release

Resolution

In order to address this issue please try the folowing:

1) Run below commands:

mysqlcheck -uroot -p -c netqosportal
mysqlcheck -uroot -p -c em
mysqlcheck -uroot -p -r netqosportal

Note: It will prompt you to the mysql password.

") Start the NetOps Portal services and try to login into NetOps Portal