I run the mysqltuner at my server as below and i got error like below.
[root@127 /]# ./mysqltuner.pl
>> MySQLTuner 1.0.1 - Major Hayden <major@stripped>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:
[!!] Attempted to use login credentials, but they were invalid.
On some other server this script is running absolutely fine without any change in
Please guide me how can i run this script
Thanks & Regards
----- Original Message -----
From: "Bruce Ferrell" <bferrell@stripped>
Sent: Thursday, October 15, 2009 12:20 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
> Have a look at mysqltuner. It reads the stats from a running mysql
> instances and makes suggestions for what can be changed
> Gavin Towey wrote:
>> This script might help with some tuning suggestions, run it after you have some
> production traffic running against your database.
>> Also you should enable the slow query log, so you can capture queries to be
>> Gavin Towey
>> -----Original Message-----
>> From: jeetendra.ranjan@stripped [mailto:jeetendra.ranjan@stripped]
>> Sent: Wednesday, October 14, 2009 3:21 AM
>> To: mysql@stripped
>> Subject: Req. suitable .cnf file for Server used by 2000 users daily
>> Will you plesae guide me ?
>> We are about to launch one website whose database is in MySQL. I am very exited
> about the server setting specially about .cnf file.
>> I have below hardware and .cnf details. Will you please guide me is the .cnf file
> details sufficient to support current hardware.
>> Initially 2000 users will visit this site everyday.
>> Hardware and OS
>> Operating System : Red Hat Fedora Core 8
>> Processor : Intel Core 2 Quad - 2.83 GHz,
>> RAM : 4 GB
>> Total Disk Space : 600 GB (300 GB usable)
>> RAID : RAID1
>> Disk Drive(s) : 300 GB (Drive #1), 300 GB (Drive #2)
>> Bandwidth Quota : 500 GB
>> Firewall : PIX 501
>> Version : 5.0.81-community-log
>> Version_comment : MySQL Community Edition (GPL)
>> Version Compile Machine : i686
>> Version Compile OS : pc-linux-gnu
>> my.cnf details
>> # Default to using old password format for compatibility with mysql 3.x
>> # clients (those using the mysqlclient10 compatibility package).
>> key_buffer = 16M
>> max_allowed_packet = 32M
>> table_cache = 256
>> net_buffer_length = 8K
>> read_buffer_size = 2M
>> read_rnd_buffer_size = 2M
>> myisam_sort_buffer_size = 8M
>> # Comment the following if you are using InnoDB tables
>> innodb_data_home_dir = /var/lib/mysql/
>> innodb_data_file_path = ibdata1:10M:autoextend
>> innodb_log_group_home_dir = /var/lib/mysql/
>> # You can set .._buffer_pool_size up to 50 - 80 %
>> # of RAM but beware of setting memory usage too high
>> innodb_buffer_pool_size = 4M
>> innodb_additional_mem_pool_size = 2M
>> # Set .._log_file_size to 25 % of buffer pool size
>> innodb_log_file_size = 16M
>> innodb_log_buffer_size = 8M
>> innodb_flush_log_at_trx_commit = 1
>> innodb_lock_wait_timeout = 50
>> Thanks in advance
>> Jeetendra Ranjan
>> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s) named above. If
> you are not the intended recipient, you are hereby notified that any review,
> dissemination, distribution or duplication of this communication is strictly prohibited.
> If you are not the intended recipient, please contact the sender by reply email and
> destroy all copies of the original message.