rootservice / tuning-primer Goto Github PK

running this script or even the older version I get this messages

Using login values from ~/.my.cnf
INITIAL LOGIN ATTEMPT FAILED
Could not auto detect login info!
Found potential sockets: /var/lib/mysql/mysql.sock
Using: /var/lib/mysql/mysql.sock
Would you like to provide a different socket? [y/N] : n
Do you have your login handy? [y/N] : n
Please create a valid login to MySQL
Or, set correct values for 'user=' and 'password=' in ~/.my.cnf
Would you like me to create a ~/.my.cnf file for you? [y/N] : n

I have run this on different servers and it does not give me any of these errors or ask me for passwords

my.cnf is actually found in
/etc/my.cnf

and I have MYSQL 5.7

mysql -V
mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper

this my.cnf that the script will create will only be used by the script right ?

Hi, I have a problem when try to execute this file. I got this error when execute this file.

Unable to log into socket: /var/run/mysqld/mysqld.sock

Please help me whats wrong. Thank you.

Hello,
Is possible to use this brilliant tool with a remote host?
thanks

Hallo,

ich wollte das Script soeben ausführen und erhielt folgenden Fehler.

Error: Needed command "umask" not found in PATH!

OS: ‪Ubuntu 14.04.3 LTS‬

Thank you for your wonderful program!

I'm getting the following errors each time I run it:

KEY BUFFER
Runtime error (func=(main), adr=10): Divide by zero
(standard_in) 1: syntax error
Current MyISAM index space = 9 K
Current key_buffer_size = 0 bytes
Key cache miss rate is 1 : 1
Key buffer free ratio = %
tuning-primer.sh: line 795: [: -le: unary operator expected
tuning-primer.sh: line 799: [: -le: unary operator expected
tuning-primer.sh: line 803: [: -le: unary operator expected
Your key_buffer_size seems to be fine

I'm using Ubuntu 14.04 LTS, GNU bash, version 4.3.11(1)-release (x86_64-pc-linux-gnu), mysql Ver 14.14 Distrib 5.5.55, for debian-linux-gnu (x86_64) using readline 6.3.

Thank you again!

When executing this script i end up with this error:
./tuning-primer.sh: 1323: ./tuning-primer.sh: Illegal number: 050718

Tracing the source it's where the mysql version number is checked.
I've uncommented the check to make it work, but then other checks throughout the script fire the same error.
In my opinion this is due to numbers with leading zeros considered being octal instead of decimal. in octal you only have 0-7 making the 8 at the end of my version number "illegal"

This is a good script.
The old tuning-primer won't work accurately on latest mysql, i think.

Thank you for making this.

Neues Spiel, neues Glück ... neuer Fehler beim ausführen

Error: Needed command "ulimit" not found in PATH!

I copied the script to MySQL docker container but the script could not run there. After installing some dependency commands, namely bc net-tools it stopped with sysctl which could not be installed for docker container because it is a host shared resource.

Is there any way to run the script with Docker containers?

When i type this :

./tuning-primer.sh

No output in my SSH console.
Strange thing is i can type anything to the SSH console.
How to fix this?

Thank you.

./tuning-primer.sh: Zeile 4: Syntaxfehler beim unerwarteten Wort »newline«
./tuning-primer.sh: Zeile 4: `'

Diesen Fehler erhalte ich.