Tagged Questions

-1
votes
2answers
43 views

server busy threshold? [closed]

i have a server with 512MB RAM running mysql and apache service. I have joomla site inside my server. I want to ask, is there a brief threshold limit of RAM when the server will be stated as busy? ...
0
votes
1answer
60 views

Performance analytics via DBMS “plugins”, or other solution

I'm working on a systems monitoring product that currently focuses on performance at the system level. We're expanding out to monitoring database systems. Right now we can fetch simple performance ...
2
votes
1answer
679 views

Get the average execution time of all select queries

tl;dr: How can I get the average query execution time of select statements of a running MySQL server? At them moment we have several database servers, with some slaves treated as read-only servers. ...
0
votes
1answer
134 views

MYSQL delete optimization

I have the following delete SQL statement: delete w,r from table1 w, table2 r where (w.status=1 or r.status=1) show engine innodb status shows the following. is the read rate(237.29 reads/s) ...
1
vote
1answer
202 views

How can I trace performance problems in an Ubuntu / Apache / MySQL / Rails + Passenger stack?

I have performance issues with a Rails stack that is running Apache 2.2.9, MySQL 5.1, Passenger 2.2.9 and Rails 2.3.8 (ruby 1.8.7-p72) on an Ubuntu 8.04 server. How can I trace performance issues in ...
1
vote
3answers
255 views

Any open source software for measuring & monitoring MySQL performance?

I'm working on improving the performance of a MySQL server. I'm looking for something to measure & monitor the performance of MySQL (as query per second) over time so that I can measure any ...
0
votes
3answers
152 views

Recommended way to Investigating server performance issues

I have a linux server box that runs the following stack: apache 2.2.9 passenger 2.2.8 rails 2.3.8 MySQL 5.1 Recently we've encountered some machine performance issues, where the entire server ...
1
vote
2answers
159 views

mysql settings - using the available resources

I've got a lot of processing work I need to run on a mysql server. I've installed mysql 5.1.45-community on a Win 2008 64bit. Its running on a Xeon, 3ghz 6 processors with 8 gig ram. It doesn't ...
2
votes
2answers
1k views

Apache Server Performance Monitoring

I've recently setup a new apache webserver with the basic LAMP stack (PHP / MySQL / Apache). I'm curious what kind of performance monitoring solutions are typical -- really, I'm simply looking for a ...
6
votes
5answers
5k views

How to fine-tune our MySQL server?

MySQL is not my thing, yet I need to fine-tune one of our servers. Here are the requirements/specs: The MySQL server has only one significant database We only have one "type" of application ...
1
vote
5answers
671 views

Visualization Tools for Web App and Database Servers Performance Monitoring

I am interested in finding solution for visualizing the performance of our web servers and database servers in real-time (or as real time as possible). I have seen some stuff for the MS Stack but I ...