1
vote
0answers
17 views

Mysql with low memory on development environment

How to set mysql to run on very low memory? (preferably under 100MB and max 250MB) Currently it's running for about 400mb. I can't turn off the innodb because production using innodb. Is there any ...
0
votes
2answers
82 views

plenty of ram but still swapping

this is graph of my server ram you can see in graph that every time I restart mysqld, swap becomes zero. But increases over time. If i put innodb buffer pool in large size swap rises faster and if I ...
0
votes
1answer
57 views

Apache2 using up all my memory and stalling my wordpress instance (mysql)

Environment Ubuntu 12.04 / 1GB RAM / 40GB DISK / 1 CPU (RACKSPACE) Wordpress 3.9 mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.2 Apache2 mod_php5 mod_rewrite When ...
2
votes
3answers
511 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
1answer
78 views

yum update MemoryError 1G memory free

I am trying to do yum update and getting "MemoryError". The server (OpenVZ box) has 2G RAM and Percona MySQL server running with 1G InnoDB buffer configured. The OS is CentOS 6.5, kernel ...
0
votes
0answers
21 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
1
vote
2answers
452 views

troubleshooting out of memory error messages from mysql

we have a web application (racktables) that's giving us grief on our production box. whenever users try to run a search, it gives the following error: Pdo exception: PDOException SQLSTATE[HY000]: ...
1
vote
1answer
363 views

Mysql running out of memory

I am having a lot of trouble with mysql eating too much ram on a small machine and am looking for some help in figuring out why it is eating so much. I have a small virtual machine with 256MB of RAM ...
0
votes
0answers
691 views

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...
3
votes
1answer
356 views

MySQL memory usage - Periodically need to run FLUSH TABLES or memory usage keeps growing with large-pages turned on

After switching our rather memory + physical core rich database server to large-pages, we have noticed a small issue. The memory usage almost looks like there is some sort of memory leak. But ...
0
votes
2answers
340 views

MySQL crash when I increase max_heap_table_size value

I have a MySQL instance running on an Ubuntu 12.04 server, equipped with 120 GB RAM. There are several PHP scripts running on it, which sometimes set new mysql parameters. One of these scripts uses ...
2
votes
1answer
468 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 ...
1
vote
2answers
155 views

Being DOS'd or need more memory?

I have a centos 6 server running apache2, php and MySQL. The apache config has a few virtual sites as the server runs six websites, three of the six sites use MySQL and the other three do not. ...
1
vote
1answer
735 views

Error with MySQL server: Can't create a new thread (errno 11)

I am currently stress testing my PHP, MySQL application hosted on AWS EC2 using Amazon Linux. After reaching certain number of users DB starts to give error: Can't create a new thread (errno 11); if ...
1
vote
1answer
454 views

Mysql crashing due to InnoDB not able to allocate memory

MySQL crashes every now and then due to, I believe, a large request hitting it above the innodb-buffer-pool-size set in my.cnf (currently at 210M), which I needed to set for mysql to start in the ...
1
vote
2answers
62 views

Can my mysql server be fully tweaked? [closed]

I'm on a quadcore CENTOS 5.9 i686 standard running WHM 11.36.0. It's a dedicated LAMP server with lots of websites, most of which are using databases. I'm monitoring the server using Munin and notice ...
-1
votes
2answers
53 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? ...
1
vote
1answer
2k views

MariaDB / MySQL using a lot of threads / memory

I've been setting up a new VPS and wanted to try out MariaDB. I'm using MariaDB 10.0.1, which as far as I understand it is the equivalent of MySQL 5.6. Has the thread handling of threads changed ...
5
votes
3answers
1k views

Optimizing VPS Server Memory

WHAT I'M TRYING TO DO The server resource limits sometimes run tight; to help prevent memory exhaustion, I've had to limit server processes. I'm needing a little expert help to know if I'm on the ...
-1
votes
3answers
76 views

Running a LAMP application entirely in memory

Our company uses a PHP/MySQL-based project management app heavily. So heavily that the app is really starting to slow down. It's not that the app is running out of memory -- I never go above 50% ...
-1
votes
2answers
461 views

MySQL server stops randomly. Is it possible that system kills it during high loads or low available memory? [duplicate]

Possible Duplicate: How to diagnose causes of oom-killer killing processes I have an Ubuntu webserver (Apache + MySQL + PHP) on a very small machine on Amazon Web Services (EC2 micro ...
0
votes
2answers
311 views

My VPS is Out of RAM how much to I need more? [closed]

I have VPS server with 1.25GB ram and 0.51GB cache trying to up an e-commerce website with 200k items, db now is about 2gb anything is now works terrible slow now because of lack memory mysql queries ...
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?
2
votes
1answer
280 views

Linux Nginx + php-fpm + cron + mysqld = always out of memory

I don't get it. I have a VPS with Nginx and php-fpm and MySQL. Should be very lightweight. No Apache, right? When I reboot, it is very lightweight. ~ 50/481 MB MEM usage. Very acceptable IMO. And ...
1
vote
1answer
421 views

Is it possible to disable or tune filesystem cache sharing for OpenVZ?

For OpenVZ, an implementation of container-based virtualization, it seems that host and all guests are sharing the filesystem cache. This sounds paradoxical when talking about virtualization, but this ...
1
vote
3answers
335 views

Is it safe to use up all memory on linux server, not leaving anything for the cache?

I have a CentOS server fully dedicated to MySQL 5.5 (with innodb tables mostly). Server has 32 GB RAM, SSD disks, and avarage memory usage looks like this: So about 25GB is in use and about 6.5GB ...
2
votes
1answer
93 views

CentOS VM only using a third of available memory

I have a VM slice running CentOS, on Parallels. Here is the output of free -m [root@server ~]# free -m total used free shared buffers cached Mem: 960 ...
6
votes
3answers
4k views

How do I assign a memory limit for mySQL?

mysql tuner reports that mySQL can use 166% of installed ram, how do I limit RAM usage ? [!!] Maximum possible memory usage: 426.8M (166% of installed RAM)
0
votes
0answers
281 views

Apache2 and mysql-server consume maximum physical memory

i am using ubuntu 12.04LTS on my linode vps include core2 cpu, 2gb RAM. I am doing a lot of research on optimizing memory for mysql and apache process -> optimize apache memory use, there i am using ...
0
votes
1answer
111 views

Database server size

I received a recommendation from my hosting provider noting that a general rule in production server management is to ensure that the memory on your database server is larger than the size of your ...
1
vote
1answer
1k views

MySQL on Linux out of memory

OS: Redhat Enterprise Linux Server Release 5.3 (Tikanga) Architecture: Intel Xeon 64Bit MySQL Server 5.5.20 Enterprise Server advanced edition. Application: Liferay. My database size is 200MB. RAM ...
-1
votes
1answer
502 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 - ...
0
votes
1answer
154 views

All memory consumed by MySQL [duplicate]

Possible Duplicate: linux eats all memory, seems like it is not for specific application TOP shows that almost all the memory is consued on a dedicated MySQL box. I stopped mysql and ...
-3
votes
1answer
186 views

LAMP servers performance: Can I improve them by adding more RAMs? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites Let me refine my questions: 1. How can I improve MySQL performance? 2. Will adding more RAMs help? 3. Will ...
2
votes
2answers
3k views

Why is MySQL is using so many temporary tables?

Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows Current max_heap_table_size = 200 M Current tmp_table_size = 200 M Of 17158 temp tables, 30% were ...
0
votes
1answer
630 views

Parallels Plesk not enough memory

Parallels Plesk shows: ERROR: PleskFatalException Unable to connect to database: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 12); if you are not out of ...
3
votes
5answers
1k views

What happens if you run out of RAM and swap?

Running MySQL on a box with 32 gigs of RAM. Swap is 99% full, and there is about 200 MB of RAM free. MySQL is the culprit of course. What happens when both RAM and swap are completely filled? Thanks! ...
1
vote
2answers
492 views

How much memory do I need to load a 50GB+ MySQL table?

I've got a MySQL table with a .MYD file of 44GB, and a .MYI file of 34GB. I'm running scripts from the command line that analyze the data in this table. MySQL is not maxing out the CPU, my memory IS ...
2
votes
0answers
259 views

What are the risks of running a database on a server without ECC RAM? [duplicate]

A lot of branded servers come with ECC RAM, but it is expensive. For a database server or other critical servers, what would be the impact of not using ECC RAM? Data corruption? (I suppose the ...
1
vote
2answers
2k views

MySQL consuming nearly all memory in cache? [duplicate]

I am running a server with 24G of RAM. The only thing running here is a MySQL server configured as Master. When I check the memory via free -m I am getting this: total used ...
1
vote
3answers
111 views

Will I need more system resources to run DB2 instead of MySQL?

I need to convert my web application from MySQL to run on DB2. I need to know in advance whether I will need a high spec server to ensure the web application performs at the same speed as it does now ...
6
votes
2answers
2k views

100% CPU load on Ubuntu 10.04.3 LTS 64bit

I have trying to fix this issue for two days with no success. The server is a MySQL database server. Hardware: DELL Poweredge 1950, 2x Intel Xeon Quad Core E5345 @ 2.33GHz, 16 Gb mem, 2x 146Gb SAS ...
0
votes
1answer
279 views

Idle RAM usage increased from 144MB to 510 MB after upgrade to MySQL v5.5.16

So I am on a pretty tight budget (like a lot of folks) and I have a VPS running using Centos v6.0 x86. It has 1024 MB of RAM. I have Apache 2 and MySQL running. I recently upgraded to the latest ...
11
votes
2answers
12k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...
1
vote
1answer
523 views

400% CPU usage for MySQL? What? What should I do?

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 19857 mysql 20 0 514m 47m 3404 S 386 9.7 4511:45 mysqld 15659 www-data 20 0 205m 11m 4856 S 7 2.3 0:00.67 ...
8
votes
2answers
6k views

How do I optimize MySQL's memory usage?

MY SETUP ( example ) I am running Linux on an Amazon High CPU Extra Large EC2 instance with the following specs: 7 GB of memory 20 EC2 Compute Units (8 virtual cores with 2.5 EC2 Compute Units ...
1
vote
3answers
3k views

How to troubleshoot a big memory issue with Apache and mySQL

I've read a lot of this website to optimize my server but nothing has really helped me :( Im having a memory trouble I think , I have just one website (Drupal) with 860K page views month but when the ...
2
votes
2answers
362 views

MySQL not using specified RAM anymore

A few days ago I got a new machine setup running CentOS 5.6 (64bit), with 12GB ddr3 ram, 4x SAS 15k rpm drives in RAID10. On this machine I'm running MySQL Server version: ...
-1
votes
1answer
492 views

Mysql taking too much memories, how to solve

I had a Drupal website on a test box and I am the only visitor. When I do nothing. Mysql is taking like 7% mem. When I click homepage. I can literally see that mem ramps up to 15% of the mem by ...
1
vote
2answers
690 views

Memory usage on debian webserver keeps going up [duplicate]

my webserver is running apache 1.3.x for a PHP application, along with mysql on the same machine. Most of the time it runs fine, CPU usage still with nice margin, but somehow memory usage keeps ...