185 reputation
27
bio website
location
age
visits member for 1 year
seen Apr 17 at 15:27
stats profile views 4

Mar
14
comment Can memcached improve performance for InnoDB in mem with a large innodb_buffer_pool_size?
Thanks Rolando! Again, uber massive super answer :)
Mar
7
comment mysqld_safe version different than mysqld?
Thanks Rolando! You rock! You are the God of mysql :) Will reinstall my battle worn mysql db :)
Mar
6
comment mysqld_safe version different than mysqld?
Great question golimar, I see two mysql related processes, one for mysqld_safe and another for mysqld. I updated the question as the reply did not fit here. Looks like this is the problem that I somehow have a mysql_safe running for some reason next to mysqld.
Mar
5
comment mysqld_safe version different than mysqld?
Yep, originally I had mysql 5.1, then later with yum I upgraded mysql on my centos to 5.5, but it seems this mysql.sock may have been missed? I am not finding much doucmentation unfortunately on this mysql.sock.
Mar
5
comment Error when dropping InnoDB database
Much appreciated Rolando! Fantastic reply. Wish there was a way to repair that db. Would have liked it to be the same name :)
Feb
26
comment Is there a graceful or safe restart for mysql like for apache httpd?
Fantastic reply, thanks!
May
30
comment mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
Thanks, yes this is a correct answer as well. I could only accept one though. +1d this too.
May
30
comment mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
Thanks, yep I did not delete them first. Just wanted to see how mysql behaves. After performing step 3 restarting worked.
May
29
comment mysql: deleted performance_schema, is it a problem?
Ok thanks, found how to recreate it here dev.mysql.com/doc/refman/5.6/en/…
May
29
comment mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
Thanks, I managed to find it. I think this will be easier. I should have also added initially that I increased the log file size as well to match the increase in the buffer pool (I did add this info now).