[atomic] Mysql 5.1.47
Re: [atomic] Mysql 5.1.47
1.5 Check mysqld.log for errors and update my.conf accordingly
edit: Might also be considered 0.5 if you know what to change.
edit: Might also be considered 0.5 if you know what to change.
Re: [atomic] Mysql 5.1.47
Well i just looked at my my.cnf and removed the skip-bdb line and from what i've gathered the rest of it looks fine from my limited knowledge.biggles wrote:1.5 Check mysqld.log for errors and update my.conf accordingly
edit: Might also be considered 0.5 if you know what to change.
Code: Select all
[mysqld]
set-variable=local-infile=0
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
wait_timeout=3600
max_user_connections=400
max_connections=400
query_cache_size=128M
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=5
thread_cache_size=6
thread_concurrency=4
key_buffer_size=128M
join_buffer_size=1M
table_cache=18000
tmp_table_size=128M
max_heap_table_size=128M
innodb_buffer_pool_size=16M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
James Nascimento
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Re: [atomic] Mysql 5.1.47
I think step three and four need to not have the admin password in the command, and it will ask for the password...at least that works on my server...
e.g.
# mysqlcheck -u admin -p --auto-repair --check --optimize --all-databases
# password:
e.g.
# mysqlcheck -u admin -p --auto-repair --check --optimize --all-databases
# password:
Re: [atomic] Mysql 5.1.47
You can either do it as
Note that the lack of a space in the command is NOT a typo. The drawback here is that anyone can go back in your bash history and get in this way.
Or you can do it as
and mysql will prompt you for your password. This syntax extends to all mysql CLI tools (mysql, mysqldump, mysql_upgrade, etc)
Code: Select all
mysql -u admin -ppassword
Or you can do it as
Code: Select all
mysql -u admin -p
I don't think this is necessary. mysql_upgrade will repair tables as needed.mysqlcheck -u <admin> -p <password> --auto-repair --check --optimize --all-databases
"Its not a mac. I run linux... I'm actually cool." - scott
Re: [atomic] Mysql 5.1.47
regarding the my.cnf...isn't the
quite extreme? I have mine at 2-6mb, and the mysqltuner tweaks me up or down in that range consistently. I don' knw, maybe your require all that.tmp_table_size=128M
max_heap_table_size=128M
Re: [atomic] Mysql 5.1.47
mneese77 wrote:regarding the my.cnf...isn't thequite extreme? I have mine at 2-6mb, and the mysqltuner tweaks me up or down in that range consistently. I don' knw, maybe your require all that.tmp_table_size=128M
max_heap_table_size=128M
That's what i always thought too but for some reason when the server was setup and the amount of DB's on it with cleints one of our former server admins ran mysqltuner and used something else to come up with that. But since it was'nbt broke or seemed to cause issues that i could see i left it alone.
James Nascimento
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Re: [atomic] Mysql 5.1.47
Just tor keep things updated...
the upgrade error that I was repeatedly getting was
Thanks everyone for chipping in with all this important information....
Love this forum!
the upgrade error that I was repeatedly getting was
only permissions concerns...the files that the my.cnf pointed to for error logs required mysql as owner, and permissions set to 644. Now it works for the upgrade with NO errors....RROR 29 (HY000) at line 334: File '/var/log/mysql-slow.log' not found (Errcode: 13)
Thanks everyone for chipping in with all this important information....
Love this forum!
Re: [atomic] Mysql 5.1.47
Easy way to find outmneese77 wrote:regarding the my.cnf...isn't thequite extreme? I have mine at 2-6mb, and the mysqltuner tweaks me up or down in that range consistently. I don' knw, maybe your require all that.tmp_table_size=128M
max_heap_table_size=128M
Code: Select all
#yum install mysqltuner
#mysqltuner
"Its not a mac. I run linux... I'm actually cool." - scott
Re: [atomic] Mysql 5.1.47
I've been running mysqltuner for a couple years on our boxes and with those settings it never complained about those high settings. i did change my.cnf to the ones you use and seems to made no difference in the report after running mysql tuner.Highland wrote:Easy way to find outmneese77 wrote:regarding the my.cnf...isn't thequite extreme? I have mine at 2-6mb, and the mysqltuner tweaks me up or down in that range consistently. I don' knw, maybe your require all that.tmp_table_size=128M
max_heap_table_size=128MEnter admin and your Plesk password and let it run. It will recommend changes to your my.cnfCode: Select all
#yum install mysqltuner #mysqltuner
On a side note, Thanks to those that answered my questions about the upgrade. I did it this morning and had no issues and all seems to be working well.
James Nascimento
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Chief Information Officer
East Commerce Solutions, Inc.
22 Morris Lane
East Providence, RI 02914
Ph. 800-527-5395 x263
Fax. 888-999-5891
Re: [atomic] Mysql 5.1.47
mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --check --optimize --all-databases
This is the best if you are under PLESK.
This is the best if you are under PLESK.
Best regards,
Valics Lehel
Power Toys for PLESK
HOW TO: Setup a new box with PLESK
PLESK Crash Recovery Service
Valics Lehel
Power Toys for PLESK
HOW TO: Setup a new box with PLESK
PLESK Crash Recovery Service