myisam vs innodb

I’d suggest that you stay with MyISAM. The biggest reason for this is that InnoDB’s biggest feature is that it handles foriegn keys and dependancies, but there’s no coding in the WordPress system that sets that up (because MyISAM doesn’t support that, and almost all hosting servers use MyISAM by default).

Hi,

Can anybody please help? I am still looking for better answer.

We have large database and it slows down many times.

-Regards.

Suggest what? 800MB is not big for a database. I’ve worked with databases that were using MyISAM tables and were up a touch over 3GB.

If your database is loading slowly as you say then you should look at the indexing that you’ve got set up on each table and set up indexes that match the queries that are being performed. The only other way to speed up your database is to get a more powerful DB server.

well we have powerful server with 8GB of Ram and SSD Drive and we are on MariaDB latest stable version ..

em_term_relationships has 9,332,033 records.

We have customized wordpress to great extend. I mean we are using tags for great extend.

We have cache plugin running wp fastest cache for files and db cache reloded for database.

But I can still feel sometimes it takes time to load up specially the category page.

Is there anything to be tunned up in my.cnf?

Also we are on nginxcp.com

Please help.

What indexes do you have set up for your tables? Indexes will speed up queries more then pretty much anything else, so if you get those right your site will load faster.

But… If you’re using a decent caching pluign you won’t be hitting the database much at all, so there’s a very good chance that might not be your bottleneck.

I still think that database indexes are what you’d want to look at. Check the MySQL slow query log to see if anything shows up there, and run some profiling on the server to see what processes are actually taking the time instead of guessing that it’s the database.

how to use indexes can you please guide, I am completely unaware of it.

https://dev.mysql.com/doc/refman/5.5/en/optimization-indexes.html

https://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

Indexes can get pretty involved, and setting them up right is way beyond the scope of this forum. If you need anything more detailed than that you’d be best off trying a dedicated SQL/MySQL forum.

will you be able to do it as a paid job?

Can I have your skype ID?

Sorry, no. Paid support is not offered on these forums.

If yo uwant to hire someone a good place to start is here.