Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
1 6
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
Jul
22
awarded  Notable Question
Apr
10
awarded  Popular Question
Jun
18
accepted MySQL query, 2 similar servers, 2 minute difference in execution times
Jun
18
answered MySQL query, 2 similar servers, 2 minute difference in execution times
Jun
6
awarded  Supporter
Jun
6
accepted mysql my.cnf ignored
Jun
6
revised mysql my.cnf ignored
Mysql still running after mysql stop seems successful
Jun
1
comment mysql my.cnf ignored
After doing a service mysql stop.. mysql was still running with no problems.. that seems to be an issue to me? what would cause that
Jun
1
revised mysql my.cnf ignored
print-defaults message includes my.cnf changes!
Jun
1
comment mysql my.cnf ignored
I added the file, no change to my buffer pool :S
Jun
1
comment mysql my.cnf ignored
I have a file named mysqld_safe_syslog.cnf containing 2 lines :[mysqld_safe] syslog
Jun
1
awarded  Scholar
Jun
1
awarded  Commentator
Jun
1
comment MySQL query, 2 similar servers, 2 minute difference in execution times
Ye, got all that checked opened a question here : serverfault.com/questions/394651/mysql-my-cnf-ignored but still unsure of what is happening :S
Jun
1
comment mysql my.cnf ignored
Ok I have now run this.. and still no joy, the changes in my.cnf are still not being updated :S After running the starting command I got a resonable pause before I was able to type again, but no message saying server started etc..?
Jun
1
comment MySQL query, 2 similar servers, 2 minute difference in execution times
Not sure if its related, but I'm having trouble getting my.cnf changes recognised.. I add the change to /etc/mysql/my.cnf do a sudo service mysql restart.. and no change happens to show variables in mysql cl. The same my.cnf file (copied just now) works fine and updates the vars on dev...
Jun
1
comment mysql my.cnf ignored
mysql 27769 6366 1.4 402136 59568 ? Sl Mar15 24326837:56 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --pid-file=/var/lib/mysql/[url].pid --socket=/var/run/mysqld/mysqld.sock --port=[port] This is the only line not also present on the dev machine.
Jun
1
comment mysql my.cnf ignored
Nope, none of the phrases you listed are present on anything returned.
Jun
1
comment mysql my.cnf ignored
Sorry could you explain that further, mysql --help results in >Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
Jun
1
revised mysql my.cnf ignored
added 105 characters in body