Req. suitable .cnf file for Server used by 2000 users daily

--================_5267324_2==_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,
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
***********
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
key_buffer = 16M
key_buffer_size=4M
sort_buffer_size=2M
query_cache_size=64M
log-bin
log_queries_not_using_indexes=1
long_query_time=1
log_slow_queries=slowQry.log
join_buffer_size=4M
max_connections=150
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
thread_stack=5M
thread_cache_size=128M
connect_timeout=30
query_cache_limit=32M
log-error
# 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
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks in advance
Regards
Jeetendra Ranjan


--================_5267324_2==_--

Re: Req. suitable .cnf file for Server used by 2000 users daily

jeetendra.ranjan@sampatti.com wrote:
> Hi,
> 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
> *************
> ... snip ...

Unfortunately, you have not asked us an answerable question. There are
too many unknowns in your setup for us to estimate how much database
usage per customer your site will create. If it's a single query per
visitor, then you probably can omit any tuning at all. If each visit
requires dozens of queries each using multiple tables then you have a
totally different usage profile.

It all boils down to what you are doing to the database, not how many
people are doing it.

What can you tell us about your application, how many rows of data you
plan to manage, if your data is mostly MyISAM or InnoDB, and what
performance numbers you have achieved so far using your lab equipment
and a simulated user load. Also, is your MySQL database sharing the same
box as your web server or are they located in separate machines?

At that point, we may be able to make a reasonable guess about your
situation.

--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Req. suitable .cnf file for Server used by 2000 users daily

Hi,

This script might help with some tuning suggestions, run it after you have =
some production traffic running against your database.
https://launchpad.net/mysql-tuning-primer

Also you should enable the slow query log, so you can capture queries to be=
optimized:
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html

http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html


Regards,
Gavin Towey


-----Original Message-----
From: jeetendra.ranjan@sampatti.com [mailto:jeetendra.ranjan@sampatti.com]
Sent: Wednesday, October 14, 2009 3:21 AM
To: mysql@lists.mysql.com
Subject: Req. suitable .cnf file for Server used by 2000 users daily

Hi,
Will you plesae guide me ?
We are about to launch one website whose database is in MySQL. I am very ex=
ited about the server setting specially about .cnf file.
I have below hardware and .cnf details. Will you please guide me is the .cn=
f 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
***********
[mysqld]
datadir=3D/var/lib/mysql
socket=3D/var/lib/mysql/mysql.sock
user=3Dmysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=3D1
key_buffer =3D 16M
key_buffer_size=3D4M
sort_buffer_size=3D2M
query_cache_size=3D64M
log-bin
log_queries_not_using_indexes=3D1
long_query_time=3D1
log_slow_queries=3DslowQry.log
join_buffer_size=3D4M
max_connections=3D150
max_allowed_packet =3D 32M
table_cache =3D 256
net_buffer_length =3D 8K
read_buffer_size =3D 2M
read_rnd_buffer_size =3D 2M
myisam_sort_buffer_size =3D 8M
thread_stack=3D5M
thread_cache_size=3D128M
connect_timeout=3D30
query_cache_limit=3D32M
log-error
# Comment the following if you are using InnoDB tables
innodb_data_home_dir =3D /var/lib/mysql/
innodb_data_file_path =3D ibdata1:10M:autoextend
innodb_log_group_home_dir =3D /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 =3D 4M
innodb_additional_mem_pool_size =3D 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size =3D 16M
innodb_log_buffer_size =3D 8M
innodb_flush_log_at_trx_commit =3D 1
innodb_lock_wait_timeout =3D 50
[mysqld_safe]
log-error=3D/var/log/mysqld.log
pid-file=3D/var/run/mysqld/mysqld.pid
Thanks in advance
Regards
Jeetendra Ranjan


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Re: Req. suitable .cnf file for Server used by 2000 usersdaily

--================_5267324_2==_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Shawn,

Thanks for your reply.
This is basically a marketing website for different products. The site will be visited by the marketer and the customer.

Here is answer as you asked:

1) The customer and the marketer will visit only one database and they have no right to create database by them.

2) Its multiple query per visitor which uses tables in only one database.

3) Few tables will be very haeavy and there may be millions of rows in one tables.

4) Few heavy tables are Innodb and few are MyISAM

5) Yes, MySQL database sharing the same box as web server.

I mostly concern about connectoins. Initially 2000 visitor including marketer and customer will visit this site.

Thanks in advance.


Regards
Jeetendra Ranjan

At 21:21 14/10/2009, Shawn Green wrote:


jeetendra.ranjan@sampatti.com wrote:
> Hi,
> 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
> *************
> ... snip ...

Unfortunately, you have not asked us an answerable question. There are
too many unknowns in your setup for us to estimate how much database
usage per customer your site will create. If it's a single query per
visitor, then you probably can omit any tuning at all. If each visit
requires dozens of queries each using multiple tables then you have a
totally different usage profile.

It all boils down to what you are doing to the database, not how many
people are doing it.

What can you tell us about your application, how many rows of data you
plan to manage, if your data is mostly MyISAM or InnoDB, and what
performance numbers you have achieved so far using your lab equipment
and a simulated user load. Also, is your MySQL database sharing the same
box as your web server or are they located in separate machines?

At that point, we may be able to make a reasonable guess about your
situation.

--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN




--================_5267324_2==_--

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

http://blog.mysqltuner.com/



Gavin Towey wrote:
> Hi,
>
> This script might help with some tuning suggestions, run it after you have some production traffic running against your database.
> https://launchpad.net/mysql-tuning-primer
>
> Also you should enable the slow query log, so you can capture queries to be optimized:
> http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
>
> http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
>
>
> Regards,
> Gavin Towey
>
>
> -----Original Message-----
> From: jeetendra.ranjan@sampatti.com [mailto:jeetendra.ranjan@sampatti.com]
> Sent: Wednesday, October 14, 2009 3:21 AM
> To: mysql@lists.mysql.com
> Subject: Req. suitable .cnf file for Server used by 2000 users daily
>
> Hi,
> 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
> ***********
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> user=mysql
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> old_passwords=1
> key_buffer = 16M
> key_buffer_size=4M
> sort_buffer_size=2M
> query_cache_size=64M
> log-bin
> log_queries_not_using_indexes=1
> long_query_time=1
> log_slow_queries=slowQry.log
> join_buffer_size=4M
> max_connections=150
> 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
> thread_stack=5M
> thread_cache_size=128M
> connect_timeout=30
> query_cache_limit=32M
> log-error
> # 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
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> Thanks in advance
> Regards
> 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.
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Req. suitable .cnf file for Server used by 2000 usersdaily

------=_NextPart_000_0016_01CA5182.B36E5070
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I run the mysqltuner at my server as below and i got error like below.=20
[root@127 /]# ./mysqltuner.pl

>> MySQLTuner 1.0.1 - Major Hayden
>> 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:=20
[!!] Attempted to use login credentials, but they were invalid.

On some other server this script is running absolutely fine without any =
change in mysqltuner.pl.

Please guide me how can i run this script


Thanks & Regards
Jeetendra Ranjan

----- Original Message -----=20
From: "Bruce Ferrell"
To:
Cc:
Sent: Thursday, October 15, 2009 12:20 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily


>=20
> Have a look at mysqltuner. It reads the stats from a running mysql
> instances and makes suggestions for what can be changed
>=20
> http://blog.mysqltuner.com/
>=20
>=20
>=20
> Gavin Towey wrote:
>> Hi,
>>=20
>> This script might help with some tuning suggestions, run it after you =
have some production traffic running against your database.
>> https://launchpad.net/mysql-tuning-primer
>>=20
>> Also you should enable the slow query log, so you can capture queries =
to be optimized:
>> http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
>>=20
>> http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
>>=20
>>=20
>> Regards,
>> Gavin Towey
>>=20
>>=20
>> -----Original Message-----
>> From: jeetendra.ranjan@sampatti.com =
[mailto:jeetendra.ranjan@sampatti.com]
>> Sent: Wednesday, October 14, 2009 3:21 AM
>> To: mysql@lists.mysql.com
>> Subject: Req. suitable .cnf file for Server used by 2000 users daily
>>=20
>> Hi,
>> 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.
>>=20
>> 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
>> ***********
>> [mysqld]
>> datadir=3D/var/lib/mysql
>> socket=3D/var/lib/mysql/mysql.sock
>> user=3Dmysql
>> # Default to using old password format for compatibility with mysql =
3.x
>> # clients (those using the mysqlclient10 compatibility package).
>> old_passwords=3D1
>> key_buffer =3D 16M
>> key_buffer_size=3D4M
>> sort_buffer_size=3D2M
>> query_cache_size=3D64M
>> log-bin
>> log_queries_not_using_indexes=3D1
>> long_query_time=3D1
>> log_slow_queries=3DslowQry.log
>> join_buffer_size=3D4M
>> max_connections=3D150
>> max_allowed_packet =3D 32M
>> table_cache =3D 256
>> net_buffer_length =3D 8K
>> read_buffer_size =3D 2M
>> read_rnd_buffer_size =3D 2M
>> myisam_sort_buffer_size =3D 8M
>> thread_stack=3D5M
>> thread_cache_size=3D128M
>> connect_timeout=3D30
>> query_cache_limit=3D32M
>> log-error
>> # Comment the following if you are using InnoDB tables
>> innodb_data_home_dir =3D /var/lib/mysql/
>> innodb_data_file_path =3D ibdata1:10M:autoextend
>> innodb_log_group_home_dir =3D /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 =3D 4M
>> innodb_additional_mem_pool_size =3D 2M
>> # Set .._log_file_size to 25 % of buffer pool size
>> innodb_log_file_size =3D 16M
>> innodb_log_buffer_size =3D 8M
>> innodb_flush_log_at_trx_commit =3D 1
>> innodb_lock_wait_timeout =3D 50
>> [mysqld_safe]
>> log-error=3D/var/log/mysqld.log
>> pid-file=3D/var/run/mysqld/mysqld.pid
>> Thanks in advance
>> Regards
>> Jeetendra Ranjan
>>=20
>>=20
>> 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.
>>
------=_NextPart_000_0016_01CA5182.B36E5070--

Re: Req. suitable .cnf file for Server used by 2000 users daily

this error indicates either root doesn't have sufficient privilege or
the password entered was bad. try running it this way:

../mysqltuner.pl --user root --pass

Jeetendra Ranjan wrote:
> Hi,
>
> 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
> >> 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 mysqltuner.pl.
>
> Please guide me how can i run this script
>
>
> Thanks & Regards
> Jeetendra Ranjan
>
> ----- Original Message -----
> From: "Bruce Ferrell"
> To:
> Cc:
> 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
>>
>> http://blog.mysqltuner.com/
>>
>>
>>
>> Gavin Towey wrote:
>>> Hi,
>>>
>>> This script might help with some tuning suggestions, run it after you have some production traffic running against your database.
>>> https://launchpad.net/mysql-tuning-primer
>>>
>>> Also you should enable the slow query log, so you can capture queries to be optimized:
>>> http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
>>>
>>> http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
>>>
>>>
>>> Regards,
>>> Gavin Towey
>>>
>>>
>>> -----Original Message-----
>>> From: jeetendra.ranjan@sampatti.com [mailto:jeetendra.ranjan@sampatti.com]
>>> Sent: Wednesday, October 14, 2009 3:21 AM
>>> To: mysql@lists.mysql.com
>>> Subject: Req. suitable .cnf file for Server used by 2000 users daily
>>>
>>> Hi,
>>> 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
>>> ***********
>>> [mysqld]
>>> datadir=/var/lib/mysql
>>> socket=/var/lib/mysql/mysql.sock
>>> user=mysql
>>> # Default to using old password format for compatibility with mysql 3.x
>>> # clients (those using the mysqlclient10 compatibility package).
>>> old_passwords=1
>>> key_buffer = 16M
>>> key_buffer_size=4M
>>> sort_buffer_size=2M
>>> query_cache_size=64M
>>> log-bin
>>> log_queries_not_using_indexes=1
>>> long_query_time=1
>>> log_slow_queries=slowQry.log
>>> join_buffer_size=4M
>>> max_connections=150
>>> 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
>>> thread_stack=5M
>>> thread_cache_size=128M
>>> connect_timeout=30
>>> query_cache_limit=32M
>>> log-error
>>> # 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
>>> [mysqld_safe]
>>> log-error=/var/log/mysqld.log
>>> pid-file=/var/run/mysqld/mysqld.pid
>>> Thanks in advance
>>> Regards
>>> 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.
>>>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Req. suitable .cnf file for Server used by 2000 usersdaily

mysql is successfull in login with same user and password but when the same
user and password is given at mysqltuner end it always shows the same error
"[!!] Attempted to use login credentials, but they were invalid."

Thanks
Jeetendra Ranjan

____________________________
SynapseIndia
http://www.synapse.in
I.T. Outsourcing @ Peace of Mind


----- Original Message -----
From: "Bruce Ferrell"
To: "Jeetendra Ranjan"
Cc:
Sent: Tuesday, October 20, 2009 9:27 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily


> this error indicates either root doesn't have sufficient privilege or
> the password entered was bad. try running it this way:
>
> ./mysqltuner.pl --user root --pass
>
> Jeetendra Ranjan wrote:
>> Hi,
>>
>> 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
>> >> 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 mysqltuner.pl.
>>
>> Please guide me how can i run this script
>>
>>
>> Thanks & Regards
>> Jeetendra Ranjan
>>
>> ----- Original Message -----
>> From: "Bruce Ferrell"
>> To:
>> Cc:
>> 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
>>>
>>> http://blog.mysqltuner.com/
>>>
>>>
>>>
>>> Gavin Towey wrote:
>>>> Hi,
>>>>
>>>> This script might help with some tuning suggestions, run it after you
>>>> have some production traffic running against your database.
>>>> https://launchpad.net/mysql-tuning-primer
>>>>
>>>> Also you should enable the slow query log, so you can capture queries
>>>> to be optimized:
>>>> http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
>>>>
>>>> http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
>>>>
>>>>
>>>> Regards,
>>>> Gavin Towey
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: jeetendra.ranjan@sampatti.com
>>>> [mailto:jeetendra.ranjan@sampatti.com]
>>>> Sent: Wednesday, October 14, 2009 3:21 AM
>>>> To: mysql@lists.mysql.com
>>>> Subject: Req. suitable .cnf file for Server used by 2000 users daily
>>>>
>>>> Hi,
>>>> 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
>>>> ***********
>>>> [mysqld]
>>>> datadir=/var/lib/mysql
>>>> socket=/var/lib/mysql/mysql.sock
>>>> user=mysql
>>>> # Default to using old password format for compatibility with mysql 3.x
>>>> # clients (those using the mysqlclient10 compatibility package).
>>>> old_passwords=1
>>>> key_buffer = 16M
>>>> key_buffer_size=4M
>>>> sort_buffer_size=2M
>>>> query_cache_size=64M
>>>> log-bin
>>>> log_queries_not_using_indexes=1
>>>> long_query_time=1
>>>> log_slow_queries=slowQry.log
>>>> join_buffer_size=4M
>>>> max_connections=150
>>>> 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
>>>> thread_stack=5M
>>>> thread_cache_size=128M
>>>> connect_timeout=30
>>>> query_cache_limit=32M
>>>> log-error
>>>> # 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
>>>> [mysqld_safe]
>>>> log-error=/var/log/mysqld.log
>>>> pid-file=/var/run/mysqld/mysqld.pid
>>>> Thanks in advance
>>>> Regards
>>>> 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.
>>>>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org