The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
50 views

Remotely automate optimization of mysql database

I am not a mysql or sql expert by any means, and not too savy on FreeBSD, either. We have a server that regularly needs one table to have data deleted < a time frame that leaves only 1 month of ...
0
votes
1answer
244 views

php5-fpm spike, wrong configuration?

Recently I've uploaded some changes to my server that increases the amount of AJAX calls made to the server. The application "fastness" has decreased a lot. The web server is nginx with php5-fpm ...
-1
votes
1answer
498 views

Nginx , Apache , Mysql , Memcache with server 4G ram. How optimize to enought memory?

i have 1 dedicated server with Nginx proxy for Apache. Memcache, mysql, 4G Ram. These day, my visitor on my site wasn't increased, but my server get overload always in some specified time. (9AM - ...
1
vote
2answers
823 views

Mysql 5.5 Defragmentation not reducing the fragmentation percent

We are running OPTIMIZE TABLE , but not seeing any fragmentation reduction. They are as high as 120% to 200%. Am calculating the fragmentation % using this: Data_Free / (Data_Length + Index_Length) ...
0
votes
2answers
275 views

what is the best way to find the bottlenecks on my LAMP web server?

can you help me find the bottle neck on my server. In the previous question I asked on SF, I was told that memory is no problem and I have plenty of it. I'm curious about CPU, perhaps HDs ... what ...
4
votes
2answers
711 views

Does it makes sense to run “optimize table” when the mysql database is stored on SSD?

The manual says about "optimize table": "Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the ...
0
votes
0answers
190 views

MySQL is killing the server IO

I manage a fairly large/busy vBulletin forums (running on gigenet cloud), the database is ~ 10 GB (~9 milion posts, ~60 queries per second), lately MySQL have been grinding the disk like there's no ...
1
vote
6answers
946 views

MySQL is killing the server IO [duplicate]

Possible Duplicate: MySQL is killing the server IO. I manage a fairly large/busy vBulletin forums (running on gigenet cloud), the database is ~ 10 GB (~9 milion posts, ~60 queries per ...
3
votes
3answers
848 views

How to determine bottlenecks on Ubuntu LAMP environment

What kind of tests should I run to determine bottlenecks on my server? I'm trying to optimize so I can maintain heavy load spikes when they occur. I'm running Ubuntu in a LAMP environment.
0
votes
2answers
57 views

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...