Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-performance]

185 questions
1
vote
4 answers

Why database partitioning didn't work? Extract from thedailywtf.com

Original link. http://thedailywtf.com/Articles/The-Certified-DBA.aspx. Article summary: The DBA suggests an approach involving rigorous partitioning, 10 partitions per disk (3 actual disks and 3 raid). The stats show that the performance is…
user38311
  • 101
  • 1
1
vote
2 answers

What kind of database server should I use for a 500k stored procedure calls per day database?

I have a database that gets about 500,000 stored procedure calls a day in addition to other stuff. It's running too slow for us and we're going to upgrade it when we get around to it. I'm looking at Amazon EC2 as a solution and it seems alright.…
SteveGSD
  • 287
  • 1
  • 2
  • 6
1
vote
2 answers

Do I need to index a column that is an FK to a PK in a different table in sql server 2008?

I have a table that has fairly heavy queries. The column I am joining on is an FK to a PK in another table. This column seems to take up of the query time with a table scan which leads me to believe that SQL Server won't be able to use the index on…
Stewart Robinson
  • 1,145
  • 4
  • 12
  • 24
1
vote
1 answer

One user for all databases or different user for different databases?

I have multiple (Wordpress) websites that use different mysql databases. I would like to know if I should use different users for different databases, or just use one user (such as root) for all databases, considering only performance not security.
peter
  • 135
  • 6
1
vote
0 answers

What's the best approach to find out in doing what a Linux OS process is stuck?

Oracle DBA here! No experience at all in troubleshooting Linux performance... I need to identify the bottleneck in an Oracle database running on Oracle Linux. The same procedure runs fine on other VMs, so the problem is specific to a specific VM…
Massimo Pasquini
  • 121
  • 3
1
vote
0 answers

Would a flat or tree-like file structure allow for faster fetching of files by Path?

Would a flat file structure allow for faster locating/fetching of files by Path in an NTFS (Windows 10 File System) or would it essentially be as efficient as a highly structured tree with a bunch of subfolders? I'm using node.js to fetch a few…
Lex
  • 161
  • 1
  • 1
  • 7
1
vote
1 answer

postgresql - cache preferences per table/db

i'm curious if there is any way to hint postgresql which data should be more likely cached in memory. in my scenario the server would be handling mostly read traffic, whole data-set is much larger than available memory but some of the tables [ which…
pQd
  • 29,561
  • 5
  • 64
  • 106
0
votes
0 answers

mariadb main thread over 100% cpu and flushing logs

I have 5.5.60-MariaDB and noticed the main thread remains on sleep mode for the last 200hrs. After checking innodb status I see the below line for this thread. Main thread process no. 119014, id 140084875732736, state: flushing log pid 119014 is the…
Gaita
  • 1
0
votes
1 answer

MySQL bottleneck on AMD A-10 witn 12BG of RAM?

Running the identical python script that parses XML and inserts records into MySQL using MySQLdb package for python, I'm experiencing very different load times between a Mac Mini i5 with 8GB of RAM (OS High Sierra), and an HP Pavilion with an AMD…
I'm Root James
  • 202
  • 1
  • 12
0
votes
1 answer

MySQL 5.7 trying to improve performance

We have a PHP app running against MySQL 5.7 with innoDB. The app used to be really slow. MySQL takes 100% of the CPU for a really long time, for some queries. I tried running optimize table, which innoDB just interprets as re-create table. This made…
Moshe Shmukler
  • 207
  • 1
  • 8
0
votes
3 answers

mysql high cpu on dedicated server

we have a prestashop website running at dedicated server with 10K products, I have slow perfomance and looking htop found that mysql CPU is 100%. Dedicated Server CPU:Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz RAM:16…
teris
  • 25
  • 5
0
votes
1 answer

Database query response size - when is it too many kb?

I am a developer of e-commerce websites modules. The module displays some dynamic data (html) on website pages with ajax call. Ajax call gets html from database. 1 query for each page load. Database query response size is about 10kb. My client is…
ernest1a
  • 131
  • 5
0
votes
0 answers

MySql High CPU Low memory utilization

I am facing an issue with MySQL server. I am not a primary DB admin, so i might need some assistance in tuning DB. The CPU Utilization shoots up way beyond expectations. It just hovers around 70-90% of CPU. Where as the memory utilization levels…
kris123456
  • 101
  • 2
0
votes
1 answer

connections to postgresql at particular time frame

How can i find the connections made/utilized to my PostgreSQL at a particular given time frame ? In the PostgreSQL logs i am getting JSTERROR: canceling statement due to user request Sar logs : MEM AM kbmemfree kbmemused %memused kbbuffers …
Alex
  • 1
0
votes
2 answers

Mysqld.exe RAM size increasing upto 130MB and performance is poor

I have deployed my application with java 8 and mysql server. While running mysqld.exe takes upto 130 MB of RAM size and it stops increasing. But after that my application's performance is very poor. Can anyone help me in Identifying the reason…
user_1992
  • 1
1 2 3
…
12 13