mysql monitor queries

MySQL processes tens of millions of data queries and paging bitsCN.com MySQL database optimization allows for fast paging analysis of tens of millions of data records. The data table collect (id, title, info, vtype) has these four fields, where title is fixed length, info is text, id is gradual, vtype is tinyint, and vtype is index. This is a simple model of a ba

; View a library of situations ... mysql> select CONCAT (Table_schema, '. ', TA Ble_name) as ' Table name ', CONCAT (ROUND (table_rows/1000000,4), ' M ') as ' number of rows ', CONCAT (ROUND (data_length/(1024* 1024*1024), 4), ' G ') as ' Data size ', CONCAT (ROUND (index_length/(1024*1024*1024), 4), ' G ') as ' Index Size ', CONCAT (( Data_length+index_length)/(1024*1024*1024), 4), ' G ') as ' total ' from INFORMATION_SCHEMA. TABLES WHERE table_schem

MySQL queries the first few records of different categories in the same table, bitsCN.com Scenario: An article table stores articles about PHP and MySQL, and you want to extract N records from each of these article categories. Test table statement: CREATETABLEarticle ( IdINTUNSIGNEDNOTNULLAUTO_INCREMENTPRIMARYKEY, CateVARCHAR (20 ), TitleVARCHAR (20) );

Monitor SQL statement execution efficiency based on mysql slow logsEnable MySQL log-slow-queries (slow query records ).In Linux, find my. cnf file (usually in/etc/mysql/), and you may find that the file cannot be saved after modification, because you do not have the correspo

Describes sub-query operations in MySQL and mysql queries in detail. Continue with the following preparations: Create a test database TestDB; create database TestDB; Create test tables table1 and table2; CREATE TABLE table1 ( customer_id VARCHAR(10) NOT NULL, city VARCHAR(10) NOT NULL, PRIMARY KEY(customer_id) )ENGINE=INNODB DEFAULT CHARSET=

Mysql monitoring tools: zabbix + MPM (Performance Monitor for MySQL), zabbixmpm MPM is mainly used to monitor various mysql parameter performance indicators. The following describes the configuration of MPM and zabbix: The following figure shows the configuration file diagra

This article introduces two tips: how mysql converts a timestamp to a common time format and how MySql queries the current database time. (1) run the following command to query the current time of a database in MySql: Select now (); // return format: 11:44:42 (2) mysql conve

Mysql enables slow query logs and queries-windows, mysql-windows MySQL slow query Configuration 1. What is the use of slow queries? It records all SQL statements that have been executed longer than long_query_time, and helps you find slow SQL statements to optimize these

30 common methods for optimizing SQL statement queries in MySQL, bitsCN. com1. to optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. try to avoid using it in the where clause! = Or 3. try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard the index and perform full table

CACTI: Use templates to monitor mysql and cactimysql on local or other servers Mysql templates, online are using this address http://mysql-cacti-templates.googlecode.com has not been accessed Google found this URL: Introduction: http://www.percona.com/doc/percona-monitoring-plugins/1.0/cacti/

Uninstall MySQL Enterprise Monitor and mysqlenterprise in LinuxMySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key performance indicators, hosts, d

Tags: database dba mysql LinuxMySQL Enterprise Monitor is a business-class monitor designed specifically for MySQL databases, and is well-integrated with MySQL features, including key performance metrics for MySQL, host, disk, bac

CACTI: Use a template to monitor mysql on a local server or another server Mysql templates, online are using this address http://mysql-cacti-templates.googlecode.com has not been accessed File currently downloaded: percona-cacti-templates-1.1.4-1.noarch.rpm Local server monitoring local

Tags: thread NES master user query connection and SOC uptimeAfter you install MySQL, you need to monitor the MySQL service.Nagios Open source Check_mysql is good for MySQL's slave machine monitoring. However, the database host monitoring is slightly inadequate. Use a monitoring plugin: Check_mysql_health download and use the method see:http://exchange.nagios.org

Detailed description of how MySQL queries Time Zone strings with uppercase and lowercase letters, mysql Case If you insert two rows of values 'A' and 'A' in A column with a unique constraint on mysql, Mysql considers it to be the same, but it does not exist in oracle. Is the

'/usr/local/zabbix/etc/ zabbix_server.conf sed-i ' s/^.*dbpassword=.*$/dbpassword=zabbix/g '/usr/local/zabbix/etc/zabbix_server.conf sed-i ' s/basedir=\/usr\/local/basedir=\/usr\/local\/zabbix/g '/etc/init.d/zabbix_server sed-i ' s/ Basedir=\/usr\/local/basedir=\/usr\/local\/zabbix/g '/etc/init.d/zabbix_agentd 7, add service port: Cat >>/etc/services 8, start the service /etc/init.d/zabbix_server start /etc/init.d/zabbix_agentd start echo "/etc/init.d/zabbix_server s

The following articles mainly introduce three very useful methods to optimize MySQL database queries. We all know that in MySQL database query optimization queries, database applications (such as MySQL (the best combination with PHP) actually mean the operation and use of to

Mysql randomly queries several pieces of data bitsCN.com Mysql randomly queries several data entries To query five non-duplicate data records in mysql, use the following: SELECT * FROM 'table' order by rand () LIMIT 5 You can. However, the test results show that the effici

New Connection7. Click Connect and the monitoring interface is as follows:Fifth step: Related monitoring introduction1.MySQL related1.1 Activity->mutex corresponds to Show engine InnoDB Mutex1.2 Activity->innodb status corresponds to show engine InnoDB status;1.3 Activity->error Log shows the most recent error for the current connection, including the creation of the database, startup, creation of a table or the check repair, and a creation of log

Nagios monitoring mysql Server:1. Create a dedicated database:[Root @ svr3 ~] #/Usr/local/webserver/mysql/bin/mysql-u root-pEnter password:Welcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id is 51910Se