MySQL is System Intensive...

thanksajdotcom

@thecreativeone91 said:

Why are you using mysql it has much more overhead in my experience than mariadb

Is there a way to convert from MySQL to MariaDB and how would I use that with Wordpress?

thanksajdotcom

Ok, installing MariaDB now.

scottalanmiller

@thanksajdotcom said:

Is there a way to convert from MySQL to MariaDB and how would I use that with Wordpress?

MariaDB is a fork. It's a drop in replacement. Most Linux install MariaDB and call it MySQL these days.

scottalanmiller

Maybe you have too many MySQL worker threads.

thanksajdotcom

@scottalanmiller said:

Maybe you have too many MySQL worker threads.

Umm, explain.

thanksajdotcom

@scottalanmiller said:

@thanksajdotcom said:

Is there a way to convert from MySQL to MariaDB and how would I use that with Wordpress?

MariaDB is a fork. It's a drop in replacement. Most Linux install MariaDB and call it MySQL these days.

Migration is complete.

scottalanmiller

@thanksajdotcom said:

@scottalanmiller said:

Maybe you have too many MySQL worker threads.

Umm, explain.

Look at how many threads of MySQL you have in your htop. Although htop is misleading, use top instead most of the time. Those are LWPs so not too big of a deal.

scottalanmiller

@thanksajdotcom said:

@scottalanmiller said:

@thanksajdotcom said:

Is there a way to convert from MySQL to MariaDB and how would I use that with Wordpress?

MariaDB is a fork. It's a drop in replacement. Most Linux install MariaDB and call it MySQL these days.

Migration is complete.

And.... are you seeing a difference?

thanksajdotcom

@scottalanmiller said:

@thanksajdotcom said:

@scottalanmiller said:

@thanksajdotcom said:

Is there a way to convert from MySQL to MariaDB and how would I use that with Wordpress?

MariaDB is a fork. It's a drop in replacement. Most Linux install MariaDB and call it MySQL these days.

Migration is complete.

And.... are you seeing a difference?

Too soon to tell. I'll let it run for a bit and we'll see.

tonyshowoff

What are you my.cnf settings? If you're giving too much space for indices in memory, caching, etc that could definitely be the problem. Some of the example my.cnf files are for MySQL-only servers, and you may have used one of those so MySQL is working as if it's the only thing, in other words.

Oh yeah and you have a boat load of threads, so again, we're back to my.cnf

Edit: @scottalanmiller mentioned that one already, he always beats me to stuff.

Yep. sql is really meant to indefinitely scale. When you see sql dedicated servers it's not unusual to see them always siting at 90% usage of resources.

scottalanmiller

@thecreativeone91 said:

Yep. sql is really meant to indefinitely scale. When you see sql dedicated servers it's not unusual to see them always siting at 90% usage of resources.

Exactly, if you have free space, they are designed to fill it. That's a good thing to be applauded, not a problem to be solved.

I always use MariaDB

tonyshowoff

@Aaron-Studer said:

I always use MariaDB

I never do. I have to say though that MariaDB has made some great improvements in the areas of replication and some indices stuff.

@Aaron-Studer said:

I always use MariaDB

I do sometimes but not always. Many applications will only use Oracle or SQL Server schemas.

scottalanmiller

I only use MySQL or MariaDB for things like WordPress. In general, they are not my go to choice for anything.

scottalanmiller

@thecreativeone91 said:

@Aaron-Studer said:

I always use MariaDB

I do sometimes but not always. Many applications will only use Oracle or SQL Server schemas.

Often with those choices you get PostgreSQL too, which would be my preference nine times out of ten.

tonyshowoff

@scottalanmiller said:

Often with those choices you get PostgreSQL too, which would be my preference nine times out of ten.

You can go straight to hell. That's right, an old rivalry that I can no longer justify.