Question : I am a beginner on MySQL Administration and performance problems. Now this is confusing me. I have a […]
Tag: mysql-5.5
Error 2003: Setting up MySQL Replication
Question : Trying to setup MySQL Replication using this guide here : http://wpguru.co.uk/2013/05/how-to-setup-mysql-masterslave-replication-with-existing-data/ I was able to do this on […]
Need some support on MySQL Query
Question : I have a query SELECT leads.id, sfav.id is_favorite FROM leads INNER JOIN teams tst ON tst.team_set_id = leads.team_set_id […]
Getting 0KB of size file while backup mysql database using mysql dump [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Unable to drop the table since its showing waiting for meta data lock
Question : We are trying to drop one table but it’s getting hanged, and when we see the ‘SHOW PROCESSLIST’ […]
Find any employees who earn less than the employee hired immediately after them [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Safely changing innodb_buffer_pool_size on MySQL replication master?
Question : We have a MySQL server which is a replication master. We need to change the innodb_buffer_pool_size and innodb_flush_method […]
Is it Possible to Recover Data from a BLACKHOLE table? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to belong […]
MySQL percona 5.6 to MySQL 5.5 replication
Question : Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it […]
Create user for alternate port
Question : I am running a private MySQL instance on WebFaction WebFaction is a shared host who provides both for […]