Linked Questions
72 questions linked to/from Possible to make MySQL use more than one core?
4
votes
1
answer
14k
views
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 ...
- 141
254
votes
6
answers
446k
views
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 ...
- 2,944
63
votes
6
answers
85k
views
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 ...
- 1,451
39
votes
2
answers
65k
views
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 ...
- 1,271
24
votes
2
answers
24k
views
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 ...
- 510
12
votes
3
answers
34k
views
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. ...
- 121
6
votes
5
answers
68k
views
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 ...
- 349
6
votes
4
answers
43k
views
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 ...
- 197
14
votes
2
answers
58k
views
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 ...
8
votes
2
answers
38k
views
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 (...
- 1,513
6
votes
2
answers
10k
views
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 ...
- 205
10
votes
4
answers
26k
views
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 ...
- 285
11
votes
2
answers
22k
views
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, ...
- 307
6
votes
2
answers
6k
views
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 ...
- 1,425
12
votes
3
answers
5k
views
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 ...
- 290