How to check if DDMdb tables were converted to InnoDB

book

Article ID: 138715

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

How to check if DDMdb tables were converted to InnoDB

Environment

Release : 10.3.2

Component : Spectrum

Resolution

1. Run the following MySQL query:

SELECT table_name, engine FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='ddmdb';


2. Check the files under $SPECROOT/mysql/data/ddmd/ directory



In CA Spectrum 10.3.x release


The file extension is .ibd and the event table is partitioned, there are multiples event table files.



In CA Spectrum 10.2.x


The file extensions are .MYD and MYI and the event table is not partitioned, there are only two files (event.MYD and event.MYI).






Additional Information

How to connect to MySQL command prompt:


1. Open a bash shell (bash -login)


2. Navigate to the $SPECROOT/mysql/bin/ directory

cd mysql/bin


3. Launch the MySQL command prompt

./mysql.exe -uroot -proot ddmdb (Windows)

OR

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb -A (Linux)


Attachments