Linked Questions

4 votes
1 answer

Will mariadb use mutliple cores at all? [duplicate]

Good day. We have an 8 core server for mariadb 10.1 on Centos 7. IT's a production database as well as a replication master. I am not sure if it's using more than one of the cores. We also have a ...
Ed Greenberg's user avatar
254 votes
6 answers

How large should be mysql innodb_buffer_pool_size?

I have a busy database with solely InnoDB tables which is about 5GB in size. The database runs on a Debian server using SSD disks and I've set max connections = 800 which sometimes saturate and grind ...
alfish's user avatar
  • 2,944
63 votes
6 answers

About single threaded versus multithreaded databases performance

H2 is a single threaded database with a good reputation regarding performance. Other databases are multi-threaded. My question is: when does a multi-thread database become more interesting than an ...
Jérôme Verstrynge's user avatar
39 votes
2 answers

Multi cores and MySQL Performance

Importance of RAM is an established fact but far less material is available about the importance of cores and multithreading when it comes to the usage of CPU by MySQL. I am talking about the ...
Rick James's user avatar
  • 1,271
24 votes
2 answers

Percona vs MySQL

What is Percona? How does it differ from MySQL? When should we consider switching (or upgrading) from stock MySQL to Percona? To add some specifics in our situation we almost exclusively use ...
Noah Goodrich's user avatar
12 votes
3 answers

MySQL replication - slave is continuously lagging behind master

I am using MySQL-5.1.50 with a Master-slave replication setup. Most of the time the slave is lagging behind the master. When I run show processlist;, there is no query that's taking a long time. ...
adeela sahar's user avatar
6 votes
5 answers

MySQL Got timeout reading communication packets when reading federated table

I have two servers (solomon and serenity). Both servers are Windows Server (2012 & 2016), IIS, PHP (5.6.31), MySQL (5.5). On solomon I have several federated tables set up that point to tables ...
Vincent's user avatar
  • 349
6 votes
4 answers

MySQL using too much CPU

I'm studying to be a DBA right now because I have a massive live database that is very sensitive that I manage. Here's the current system stats of my dedicated database server: CentOS 5.9 24gb Ram 8 ...
Logan Best's user avatar
14 votes
2 answers

innodb_flush_method=O_DIRECT vs O_DSYNC performance impact on ext3 with LVM disk partition

In one of my production environments, we have two instances running on a RedHat cluster, with one production instance associated with the cluster. We have 125G main memory with 24G InnoDB buffer pool ...
Gopinath Karangula's user avatar
8 votes
2 answers

MySql recommended hardware

Our company servers are currently hosted on a VPS and we've decided to move into dedicated servers. When choosing the best hardware for a DB server, what should we invest more resources: better CPU (...
Ran's user avatar
  • 1,513
6 votes
2 answers

Query runs a long time in some newer MySQL versions

I have created a database on MySQL 5.0.15. I have a query and when I run this query on this MySQL version, I get 0.9 s run time. When I import this database to another MySQL server with same hardware ...
user3731's user avatar
  • 205
10 votes
4 answers

How to get the most out of MySQL on a QuadCore machine with 16 GB of RAM?

I'm running a MySQL 5.5 server on my workstation for scientific data analysis and wonder how to configure MySQL in order to get the most out of it performance-wise. The types of query that I typically ...
Steve06's user avatar
  • 285
11 votes
2 answers

Using multiple cores for single MySQL queries on Debian

I am running a MySQL server for tests on a VM (VMWare) with Debian as guest OS. The guest has four emulated CPU cores, so I set thread_concurrency to four. I am doing expensive joins on large tables, ...
Thomas's user avatar
  • 307
6 votes
2 answers

Recover accidentally deleted rows from a table

My client has accidentally deleted all the records of a table from a test database. This test database is in SQL Server 2005 Express and we don't have a backup. Is it possible to restore the deleted ...
RPK's user avatar
  • 1,425
12 votes
3 answers

Where is the INNODB Performance Leak?

I have a weird problem which I cannot seem to fix. I'm more an web programmer than a Server/DB Admin, so I hope someone here can help me. The Situation I am working on a system which handles a lot ...
M. Hirn's user avatar
  • 290

15 30 50 per page
2 3 4 5