D
D
DarkMatter2016-03-07 19:50:51
MySQL
DarkMatter, 2016-03-07 19:50:51

A couple of questions about setting up mysql?

innodb_additional_mem_pool_size - the amount of memory allocated by InnoDB to store various internal structures. If InnoDB does not have enough of this memory, it will request memory from the OS and write a warning to the MySQL error log.
I don't have such a value in my.cnf. What is the default in this case and what goes into the error log?
innodb_buffer_pool_size - the amount of memory allocated by InnoDB for storing both indexes and data.
Also in my.cnf there is no such setting at all, what is its default value in this case?
Where, how to see the state variables Key_reads and Key_read_requests

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Igor, 2016-03-07
@darkmatter

SHOW GLOBAL VARIABLES;
SHOW VARIABLES;
If you didn’t configure anything, you can see the current value there.
and a little about setting up https://habrahabr.ru/post/66684/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question