New answers tagged tools
There's a lot of choices out there: Percona Monitoring plugins for Zabbix, Cacti, Nagios Percona Monitoring and Management Monyog Severalnines Clustercontrol Equally capable but not on-premise (afaik) is Vividcortex.
Get MonYog through MariaDB. https://www.webyog.com/product/monyog Note: anything that works with MySQL, MariaDB, or Percona, will probably work well with the others. I looked at lots of tools, but came away thinking that most graphs were measuring either stuff that never changes. My favorite tool metric is the number of slowlog entries. If that goes up, ...
Why use a UI tool when the query is this short? INSERT INTO db1.users (id, name, phone) SELECT id, first_name, mobile FROM db2.users; Caveats: You probably should not copy id if it is AUTO_INCREMENT. I was guessing which direction you wanted to copy.
sp_AskBrent was renamed to sp_BlitzFirst. https://www.brentozar.com/archive/2016/06/first-responder-kit-updated-sp_askbrent-now-sp_blitzfirst/
As previously suggested, this problem is far more tractable through programming than through SQL (if at all). Not that SQL is not programming, but it's not procedural, it's declarative. The problem with that is that this means that you have to have a good idea of the data's underlying structure in order for SQL to work. Posrgresql (the only one of the F/...
Top 50 recent answers are included