配置 Cacti 监控 MySQL 数据库状态
MySQL 自身在性能监测方面很不给力、这是令许多 MySQL DBA 夜夜辗转难眠、幸运的是、通过 Cacti 监测（注意是监测而非监控）MySQ
首页 → 数据库技术
背景：
阅读新闻
配置 Cacti 监控 MySQL 数据库状态
[日期：2013-04-18] 来源：Linux社区 作者：linwaterbin [字体：]
MySQL 自身在性能监测方面很不给力、这是令许多 MySQL DBA 夜夜辗转难眠、幸运的是、通过 Cacti 监测（注意是监测而非监控）MySQL 数据库状态。
借助 cacti+rrdtool 强大的绘图功能、加上专用的 mysql 模板、能够灵活快速的创建对多个 MySQL 实例的监测
㈠ 如果是RPM方式安装，需要下列RPM包：
httpd
php
php-mysql
php-snmp
mysql
mysql-server
net-snmp*
㈡ 安装 RRDTool
# wget
# tar -zxv -f rrdtool-1.4.4.tar.gz
# ./configure --prefix=/usr/local/rrdtool --disable-python --disable-tcl
# make
# make install
可能遇到的故障：
configure: error: Please fix the library issues listed above and try again
请查阅→→troubleshoting
㈢ 安装 CACTI
# wget
# useradd cacti
# tar -zxv -f cacti-0.8.7i.tar.gz
# mv cacti-0.8.7i /var/www/cacti
# chown -R cacti:cacti /var/www/cacti
㈣ 配置 apache 模块
编辑 apache 配置文件：vim httpd.conf
① 修改服务名称：
ServerAdmin 192.168.1.113:80
② 修改站点起始目录：
DocumentRoot "/var/www"
③ 修改目录：
④ 增加默认做为首页的文件名：
DirectoryIndex index.html index.php
⑤ 增加对php类型的支持：
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
然后:wq保存退出！
执行 apachectl -t 检查配置文件语法，正常情况下应返回Syntax OK：
启动snmp服务：service snmpd start
启动apache服务：apachectl start
Oracle最简单的查询表空间的使用量、剩余量的方法
Oracle如何实现两个数据库的同步（用实体化视图实现）（Oracle快照实例）
相关资讯 CACTI Cacti配置 Cacti监控 Cacti监控MySQL
图片资讯
本文评论 查看全部评论 (0)
评论声明
最新资讯
本周热门
Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站（LinuxIDC）所刊载文章不代表同意其说法或描述，仅为提供更多信息，，也不构成任何建议。
Copyright © 2006-2014 Linux公社 All rights reserved 浙ICP备06018118号
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What are constants in C language? Can you give an example?
Aug 28, 2023 pm 10:45 PM
A constant is also called a variable and once defined, its value does not change during the execution of the program. Therefore, we can declare a variable as a constant referencing a fixed value. It is also called text. Constants must be defined using the Const keyword. Syntax The syntax of constants used in C programming language is as follows - consttypeVariableName; (or) consttype*VariableName; Different types of constants The different types of constants used in C programming language are as follows: Integer constants - For example: 1,0,34, 4567 Floating point constants - Example: 0.0, 156.89, 23.456 Octal and Hexadecimal constants - Example: Hex: 0x2a, 0xaa.. Octal
VSCode and VS C++ IntelliSense not working or picking up libraries
Feb 29, 2024 pm 01:28 PM
VS Code and Visual Studio C++ IntelliSense may not be able to pick up libraries, especially when working on large projects. When we hover over #Include<wx/wx.h>, we see the error message "CannotOpen source file 'string.h'" (depends on "wx/wx.h") and sometimes, autocomplete Function is unresponsive. In this article we will see what you can do if VSCode and VSC++ IntelliSense are not working or extracting libraries. Why doesn't my Intellisense work in C++? When working with large files, IntelliSense sometimes
Fix Xbox error code 8C230002
Feb 27, 2024 pm 03:55 PM
Are you unable to purchase or watch content on your Xbox due to error code 8C230002? Some users keep getting this error when trying to purchase or watch content on their console. Sorry, there's a problem with the Xbox service. Try again later. For help with this issue, visit www.xbox.com/errorhelp. Status Code: 8C230002 This error code is usually caused by temporary server or network problems. However, there may be other reasons, such as your account's privacy settings or parental controls, that may prevent you from purchasing or viewing specific content. Fix Xbox Error Code 8C230002 If you receive error code 8C when trying to watch or purchase content on your Xbox console
Recursive program to find minimum and maximum elements of array in C++
Aug 31, 2023 pm 07:37 PM
We take the integer array Arr[] as input. The goal is to find the largest and smallest elements in an array using a recursive method. Since we are using recursion, we will iterate through the entire array until we reach length = 1 and then return A[0], which forms the base case. Otherwise, the current element is compared to the current minimum or maximum value and its value is updated recursively for subsequent elements. Let’s look at various input and output scenarios for this −Input −Arr={12,67,99,76,32}; Output −Maximum value in the array: 99 Explanation &mi
China Eastern Airlines announces that C919 passenger aircraft will soon be put into actual operation
May 28, 2023 pm 11:43 PM
According to news on May 25, China Eastern Airlines disclosed the latest progress on the C919 passenger aircraft at the performance briefing meeting. According to the company, the C919 purchase agreement signed with COMAC has officially come into effect in March 2021, and the first C919 aircraft has been delivered by the end of 2022. It is expected that the aircraft will be officially put into actual operation soon. China Eastern Airlines will use Shanghai as its main base for commercial operations of the C919, and plans to introduce a total of five C919 passenger aircraft in 2022 and 2023. The company stated that future introduction plans will be determined based on actual operating conditions and route network planning. According to the editor's understanding, the C919 is China's new generation of single-aisle mainline passenger aircraft with completely independent intellectual property rights in the world, and it complies with internationally accepted airworthiness standards. Should
C++ program to print spiral pattern of numbers
Sep 05, 2023 pm 06:25 PM
Displaying numbers in different formats is one of the basic coding problems of learning. Different coding concepts like conditional statements and loop statements. There are different programs in which we use special characters like asterisks to print triangles or squares. In this article, we will print numbers in spiral form, just like squares in C++. We take the number of rows n as input and start from the top left corner and move to the right, then down, then left, then up, then right again, and so on and so on. Spiral pattern with numbers 123456724252627282982340414243309223948494431102138474645321120373635343312191817161514
The function of void keyword in C language
Feb 19, 2024 pm 11:33 PM
void in C is a special keyword used to represent an empty type, which means data without a specific type. In C language, void is usually used in the following three aspects. The function return type is void. In C language, functions can have different return types, such as int, float, char, etc. However, if the function does not return any value, the return type can be set to void. This means that after the function is executed, it does not return a specific value. For example: voidhelloWorld()
For the first time in 23 years, C# wins the TIOBE 2023 Programming Language of the Year Award
Jan 11, 2024 pm 04:45 PM
According to the TIOBE Programming Community Index, one of the benchmarks for measuring the popularity of programming languages, it is evaluated by collecting data from engineers, courses, vendors and search engines around the world. The TIOBE Index in January 2024 was released recently, and the official programming language rankings for 2023 were announced. C# won the TIOBE 2023 Programming Language of the Year. This is the first time that C# has won this honor in 23 years. TIOBE's official press release stated that C# has been in the top 10 for more than 20 years. Now it is catching up with the four major languages and has become the programming language with the largest growth in one year (+1.43%). It well-deserved to win this award. Ranked second are Scratch (+0.83%) and Fortran (+0
