Linked Questions

Ask Question
18 questions linked to/from Using multiple cores for single MySQL queries on Debian
Hot Newest Score Active Unanswered
4 votes
1 answer
7k views

I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28 Is there a way to ...
Nyxynyx's user avatar
  • 1,131
142 votes
5 answers
257k views

I've been presented with some dedicated MySQL servers that never use more than a single core. I'm more developer than DBA for MySQL so need some help Setup The servers are quite hefty with an OLAP/...
gbn's user avatar
  • 70.3k
64 votes
6 answers
88k views

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
  • 1,481
26 votes
2 answers
10k views

I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
randomx's user avatar
  • 3,944
14 votes
2 answers
59k views

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
  • 933
10 votes
4 answers
26k views

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
12 votes
3 answers
5k views

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
10 votes
1 answer
9k views

my.cnf (5.5 and 5.1 is the same) : back_log=200 max_connections=512 max_connect_errors=999999 key_buffer=512M max_allowed_packet=8M table_cache=512 sort_buffer=8M read_buffer_size=8M thread_cache=8 ...
Koerr's user avatar
  • 251
5 votes
2 answers
4k views

We are running MySQL 5.5 on linux under VMWare, running on 2 CPUs. We are planning on increasing this to 4, but we have un-used CPUs available, and I'm wondering if there is any benefit to increasing ...
chris's user avatar
  • 1,232
1 vote
2 answers
13k views

The following has been observed using "mysqlslap". mysqlslap -u root -p --create-schema=matrix --query=monthly_kpi.sql --iterations=1 --concurrency=1 --delimiter=";" Benchmark Average number ...
Ravi's user avatar
  • 143
6 votes
2 answers
35k views

I'm trying to select the best configuration for our new infrastructure but got a bit confused about the results. I used sysbench v0.5 for the tests: prepare data sysbench --test=/usr/share/doc/...
cenk's user avatar
  • 163
6 votes
1 answer
5k views

I have some questions regarding upgrading from 5.0.88 to the latest version. Why should I upgrade? If so, which version should I consider? What are all the known risks? Is upgrading step by step ...
Devi Govindasamy's user avatar
  • 61
6 votes
2 answers
5k views

I want to migrate data between 2 InnoDB tables. Currently I'm running this query: INSERT INTO table_a SELECT * FROM table_b; If the dataset grows, what's the best way to avoid CPU overload? Thanks
Mich Dart's user avatar
  • 181
1 vote
2 answers
6k views

I had high mysql load on server linux 64 bit , 24 G.B ram , Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz , Alot of quiers in sending data mode Here is mysql status +------+--------------+------...
iLinux85's user avatar
  • 163
0 votes
2 answers
2k views

We have a typical master-slave set up. When we find ourselves under considerable load, the master grinds to a halt. The slave continues to march along all happy like. So during a recent slow-down, I ...
Alan C.'s user avatar
  • 347

15 30 50 per page
1
2