Not the answer you need?
Register and ask your own question!

Percona 5.5 (sorry to post here, there was no channel for 5.5)

stevejohnsonstevejohnson EntrantInactive User Role Beginner
hello,
I have a droplet on DigitalOcean, and i was using Mysql 5.5 with my ubuntu 14.04. Recently i switched to Percona (i used 5.5 as my mysql was 5.5). After replacing my mysql, i realized that my server was MyISAM instead of InnoDB.

I've read that MyISAM is not as good as InnoDB, and in my configuration i could see that Percona XtraBackup was not visible.

It should look like -
Engine: InnoDB Support: DEFAULT Comment: Percona-XtraDB, Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES
But it actually looks like -
Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO
As you can see, my configuration does not even support Transactions, which i dont feel very good about. But it seems Percona is actually running without XtraDB. Is this a bad thing? Any suggestions? Thanks!

Comments

  • stevejohnsonstevejohnson Entrant Inactive User Role Beginner
    UPDATE -
    I just checked and my app actually does a "ENGINE=MyISAM". Hence my DB is MyISAM.
    Now, i upgraded to Percona after having this table, so my Percona is MyISAM.. i don't have Percona XtraDB. What is it that i have? It says Percona but not XtraDB... Can someone tell me if this can be a problem, or should i roll back to the standard MySql Setup?

    I repeat, on doing "SHOW STORAGE ENGINES\G"
    I get :
    Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO

    Though on doing "mysql -u root -p" and logging into the system, i do see Percona.
    Any help is appreciated,
    Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.