环境:CentOS 5 , 源码安装的MySQL5.0.40在/usr/local/mysql下,rpm方式安装了perl-DBD-MySQL,perl-dbi 安装mysqlreport时的错误:网上找的资料都没有搞定,谁遇到过?如何搞定的?是不是MySQL版本问题? [root@lovexia MySQL]# ./mysqlreport install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot...
by xwmhmily - MySQL - 2009-01-16 16:48:20 阅读(5388) 回复(10)
my($location_code,$dma_name,$sql_insert_8,$sql_insert_6); sub insert_date_san { $sql_insert_8="insert into schedule_sync_log_tmp select date(DATE_SUB(ts ,INTERVAL 8 hour)), location_code,count(distinct hour(DATE_SUB(ts ,INTERVAL 8 hour))),'0','0' ...
报错信息是这样的: DBD::mysql::db do failed: Can't create database 'db_rosedalesy_com_cn'; database exists at cs.pl line 165. 如何屏蔽它。不让他显示在终端上。
机器上安装了mysql并且可以通过phpMyadmin正常使用 perl 版本是5.8.8 现在安装dbi-1.604报错: 信息如下: perl Makefile.PL make make test 一路都没什么错误 make install Installing /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/dbi/dbiXS.h Installing /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/dbi/dbixs_rev.h Installing /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/dbi/dbi.a...
运行一个CGI程序use dbi报错,perl是5.8.5,apache是2.0都是reahat自带的 Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/dbi/dbi.so' for module dbi: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/dbi/dbi.so: failed to map segment from shared object: Permission denied at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230., referer: http://localhost/...
mysqlreport 文档 mysqlreport 以很友好的方式显示 MySQL 状态变。事实上,它几乎报告了所有的状态。不像 SHOW STATUS 只是在显示了100多个状态值,mysqlreport 则以人性化的方式阐释和格式化了这些状态值,大大增加了其可读性。可以 点击这里 查看mysqlreport的例子。 mysqlreport 的好处是可以快速的查看各种状态参数组,从而了解服务器的运行状态情况,而无需从 SHOW STATUS 的结果中人工计算。例如索引读取比率是个重要的...
MySQL 5.0.40-log uptime 33 23:48:19 Wed Feb 27 02:30:01 2008 __ Key _________________________________________________________________ Buffer used 64.00M of 512.00M %Used: 12.50 Current 122.95M %Usage: 24.01 Write hit 9.59% Read hit 99.98% __ Questions ___________________________________________________________ Total 221.73M 75.5/s Com_ ...
1、mysqlreport 简介 mysqlreport 是一个用perl语言编写的MySQL数据库监控脚本,是一个自由软件,它把MySQL数据库的运行状态值(showstatus)以更友好的方式显示出来,通过它可以更方便的查看MySQL数据库的运行状况。目前该脚本的版本是3.5,下载网址是:http://hackmysql.com/scripts/mysqlreport.zip 。 2、mysqlreport安装方法 mysqlreport 是用perl语言编写,所以想要运行它首先需要安装perl环境;它还要与MySQL数据库...
作者: bychina 出自: http://www.linuxdiyf.com 1.perl安装 [root@oracle mysqlreport-3.4a]# perl -v This is perl, v5.8.5 built for i386-linux-thread-multi Copyright 1987-2004, Larry Wall Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should ...
my.ini [code][client] port=3306 [mysql] default-character-set=utf8 [mysqld] port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.0/" datadir="D:/MySQL/Data/" default-character-set=utf8 sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=512 query_cache_size=83M table_cache=1520 tmp_table_size=30M thread_cache_size=38 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_s...