Zabbix and MPM monitoring MySQL
Environment DescriptionA: 192.168.1.190, CentOS 6.3, Zabbix Server deployedB: 192.168.1.191, CentOS 6.3, Zabbix Agent, MySQL 5.5.29 (MySQL Slave)
MPM/Zabbix monitoring structure and deployment stepsMPM/Zabbix monitoring structure:Follow these steps to monitor MySQL using MPM/Zabbix:
Install and deploy Zabbix
Download an
Apache under three MPM modes: Prefork,worker and EventMPM (multi-processing module, multi-process processing module): Prefork,worker and Event to view the Apache mode, you can use the HTTPD-V command to view: /usr/local/apache2/bin/httpd-vserver version:apache/2.2.29 (Unix) Server Built:aug 20:11:21server ' s Module
1. What is MPM?Multi-Processing Module (MPM) implements a hybrid multi-process multi-threaded server. (Multi-process, multi-threaded)2, how many kinds of MPM?Roughly: Prefork mpm, worker MPM, BeOS
Mysql monitoring tool: zabbix + MPM (PerformanceMonitorforMySQL)
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 diagram.
It consists of two parts:
1. zabbix template: Template_FromDual.MySQL. *. xml
2.
MPM is mainly used to monitor the performance indicators of various mysql parameters. The following is a brief description of its configuration with zabbix: The following is its configuration file relationship diagram, which mainly includes two parts: 1. zabbix template: template_FromDualMySQL * xml2, MPMagentperl module: Fro MPM is mainly used to monitor various
/zabbix/script/mpm/etc/fromdualmysqlagent.conf.template/usr/local/zabbix/etc/zabbix_mpm.confCat zabbix_mpm.conf[Default]Type = mysqldDebug = 2LogFile =/var/log/zabbix/fromdualmysqlagent.log# Directory where the Cache files should is written to:Cachefilebase =/var/log/zabbix/cache/fromdualagentcache# Information for MySQL connections:Username = userPassword = PasswordMysqlhost = 127.0.0.1Mysqlport = 3306# Zabbix Server IP AddressZabbixserver = 10.6.9.8
Zabbix full MySQL monitoring with fpmmm (MPM) module (Performance Monitor for MySQL)Fpmmm is the fromdualperformance Monitor for MySQL and MariaDB and the counterpart to the MySQL Enterprisemonitor from Ora Cle. With fpmmm-can monitor your MYSQL/MARIADB databases AndAlso your database hosts (machines). Fpmmm works on Linux and SH Ould also Workon Mac OSX (and possibly some other *BSD derivatives). Windows s
Our environment with Zabbix MPM to monitor MySQL, but recently the official website has not called MPM, but called fpmmm, for the reasons:fpmmm is the successor of mpm. mpm was renamed to fpmmm because of the naming conflict with the Apache Multi-Processing Modules (MPM).Wel
MPM is an Apache multi-channel processing module that defines how Apache handles client requests. The three MPM models commonly used in Linux are prefork, worker, and event.Prefork:A pre-build process in which a request responds with a process. The Apache2.2 version uses the Prefork model by default. Advantages: Stable and reliable, high execution efficiency, the
. Mpm:multi-processing module multi-processing modules with support for three I/O models: prefork,worker,event. prefork: Multi-process I/O model, each process responds to a request, the default modelOne main process: Generate and Reclaim n child processes, create sockets, do not respond to requestsMultiple child processes: The work process, each child process processing a request, the system initially, the pre-generation of several idle processes, wai
) visited once
Time perrequest:5.411 [MS] (mean, acrossall concurrent requests) #一个人访问一次花费的时间
Transfer rate:37.18 [Kbytes/sec] Received
In addition, if we increase the number of concurrent numbers to 500, that is, the command is adjusted to Ab.exe-n 10000-c http://localhost/test/index.php it will appear the following results.[Plain]View Plain Copy
Apr_socket_connect (): Unable to connect because the target computer was actively refused. (730061)
Total of 902 requestscompleted
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 diagram.
It consists of two parts:
1. zabbix template:Template_FromDual.MySQL.*.xml
2.
Apache is based on modular design.The basic service also uses a modular design, but this module is exclusive and can only be called at the same time.The MPM (multi processing module) multi-processing module is a basic module. It was originally run on the Unix family of opera
Tags: database mysql Zabbix1. Preface Zabbix as open source free monitoring software, its easy to manage the configuration and visualization of the view, the regular maintenance of historical data, templated monitoring projects more and more by the majority of IT operations and maintenance staff favorite. Here is the main summary of the next Zabbix server and MPM using Yum for rapid deployment. The more detailed things, people still look at the offici
See the recommendations of http://blog.phusion.nl/2013/03/12/tuning-phusion-passengers-concurrency-settings/ , It is intended to test the performance improvement of the passenger using the worker mpm.Experiment Settings:Subjects: Web service written by railsLab Tools: http://gatling.io/-based performance test code written by yourself in ScalaTwo experimental groups
Prefork MPM (default)-Apache defaults to the current
Mysql Fpmmm is an upgraded version of MPM. It is more convenient to use fpmmm than mpm, but the corresponding optimization parameters must be enabled.1. Configure the pidCopy the startup scriptCp support-files/mysql. server/etc/init. d/mysqldChkconfig -- add mysqldService mysqld startPid-file =/var/run/mysqld. pidConfigure environment variablesVim/etc/profile. d/mysql. shExport PATH =/usr/local/mysql/bin: $
temporarily unavailable:apr_thread_create:unable to create workEr threaderror in My_thread_global_end (): 1 threads didn ' t exiterror in My_thread_global_end (): 1 threads didn ' t exiterror In My_thread_global_end (): 1 threads didn ' t exitThis is actually caused by two reasons:1. System kernel limitations, mainly max user processes, this parameter defaults to 1024, which means limiting the maximum process usage per user, and exceeding this limit will cause the HTTPD service to fail to start
The parameter of apache mpm-event cannot be adjusted.
After several working modes of apache are introduced earlier, a series of problems may occur in parameter adjustment:
The httpd service cannot be started after/usr/local/apache/bin/apachectl-k start. The error log reports the following error:
[Fri May 08 08:21:00.903245 2015] [core:warn] [pid 29799:tid 140652774147840] AH00098: pid file /usr/local/apache/logs/httpd.pid overwritten -- Unclean shutd
MPM multi-Process Processing moduleMPM is divided into three modes:1,preforkProcess model, each process processes a request, pattern: Parent Process —————— > multiple child Processes —————— > One child process processing a request2,workerThreading model, each process derives multiple threads, each thread processes a request, pattern: Parent Process —————— > multiple child processes —————— > Multiple threads are derived from each child process------->
Apache defaults to a thread-safe prefork,prefork MPM that uses multiple child processes, each of which has one thread, each processing only one request connection at a time, and one request fails to affect other requests, which is thread-safeWorkers use multi-process multithreading, each with multiple threads, each processing a request connection, with higher performance, but non-thread-safe.PHP's official recommendation does not use the thread of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.