MySQL application runs slow after general usage

mb1987 Published at Dev

mb1987

I am currently using MySQL. I have noticed several times my front application runs slow after some usage. when i checked server status in MySQL workbench. I have noticed that innodb buffer usage was going to 100% . so I increased parameter innodb_buffer_pool_size to 1G in my.ini file of xampp. but innodb is not flushing the buffer and application runs slow after some time. is there any other parameters to change as-well?

edlerd

consider using a size for innodb_buffer_pool_size of 70%-80% of available ram. Depending on how big your dataset is, you should increase the size.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-13

Comments

0 comments

From Dev

Related Related

Article

MySQL application runs slow after general usage

MySQL application runs slow after general usage

SSE runs slow after using AVX

mysql query runs slow with multiple conditionals in where

Application Slow after a couple of uses

SQL Server runs very slow when called from .NET application

How to terminate application after 10 runs?

Swing application slow after restart with ProcessBuilder

MySql queries slow after dropping database with .NET

query extremely slow after migration to mysql 5.7

regex runs too slow

Have you noticed that dispatch_after runs ~10% too slow on iOS devices?

JDK7 Application is getting slow after some Uptime

JDK7 Application is getting slow after some Uptime

PHP Application loading slow after database size increased gradually

FLANN in opencv runs too slow

Cronjob under Ubuntu runs slow

Proper Redux usage general questions

Slow MYSQL query after using inner join and sub query

Slow MySQL query after adding multiple OR conditions to indexed column

MYSQL insert/update slow after updating schema and loading via source

My python codes in general are very slow, is this normal?

general connection to a mysql server

mysql: turn on the general log

MySql General error: 2053

PHP / MySQL General Error

general connection to a mysql server

VBA runs very slow on changing external link

Ruby factorial code runs too slow

Fast query runs slow in SSRS 2

Cassandra simple query runs very slow