I currently manage a website that maintains about 30 simultaneous simultaneous connections up there, but in
phpmyadmin a series of alerts have appeared from the "current status" section, all the state variables, in summary these are the alerts:
The number of connections that were abandoned because the client He died without closing the connection properly.
Number of MySQL server connection attempts failed.
Created tmp disk tables
The number of temporary tables on the disk that were created automatically by the server while executing the statements. Yes The Created_tmp_disk_tables tables is large, you can increase the value of tmp_table_size to make temporary tables based in memory instead of being disk-based.
Handler read rnd
The number of requests made to read a row based on a fixed position. This is high if you are making many inquiries that require the reordering of the result. You probably has many queries that require MySQL to scan entire tables or you must have links (joins) that do not use the keys in a appropriate.
Handler read rnd next
The number of requests made to read the next row in the data file. This is high if you are doing a lot of scans of tables. Generally, this suggests that your tables are not appropriately indexed or that your queries are not written for Take advantage of the indexes you have.
Innodb buffer pool reads
The number of logical readings that InnoDB could not satisfy the reservation of buffers and where it was necessary to read a simple page.
Innodb row lock time avg
The average time to acquire a row lock, in milliseconds.
Innodb row lock time max
The maximum time to acquire a row lock, in milliseconds.
Innodb row lock waits
The number of times a row lock had to wait.
The number of tables that have been opened. If the number of open tables is large, their table cache value is probably very small.
Select full join
The number of links (joins) that do not use indexes. If this value is not 0, you should check the indexes of your tables carefully.
The number of queries that have taken more seconds than those registered in long_query_time.Documentation
Sort merge passes
The number of combination passes that the algorithm has organized due to do. If this value is large, you should consider increasing the value of the system varible sort_buffer_size.
Table locks waited
The number of times a table lock could not be acquired immediately and a wait was necessary. If this value is high, and there are problems of performance, you must first optimize your queries, and then, either split your tables or use replication.
Tipo de servidor: MariaDB Versión del servidor: 10.0.34-MariaDB-0ubuntu0.16.04.1 - Ubuntu 16.04 Versión del protocolo: 10