All Questions
119
questions
2
votes
3
answers
866
views
MariaDB using more memory than expected
We're running MariaDB server 10.6.16 from the RPM repository https://mirror.mariadb.org/yum/10.6/rhel9-amd64/ on a AlmaLinux 9.3 system with 48 GiB memory (no swap space) and 32 CPU cores. We're ...
1
vote
1
answer
284
views
Memory consumption on virtual server too large for applications being run
I have a Linux Ubuntu virtual server at Digital Ocean with the following specs: 1 vCPU, 2GB of memory, and 25GB of SSD storage.
The server is running a single WordPress website with around 400 unique ...
- 141
0
votes
1
answer
749
views
which memory limit applies when php performs a MySQL query
If I run php as FPM, I can set my memory limit in php.ini or .user.ini. PHP can perform a MySQL query, and I can set memory limits in /etc/my.cnf for for instance the innodb buffer pool. If PHP runs ...
- 105
2
votes
1
answer
192
views
MariaDB - Contiunes to use more memory
We are running Maria DB 10.6.9 on CentOS and we are observing it continues to increase the usage of memory.
Server Specifications:
RAM - 128 GB
vCPUs - 48
Swap - 100 GB
We have configured ...
4
votes
1
answer
8k
views
MariaDB using much more memory than it should
We are using MariaDB 10.3.32 on a Ubuntu 20.04.4 machine with 6 GB of memory, about 20 applications running on it. Databases are all InnoDB.
Even with mostly default settings (see on the bottom), ...
- 41
0
votes
2
answers
746
views
MySQL "Cannot allocate memory for the buffer pool" at 73% memory usage?
I am hosting a WordPress website on a DigitalOcean droplet (1GB RAM). The website's MySQL database crashes occasionally, which causes the website to show "Error establishing database connection&...
- 187
2
votes
0
answers
672
views
Can't track memory usage of MySQL docker container
I have a MySQL instance as a docker container managed by Hashicorp Nomad on an AWS EC2 t4g.small instance.
I need to monitor MySQL's memory usage because I have experienced OOM kills after ...
- 21
0
votes
2
answers
495
views
Why cannot use buff/cache?
It seems mysqld allocates too much memory as buff/cache:
free -m
total used free shared buff/cache available
Mem: 990 448 96 36 ...
- 109
1
vote
3
answers
2k
views
Mysql filling all the buff/cache memory
The more time the server run, the more buff/cache Mysql processes use, i'm at 95% right now and only a server reboot free the buff/cache memory. None of the mysql commands free it on the go.
Is it a ...
- 123
-1
votes
1
answer
664
views
What is the best mysql configuration for mysql instance with a lot of databases and lot of tables inside?
I have a mysql database instance with more than 3000 database inside. Each database contains more than 200 tables. I have more than 100 gb of data in all these database at present. I am using windows ...
- 99
0
votes
1
answer
98
views
MySQL: normal CPU Utilization but I'm running out of memory. Should I get worried?
I'm running a heavy python script in a EC2 instance. This script is inserting tables (financial reports) to a MySQL server. There are lots of tables, the total amount is 240.000 tables. I started the ...
- 75
0
votes
1
answer
456
views
Server crashing because of out of memory
My server crashed 3 times in the last week from out of memory.
Server is ubuntu 14.04 with 8Gb ram.
MySql server 5.5.50
Below is a graph from munin:
I didn't have the historical ram consumption ...
- 483
3
votes
2
answers
3k
views
MySQL using ridiculous amount of memory to import 1-2GB SQL files
I have a MySQL server running on an Ubuntu 18.04 machine via Docker. The machine has 32 GB of RAM.
I have about 300 1-2GB SQL files which need importing into a database on the server, into a single ...
- 31
2
votes
0
answers
50
views
Differing "free memory" interpretation on virtualized vs. bare-metal Debian 9
I have the same software suite with roughly similarly sized datasets on two Debian 9 systems, with one big difference: os-1 runs on bare-metal and has better hardware, while os-2 is virtualized ...
- 135
5
votes
3
answers
8k
views
Mysql runs out of memory during backup dumps (Docker container)
We have a container running MariaDB, and a few other small containers on the host. The Mysql container was allocated 21G of memory (out of 32G total), as well as a few other parameters, with the ...
- 51
1
vote
2
answers
1k
views
MySQL and Apache are running out of memory
Can you help me how can I figure which SQL query makes my MySQL running out of memory?
So, running dmesg command in console, I get following result:
[root@dmzemf httpd]# dmesg -T | grep 'Out of ...
- 863
-1
votes
1
answer
6k
views
Starting mysql failed because the control process exited with error code [duplicate]
Ok. First. I tried to run a website on a server but it was too heavy for MySQL to handle. Apparently, it broke due to lack of RAM. So I changed the .cnf and .ini files for the server to lower the load,...
- 183
9
votes
4
answers
32k
views
MySQL memory usage is too high
I'm running Ubuntu 16.04 on a system with 64Gb RAM + 64Gb of swap partition. It's not a dedicated server so there're other processes running at the same time. Anyway when MySQL daemon is stopped, the ...
- 91
0
votes
1
answer
818
views
Improving SQL speed - Can SSD and more RAM be effective?
I'm running a website on a VPS package on nomral Hard drive, and 3.25 GB RAM.
I created a test page and realized that by simply including an SQL command such as:
SELECT Name from table where Name IN ...
- 101
0
votes
1
answer
539
views
Server performance affected by MySQL memory consuption and CPU usage
Everyday during the peak time my server getting slow or down. Our hosting provider insisting us to upgrade the server but I think some performance tuning issue is there.
Adding the process ...
- 1
3
votes
2
answers
4k
views
OOM killer shut down MySQL although ram usage seems low
Setup
EC2 t2.large instance with Ubuntu 16.04 (2 Cores, 8GB RAM)
Apache/2.4.18 (Ubuntu)
5.7.20-0ubuntu0.16.04.1 (Ubuntu)
Currently this instance hosts multiple Drupal 6 & 7 sites, around 150 ...
- 31
0
votes
1
answer
1k
views
Load entire database with additional RAM?
I recently upgraded my upgraded from Microsoft Small Business Server 2003 with 2 GB RAM, to a shiny-new server running Microsoft Windows Server 2016 with 64 GB RAM. I configured MySQL on the server ...
- 129
0
votes
1
answer
1k
views
VmRSS used to only about 25%, yet oom-killer strikes
I have a dedicated MySQL server equipped with 128 GB RAM. MySQL recently gets killed by the oom-killer, although MySQL is configured to use 95 GB in the worst case. In my research I came across this:
...
- 105
0
votes
1
answer
116
views
Ubuntu memory consumption
I've got the following output of the free -m command
screenshot
So as far as I understand, 6501MB is available for using. The problem is that I have a cron job executing some SQL and I've noticed ...
user394556
0
votes
2
answers
118
views
Mysql server(ubuntu) ram usage go high after reboot. Having swap after reboot 2 days later
I have a Mysql server on VM with
16 cores CPU
59 GB RAM
Ubuntu 13.10
Mysql version is 5.5.37
This is a Slave db for reporting purpose only.
Because original Mysql innodb_buffer_pool_size(49G) is so ...
0
votes
2
answers
242
views
Mysqld.exe RAM size increasing upto 130MB and performance is poor
I have deployed my application with java 8 and mysql server. While running mysqld.exe takes upto 130 MB of RAM size and it stops increasing. But after that my application's performance is very poor. ...
0
votes
2
answers
5k
views
InnoDB (Not Really) Out Of Memory?
MySQL keeps on crashing on my server. I'm running several dozen sites using VestaCP and haven't had issues with MySQL for months.
I'm running on a Linode VPS with 12GB of Ram, normally 9GB of it ...
2
votes
2
answers
8k
views
MySQL - high RAM usage
I have VPS with 2GB of RAM running Ubuntu. There are three sites using database on this server - two on WordPress and one on custom script. All of them get max few hits per day.
MySQL always had ...
- 171
-2
votes
1
answer
51
views
Running on two servers vs. one with more memory? [duplicate]
I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a ...
- 1,319
1
vote
1
answer
1k
views
MySQL (MariaDB) crashing
Good morning - I have reviewed a previous post regarding changing the performance schema to "Off in the configuration settings. It looks as though our configuration is already set to this. So not sure ...
- 11
0
votes
2
answers
10k
views
High RAM usage by Apache without any visitors
I have recently bought a VPS server with the below configuration
Centos 6 64bit
20GB SSD
512MB RAM
512 VSwap
I have hosted around 10 websites. In that 4 of them is WordPress. Others are dynamic(PHP) ...
- 111
-1
votes
2
answers
492
views
MySQL crashes due to memory related errors, but roughly 50% memory is unused
MySQL keeps crashing because of: InnoDB: Fatal error: cannot allocate memory for the buffer pool. This looks like a memory problem and the internet seems to confirm that. Also, my box has only 1GB of ...
- 101
0
votes
1
answer
599
views
host a 500gb mysql database in RAM memory
I have a 500gb mysql database.
Assuming that buying RAM is not a problem (memory is cheap), is it practical or even sane to host an entire 500gb mysql database in RAM memoery for faster accessing ...
0
votes
1
answer
70
views
Which memory settings to use for this MySQL server? [duplicate]
I've been looking in a lot of places so far but I couldn't find any articles about how much memory to allocate to MySQL based on server size.
I am about to deploy a website on a relatively small ...
1
vote
1
answer
912
views
mysql swap file crash on freebsd
I have a low memory VPS that mysql and the swap file crash out every morning at exactly 0300.
There are no cronjobs on the system that have been configured. The server is a basic LAMP development ...
- 11
-2
votes
1
answer
896
views
Reduce the amount of RAM used by MySQL
I have recently purchased a 1GB DigitalOcean Ubuntu 14.04 VPS and it is running a blog written in Python and Django.
I have installed NGINX and MySQL on the same machine.
My problem is that MySQL is ...
- 95
-2
votes
2
answers
866
views
RAM usage by Apache server in Wordpress Site
I need some advice as I have a VPS OpenVZ with 1GB Ram and 1GB burstable. I am running a site on wordpress and my site users are about 2000 per day. My DB size is about 90MB and I am using latest ...
4
votes
1
answer
2k
views
Enable HugePages on Linux for multiple services/processes
On one of my Debian machines I'm running a service on a JVM and a MySQL instance. I have enable the HugePages following various online guides but I'm having a problem.
Here is my configuration:
vm....
- 1,090
-1
votes
1
answer
96
views
make mysql to share all cpu
I am very new to linux server .I am using centos.Sometimes my cpu gets overloaded because of the process mysqld over 100%
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
...
- 107
6
votes
4
answers
28k
views
How to permanently increase innodb_buffer_pool_size on Ubuntu
I have read lot of posts & manuals to try to find out how to increase memory in MySQL 5.6 on Ubuntu, which say there are 3 methods:
By editing innodb_buffer_pool_size in the my.cnf
By command ...
- 561
0
votes
1
answer
6k
views
How to release the physical and virtual memory used from the mysql server? [closed]
Several php scripts are executed via crontab on my CentOS 6.5, every php script contains a least one database request. Depending on the size and type of the php object, too much physical memory is ...
- 513
3
votes
3
answers
253
views
server's memory taken up almost to 8GB
Lately, our server face problem with the memory. Started from few weeks ago, our server was loading very slow. Accessing emails and websites were really take too long. Then we asked the server ...
- 141
-1
votes
1
answer
70
views
Memory on dedicated server is filled out [duplicate]
We are managing a dedicated server (WHM/cPanel) with 4-5(Magento & Woocommerce mostly) accounts in it, along with custom code that will connect those platforms with ERPs. This custom code works a ...
- 101
1
vote
0
answers
205
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 ...
- 111
1
vote
2
answers
1k
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 ...
- 161
0
votes
1
answer
497
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 a ...
- 174
5
votes
3
answers
7k
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 ...
- 287
0
votes
1
answer
345
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 2.6.32-openvz-...
- 1,471
1
vote
2
answers
5k
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]: ...
- 207
2
votes
1
answer
2k
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 ...
- 133