272 reputation
614
bio website
location
age
visits member for 2 years, 2 months
seen 2 days ago

Jun
26
comment How can I move a database from one server to another?
This works for both innodb and myisam? Also, mysql users are in datadir as well?
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).