0
votes
1answer
41 views

Website slowing down when many users access simultaneously [on hold]

I'm new to web development. I have hosted my website through a free web hosting service providing free subdomain. The free hosting service says that they provide 100 GB bandwidth. I just upload files ...
0
votes
1answer
60 views

Strange CPU spikes with MySQL

On my server (ubuntu 12.04) mysqld started to show some strange CPU spikes. I've logged some of it as a sample: http://pastebin.com/4MwKUVwL The value after the triple dash '---' is the cpu usage ...
-1
votes
1answer
59 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 ...
1
vote
1answer
67 views

MySQL suddenly taking 2000 ms per request, instead of 200

UPDATE: finally remembered to look at munin, and it seems that one of the HDDs is the root of the problem after all, unless I'm totally reading this wrong. Here's the munin output: ...
2
votes
3answers
506 views

Mysql crashing, oom-killer, out of memory, tuning issues?

I just moved all of my websites to a new server with 4GB RAM. Almost immediately, mysql started crashing, and at one point, didn't reboot which caused a major outage (since I didn't notice until ...
0
votes
2answers
34 views

Distributed LAMP vs DB and Web Server same box

We have a very read heavy semantic web (RDF) application which is RHEL 5/Apache 2.2.3/Tomcat 6/Java 6 on one Server, and MySQL 5.1 on another. Apache and MySQL are backported Red Hat repo stuff, so ...
1
vote
1answer
919 views

MySQL high CPU usage on small website

I have a small website hosted on a dedicated server (FreeBSD 9.2, MySQL 5.6.1 and php 5.5.5). The problem is that MySQL eats a lot of cpu resources even if the website have a few visitors. The ...
0
votes
2answers
98 views

How do I prevent a website on my server causing the whole server to crash

I have a server with 6GB of RAM and a 6-Core CPU. Number of websites hosted by the server is about 10, but sometimes 2 of them take 100% CPU and almost entire RAM which cause the whole server to crash ...
1
vote
0answers
39 views

Frequent CPU spikes on fresh install

I just reinstalled my Server (Windows Server 2008 R2) and after installing MySQL 5.6, the CPU spikes every few seconds: http://s15.postimg.org/dno7ztfjf/cpuspikes.png Even worse than the higher CPU ...
0
votes
2answers
170 views

MySQL's InnoDb performance downfall

I'm trying to configure a MySQL production server using InnoDb and I can not get the performance I want out of it. I've used Percona tools to give me the following configurations: [mysql] # CLIENT # ...
1
vote
4answers
430 views

Heavy production MySQL/Percona Database in openvz container

So I'm currently running a MySQL 5.1 database, with the following specs: Proc: Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz RAM: 64 Go disks: 2x 100 Go SSD (RaidSoft) I'm planning to migrate my ...
0
votes
1answer
163 views

Randomly slow MySQL queries

I know this type of question come often. But I have done a lot of research, tried a lot of different settings, but still have the same issue: queries that usually are very fast can take 3s to 5s ...
0
votes
2answers
36 views

Apache Configuration not use server capabilities

I have a web server with 16 GB of RAM. The server has a good traffic and have pics of 300 simultaneous requests. Unfortunately when these peaks arrive queries fall into error or are very very slow. ...
-1
votes
2answers
1k views

Poor SQL performance on HP ProLiant ML310e Gen8 v2 with raid10

I recently bought HP ProLiant ML310e Gen8 v2 server with 8G's RAM and 4 HP 1TB 6G 7.2k rpm SATA (3.5in) Non-Hot Plug MDL HDD disks. It was surprise to me that HP didn't provide debian drivers for ...
0
votes
1answer
92 views

Website is slow without https

As you can see, http://coinad.com/ is slow, and https://coinad.com/ is fast. I've upgraded the server, reviewed the code, optimized the tables and anything seems to work. This is driving me mentally ...
8
votes
3answers
268 views

Adding CPUs puts MySQL 5.5 (Debian) performance down

I am about to setup a database server (MySQL) in OpenVZ container and I've been wondering how many CPUs I should assign to it. I decided to benchmark it. I compared two OS/MySQL distributions and ...
0
votes
1answer
662 views

MySQL Performance Bottleneck - I/O or CPU?

I'm developing a web app and have run into a large performance difference between the speed of MySQL lookups on my development and live environments. DATABASE: 2.5GB, three tables (one table has ...
0
votes
0answers
360 views

Server & Mysql Config for Magento

I will appreciate if someone can help us as we think our server admin has no clue. We are having issues with our server such as mysql using too much CPU sometimes up to 70%. Especially when security ...
3
votes
3answers
274 views

MySQL hangs if connection comes from outside the LAN

I have a MySQL Server operating just fine if I access him from his local LAN (192.168.100.0/24). If I try to access hin from another LAN (192.168.113.0/24 in this case) it hangs for a really long time ...
1
vote
0answers
457 views

Amazon RDS: Sudden increase in Read IOPS and Throughput

I am using Amazon RDS to host the databases for my website. I am using the large instances for both my master and my read replica. Everything was running smoothly until suddenly the Read IOPS, Read ...
0
votes
0answers
333 views

High disk usage in CSRSS.EXE

I recently started working on the server for a certain software (Tango). The users complained that it recently became extremely low, so I used an application (ProcessHacker) to see the resource usage ...
1
vote
2answers
780 views

High load with low CPU usage and low IO usage on Solaris with ZFS and MySQL

I have a Solaris 10 x86_64 system running MySQL 5.5. Under heavy usage times, we're getting very slow responses from the database: slow queries running into minutes that normally return in sub-second ...
3
votes
2answers
261 views

Dropping Index on 10GB+ InnoDB table takes over 4 hours

This is the table I'm working with: CREATE TABLE IF NOT EXISTS `checklist_answer` ( `id` varchar(36) NOT NULL, `created_by` varchar(36) NOT NULL, `date_created` datetime NOT NULL, ...
2
votes
1answer
467 views

Should CPU usage be so low while memory usage is high on heavy mysql server?

I'm using ubuntu server 12.04 x64. The server receives a lot of requests to mysql through apache web server (it's light interface). From mysql stats I see there is approx 250 queries / second from 8 ...
0
votes
1answer
154 views

current my.cnf configuration

Hello serverfault community, I have a medium sized VPS on which I run 2 Magento installations, a few static pages as well as several WordPress / Joomla installation - all personal websites and ...
0
votes
0answers
107 views

Performance drop after hours of runtime - how to detecting bottleneck

I am running a local database server for 1 client machine. My DB server runs redis (version 2.6.13) and mysql (5.5.31-30.3-log Percona Server (GPL), Release 30.3). I have 1 Client machine that runs a ...
2
votes
4answers
1k views

MySQL gradually slows down until server reboot

The performance of pages on my site that access my mysql database slows down over time until I reboot my server. (Static pages are not affected.) Restarting mysqld itself doesn't help, but rebooting ...
-1
votes
1answer
42 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
2
votes
3answers
174 views

How do I improve the performance of my Drupal site with a lot of concurrent users?

I have a Drupal site that may receive a very high hit rate on launch. We've rented a very beefy server for the initial launch, after which we'll downscale. The server has a Xeon E5-2670 8 core ...
0
votes
1answer
347 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
1answer
658 views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
1
vote
1answer
292 views

What conditions trigger a table level lock

Working on some vBulletin performance issues, I ran into this situation, where everything is stuck waiting on a table-level lock: Id Command Time State Info 83 Query 47 ...
0
votes
1answer
2k views

High load and iowait on MySQL database server leads to slow MySQL INSERTS

I have a MySQL database server runnuing on Ubuntu 12.10 with 64GB RAM, 2x3 TB SATA 6 Gb/s HDD 7200 rpm and software RAID 1 and an Intel Core i7-3930K. The database server is accessed over a local ...
4
votes
2answers
589 views

Is there a Unix / Linux command to count lines per second from stdin?

I am trying to count the number of SQL queries per second from a log file and I want to do it in real time by pipeing stdout from grep into some command. ( I am doing some performance testing ) I ...
0
votes
2answers
205 views

MySQL Database Problems - Growing too quick, Performance

I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. ...
6
votes
2answers
151 views

What Linux command do I type to see my MySQL server load in real time?

What Linux command can I type where I can watch MySQL server load in real time? BACKGROUND: I can type 'top' and watch overall server load (just look at inverse of Idle % and consider it over a ...
0
votes
3answers
152 views

Intermittent Server Error - MySQL or Apache?

I've been having a pretty annoying problem with a website I work on, and I'm having difficulty saying whether the problem lies with PHP, Apache or MySQL. System setup: cloud hosted solution (moved ...
1
vote
1answer
391 views

MySQL Extremely High Disk Activity (Read Operations)

I have 1GB Linode VPS with a standard LAMP stack. Apache is tuned fine but for some reason MySQL's disk usage is high. This is causing really slow site load times. RAM and CPU usage are fine. Can ...
-1
votes
1answer
65 views

MySQL Server stops working on heavy calculation load [closed]

When executing the attached procedure, mysql hangs up and does not replay anymore until cancelling the task. It is installed locally on a windows machine. Its whole performance is terribly. What to ...
0
votes
2answers
322 views

MySQL Tweaking for performance

[mysqld] myisam_repair_threads=4 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M table_cache = 1024 ...
0
votes
1answer
467 views

Apache django mysql very slow

I am using Django, wsgi with apache, but the server is really slow when I try to insert data into mysql server. It takes 1 second to insert 200 rows in a table. The strange thing is that only 3% of ...
0
votes
2answers
142 views

Can I use two machines to set up memcache server for a php web app?

I have a web server which hosts my PHP web app and my MySQL server. I would like to throw out one more machine there to use it for memcache/memcached. In order to use Memcache, should I have a ...
0
votes
1answer
253 views

Mysql and Apache don't free memory after ending connections

My server goes down repeatedly. using htop I found that mysql and apache use almost all of RAM memory. When I restart apache everything is ok, but after a while httpd and mysql take all memory as you ...
1
vote
3answers
384 views

Speed up connection to MySQL

So here's one for you. Any idea on a way to shorten the time it takes to connect to a MySQL database? The reason I'm wondering is because I find that just connecting to the DB adds just over a second ...
2
votes
1answer
73 views

Decreasing MySQL ram usage

MySQL is using 150MB of my RAM memory when it's doing nothing. I have a VPS with only 256 MB ram available, so what can I do to decrease its RAM usage?
1
vote
2answers
124 views

Server down at 23:26 every night

We are having a big problem with our sites stability the last couple of weeks and after endless hours of troubleshooting I don't get anywhere. So I turn to you dear community. Setup: 2 x VPS servers ...
-1
votes
1answer
512 views

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

Server Performance

I know very little about performance tuning of servers etc... so i thought i'd put this up here as i start some research on it, just to get some direction. I am in the process of migrating from my ...
1
vote
1answer
313 views

PHP/MySQL Performance Testing with Just PHP [closed]

I'm trying to diagnose a server where the website is loading very slowly, but unfortunately my client has only provided me with FTP access. I've got FTP access so I can upload PHP scripts, but can't ...
1
vote
1answer
241 views

Some problems with MySQL [duplicate]

Possible Duplicate: Huge amount of TIME_WAIT connections says netstat I have 2167 connections like that: tcp 0 0 127.0.0.1:34276 127.0.0.1:3306 ...