MySQL Forums
Forum List  »  Performance

slow performance, parameters or size and amounts of databases?
Posted by: Kristof Schevernels
Date: June 19, 2020 08:20AM

Hello,

I have mysql databases on different servers with same type of storage.

On 1 database it takes less then 2 seconds to insert 1000 records in an empty table, the other (call it the slow one), it takes more then 18s.

the only difference is the memory and CPU, the fast one 32G and 16cpu, the slow one, 98G and 8CPU (already set it to 128GB RAM but no difference).

another difference is that the fast one has only 1 user database and the slow one has about 315 user databases and the biggest is 215GB (and a lot of them are empty).

database parameters (and first is the slow one, the second (behind the 'vs' is the fast one):

innodb_buffer_pool_size=48G vs 24G
innodb_parallel_doublewrite_path = /mysql/tmp/xb_doublewrite vs not in my.cnf
innodb_temp_data_file_path=../tmp/ibtmp1:12M:autoextend vs not in my.cnf
key_buffer_size=10G vs 1G

these parameters and other are same on both:
table_open_cache=8192
max_allowed_packet= 128M
innodb_log_file_size=2047M
innodb_buffer_pool_instances = 8
innodb_open_files=16384
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=1
innodb_write_io_threads=64
innodb_read_io_threads=64
max_connections=5000

what can it be? parameter settings, cpu or system settings on OS?

please ask for more information if you need?

thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
slow performance, parameters or size and amounts of databases?
360
June 19, 2020 08:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.