Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-performance]

185 questions
0
votes
1 answer

Need help tuning Mysql and linux server

We have multi-user application (like MailChimp,Constant Contact) . Each of our customers has it's own contact's list (from 5 to 100.000 contacts). Everything is stored in one BIG database (currently 25G). Since we released our product we have the…
Newtonx
  • 295
  • 1
  • 4
  • 11
0
votes
4 answers

MySQL - moving to a lower performance server, how small can I go?

I've been running a site for a few years now which really isn't growing in traffic, and I want to save some money on hosting, but keep it going for the loyal users of the site and API. The database has one nearly 4 million row table, and on a 4 GB…
pedalpete
  • 113
  • 1
  • 2
  • 7
0
votes
2 answers

PostgreSQL lots of large Arrays and Writes

I am running a python program that spawns 8 threads and as each thread launch its own postmaster process via psycopg2. This is to maximize the use of my CPU-cores (8). Each thread call a series of SQL Functions. Most of these functions go through…
user84590
  • 147
  • 3
0
votes
0 answers

MySQL Tuning re Trigger issues. Tried everything

I have a table with a complex BEFORE UPDATE TRIGGER, that makes changes to itself, and several other tables. I’ve noticed that when the table experiences frequent use, that the trigger doesn’t update properly. Some rows are missing information. I’ve…
april_adams5
  • 1
  • 1
0
votes
0 answers

Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?

If I run the server as MySQL database. (Assume using the same MySQL version). Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?
Ryan
  • 5,341
  • 21
  • 71
  • 87
0
votes
1 answer

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes almost 20 seconds to return results. SELECT city_destination,distance…
Sahasrar
  • 3
  • 2
0
votes
1 answer

MYSQL: Many slave servers with smaller resources or less with larger resources

I want to create High availability with Master Slave replication (for Select query). I am wondering which one is better: Having smaller resources slaves but more servers or Having larger resources slaves but less servers I only use One Master for…
yodann
  • 101
  • 1
0
votes
0 answers

Efficient lookup from file in nodejs?

I am wanting to write a node application that looks up a bunch of blacklists from plain text files. Basically are all under directories representing different categories, and in each there is a file called domains which has a bunch of domain names…
jusschwa
  • 11
  • 2
0
votes
1 answer

Can SQL Server 2019 perform equally well under Linux and Windows (same hardware)?

We have recently installed SQL Server 2019 on a server, running Ubuntu 20.04 (server edition). Under our specific use case, executing integration testing against this SQL Server instance, it takes 2-3 times longer than executing the same tests…
01es
  • 101
  • 5
0
votes
1 answer

RAID 0 for Development

Hello fellow administrators, I am seeking high level guidance on the following situation: First the context of the environment: internal, all virtual (vmware), development use only, performance optimized across the full stack, down time is…
birchmeier
  • 3
  • 1
0
votes
1 answer

SQL Server performance expectations

Our development team wants us to investigate whether current hardware is adequate for the needs.The application they use has always been slow and they want to make sure we have no hardware bottleneck We are using following configuration for the MS…
Sergei
  • 1,216
  • 16
  • 24
-1
votes
1 answer

Best database (SQL\NoSQL) for storing file hashes and corresponding description

I am working on a system that store file hashes and a corresponding description basically, the structure is very simple just 1 table, HASH (key) and File Description. For example: 8F28067D10C64952F79542BF1EE349CB | Windows XP beckgrounf…
dave
  • 1
-1
votes
1 answer

Nagios server service_perfdata not saved at the good place

I have a server nagios on my Raspberry who monitored some Windows 7 client and i want to save the performance data of my service in particular file. So i have set the nagios.cfg for it : …
Thibzy
  • 1
  • 3
-1
votes
1 answer

SQL Server Express 2008 R2 limitations

When considering to use an Express Edition of SQL Server 2008 for a system that officially is only tested with full editions, what do I need to know about the limitations? Memory, connections? What about backup and restore features? Can I set up…
lox
  • 157
  • 1
  • 7
-1
votes
1 answer

MySQL runs at >=100% CPU, heavy disk I/O?

Recently my Debian Linux server has been experiencing slow web server response times. I've investigated and it seems that MySQL is the culprit, yet there are no slow queries indicated by the slow queries log and when I check SHOW FULL PROCESSLIST I…
Nick
  • 99
  • 1
1 2 3
…
12
13