The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
40 views

Advice about scaling out IIS and SQL Server 2014 on Windows Server 2012R2

We are running a dual processor server E5-2630 V3 / 64 GB RAM with Windows Server 2012 R2, this server has IIS and SQL Server 2014 installed, only one web service is running to serve a mobile ...
0
votes
1answer
31 views

max data transfer rate on RAID array

1) Let's say I have an array of twelve disc drives in a RAID-1 formation. That's effectively six drives presented for use. What's the maximum read rate I should be able to get out of that array? ...
1
vote
3answers
67 views

How to improve AWS RDS Performance - Heavy read write updates

After searching and reading as many posts, comments and discussions I could find I did not find one specific to my issue. I have multiple AWS EC2 deployments with a single RDS all in the same ...
4
votes
4answers
4k views

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored ...
0
votes
0answers
35 views

WordPress site with no traffic; MySQL reporting 300-500 queries per second, frequently crashing

My server is running Debian 7.10 (Apache 2.2.22, MySQL 5.5.47, PHP5). It's a VPS. I've tried to summarise the issue in the title. I'm running a very small, private WordPress blog which is only ...
8
votes
2answers
10k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
27 views

pgbouncer:is it OK putting on localhost or it's better on another server?

I'm about to migrate my (tiny) server farm to Google Cloud Platform and so giving the architecture a small restyling. One of the changes I'm about to commit is the introduction of pgBouncer, to manage ...
0
votes
0answers
10 views

How to show delta of a counter metric in PCP between time A and B?

For simple metric like disk.all.read it is enough to do something like this: $ pmval -a ... -S 11:50 -s 2 -t10m -r disk.all.read metric: disk.all.read ... start: Tue Feb 23 11:50:00 2016 end: ...
1
vote
0answers
32 views

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 MB/...
3
votes
1answer
41 views

Finding SQL Server Bottleneck - not CPU, IO, available memory

I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having ...
0
votes
0answers
39 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
2
votes
3answers
6k views

MySQL maintenance - how to clear the buffer?

We have a server running our PHP/MySQL-based web application which is SLOW. My predecessor says: We used to do database maintenance, which used to clear the buffer, cached and unwanted variables. ...
1
vote
0answers
42 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
10
votes
3answers
670 views

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want ...
0
votes
2answers
469 views

Two Azure disks have the same LUN

I am trying to set up SQL Server on an Azure VM (that has an SSD) per the following articles: Performance Best Practices for SQL Server in Azure Virtual Machines Using SSDs in Azure VMs to store SQL ...
0
votes
1answer
165 views

MySQL slow connection

I am running a laravel application that is on a separate server than my MySQL database. If I run the query on the Mysql server it takes the expected 0.00 - 0.01 seconds to return. However when I log ...
1
vote
0answers
100 views

Performance Monitor Processor Time counter blank data

I setup a simple data collector with Performance Monitor to collect Processor time(CPU Usage in %) and SQL Statistics: Batch Requests/sec @ 15 second intervals to see if i can get some baselines and ...
-3
votes
1answer
376 views

PHP Fatal error: Call to undefined function mysql_pconnect() [closed]

I'm Having same Problem. PHP Fatal error: Call to undefined function mysql_pconnect() in I gone through PHP Fatal error: Call to undefined function mysql_pconnect() in. i have same problem. but ...
0
votes
1answer
15k views

Mysql showing 100% CPU usage [closed]

I'm experiencing some problems with my MYSQL server installed with Cpanel. My server is showing 100% usage of mysql even if I don't have too much traffic on web. I am running CentOS 6.5x64 with 80GB ...
1
vote
5answers
5k views

How fill a database mysql with examples data? [closed]

i'm looking for a software that i can use to fill a mysql db (structure created by joomla, drupal or any CMS or script) with samples data for tot MB, so i can decide to put 400 MB of data in my tables ...
9
votes
1answer
10k views

Do I need to REINDEX and VACUUM a table after deleting lots of rows?

I am running a PostgreSQL database that has several tables which store logging information. This information is for reporting purposes only and gets dumped to a file and deleted from the database if ...
0
votes
1answer
652 views

How often would you run the Postgresql maintenance tasks

After reading the Postgresql documentation, we found that it's recommendable to run the Vacuum tasks daily: We recommend that active production databases be vacuumed frequently (at least nightly), ...
0
votes
1answer
39 views

Where should the DB server be and its updates scripts should run from where?

I currently have a web application and database on the same server. I am moving the database to a new server that is spec'd for being a database. Now i have nightly scripts that run on the web ...
1
vote
1answer
196 views

mysql server mostly stops working when binlog disabled

Performance was a little slower than I'd like on a mysql server, and we don't use replication and don't need point-in-time restores. So one recommended way to improve performance seems to be turning ...
1
vote
2answers
876 views

InnoDB Buffer pool hit rate missing from engine status output

I want to check the buffer pool hit rate for InnoDB on MySQL but when I query the database the hit rate seems to be gone from the results: Using query: SHOW ENGINE INNODB STATUS\G -------------------...
2
votes
1answer
3k views

Slow connection to Azure Sql Server

I'm moving from a Rackspace Cloud platform to Azure but I'm having some real performance issues. It seems like everything is a little but slower but especially database interaction. I've done some ...
0
votes
2answers
79 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; +----------+-------------+-----------+--------...
3
votes
1answer
33 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
-1
votes
1answer
897 views

Innodb performs IO Operation when idle

I am currently doing some stress testing where I am pushing inserts to the database as fast as I can. The simulation inserts 10000 records per second. After inserting around 200 million records I ...
7
votes
4answers
9k views

postgreSQL vs Cassandra vs MongoDB vs Voldemort?

Which database to decide upon? Any comparisions? Existing: postgresql Issues Not easily scalable horizontal. Needs sharding etc Clustering does not solve the data growth problem ...
1
vote
1answer
306 views

Is Amazon RDS overkill for small business site?

One of my clients wants a small business site run on Wordpress. I'm setting it up through Amazon EC2, and was curious if using Amazon's RDS service to run the wordpress installation is overkill. I ...
2
votes
0answers
222 views

Exchange 2010 on KVM - CPU usage reporting incorrectly

Good Morning, I have virtualized an exchange server using KVM (proxmox actually). It is Exchange 2010 SP3 running on server 2012 R2. KVM version 1.7.1. I am using the latest (0.1-74) virtio ...
2
votes
1answer
445 views

MongoDB 100% locked periodically. MMS charts attached

Trying to diagnose what could be causing intermittent lock-up on MongoDB server running behind a Rails application. Hoping that someone might recognise the pattern of peaks and troughs in the charts ...
1
vote
0answers
802 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
0
votes
1answer
38 views

Over 100% of stage done during DROP COLUMN

I'm running a DROP COLUMN on the primary key column (I know, it's terrible but I had to do it). There's a progress indicator: Stage: 1 of 2 'copy to tmp table' 107% of stage done I haven't been ...
0
votes
3answers
99 views

Development DB server with dedicated hardware [duplicate]

I'm planning to move one of my development database servers to its own machine. I'm currently running it on my laptop, which is not very convenient. DB Servel is PostgreSQL 9.0.1, OS is Gentoo. ...
-1
votes
1answer
59 views

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 ...
0
votes
1answer
1k views

How to set MySQL's internal time zone support?

Today MySQL at Facebook posted the following about MySQL performance: Today we found a performance problem in a completely unexpected place - if TIMESTAMP data type is being used and MySQL is ...
0
votes
1answer
28 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...
0
votes
1answer
74 views

Database server's Load reaches very high values while nothing seems to use CPU, what could be the reason?

top - 16:33:08 up 155 days, 6:05, 5 users, load average: 27.93, 35.31, 31.34 At this moment it only shows 27.0 but the behavior is like so: While mysqld uses 0% cpu the load raises to high values (...
7
votes
2answers
3k views

Too much I/O generated by postgres stats collector process

I am using XenServer with several virtual machines having local postgres databases. Even when all applications are unused and the databases are idle, each vm causes constant storage network traffic ...
0
votes
1answer
4k views

MongoDB Locking - Very, very, slow to read

This is the output from db.currentOp(): > db.currentOp() { "inprog" : [ { "opid" : 2153, "active" : false, "op" : "update", "ns" : "", ...
4
votes
1answer
7k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
2answers
51 views

No. of databases or no. of tables?

I am running three different sites with ImpressPages CMS v 2.6.. ImpressPages is built on PHP 5.3 and MySQL 5. Each site have about 33 MySQL tables and the databases is using MyISAM engine. I have ...
0
votes
0answers
147 views

Disk IO slower when outstanding IO requests are less than 32

I moved the databases from one server to another and general remark from users is that its slower. The old server was on windows 2003,64 bit, SQL 2005 Ent edition(32 bit) whereas new one is Windows ...
0
votes
2answers
229 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one (R1)...
1
vote
1answer
378 views

How can I tell if I would benefit from upgrading my Amazon RDS instance?

I have several sites with very high traffic - all hosted on Heroku and all of which access a db.m1.large mySQL Amazon RDS instance - and would like to know if there would be a performance benefit in ...
1
vote
2answers
2k views

How to install Sphinx on CentOS 6 where the DB and App server are separate servers

First what is the best way to install Sphinx on a centOs server rpm -ivh http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.6-1.rhel6.x86_64.rpm yum install sphinx didn't seem to work. ...
0
votes
1answer
686 views

mysql database config optimization

Have a heavily trafficed database running mostly innodb and would like to better optimize the mysql config. Server has 32Gb ram and the biggest tables are ~18Gb innodb. I think I have done all the ...
0
votes
2answers
378 views

PostgreSQL, automate REINDEX, Windows environment

I have a couple of PostgreSQL tables (9.1) which are inserted to / deleted from often. Over time they suffer from index bloating even though the autovacuum is configured and runs regularly. I'm ...