Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I make sure MySQL is using all available memory?

Tags:

performance

database

mysql

innodb

Dumb question: I have 4 gb of RAM and my dataset is around 500 mb. How can I make sure MySQL/InnoDB is keeping my dataset in RAM?

like image 494
Carson Avatar asked Jul 26 '11 05:07

Carson

People also ask

How do I know if my MySQL memory Utilisation is high?

To view the running queries, mysql> SHOW [FULL] PROCESSLIST; Viewing the current processlist reveals queries that are running actively or even idle or sleeping processes.

How much RAM does MySQL use?

The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables.

2 Answers

MySQL Tuning Primer gives you lots info and recommendations regarding your MySQL performance. Keep in mind (and it will warn you), the instance should be running for a period of time to give you accurate feedback.

like image 183
Coder1 Avatar answered Sep 17 '22 12:09

Coder1

set the innodb_buffer_pool to 3G - InnoDB will load as much data it can in the buffer pool.

like image 43
Maxim Krizhanovsky Avatar answered Sep 19 '22 12:09

Maxim Krizhanovsky
Sign in to Comment

Related questions

phpMyAdmin error #1062 - Duplicate entry '1' for key 1
MySQL: Split column into two
Select all projects that have matching tags
Which performs better in a MySQL where clause: YEAR() vs BETWEEN?
how to optimize a left join query?
Calculates difference between two dates in PHP
Find duplicate strings in database
Row locking in MySql InnoDb with foreign key constraints and indexes applied?
MySQL: Shuffle a limited query result? [duplicate]
Group by a range of X days
How to use MySql and Entity Framework 4.1 code first
MYSQL Sum results of a calculation
GROUP BY query optimization
PHP set MySQL socket location
select more than one count in mysql
illegal 0000-00-00 00:00:00 timestamp being sent by php to mysql using codeigniter
Hibernate scheme naming differs between OS
How to subtract a query result from another query result in MYSQL
Insert non-English decimal points in mysql
Wildcard IP Banning with MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!