Performance Impact between databases I have a database with a fairly large table. We want to run grafana queries against this data, and are thinking about dumping the data each day into a separate table/database to minimize performance impact on our main DB.  Ideally, we would have some daily replication dump data as such:

database1.table --&gt; database2.table_hist


So my question is, would it be better to create a new schema (on the same server) in order to further segregate the datasets? Would we see performance impact on database1 if we're running long queries against database2.table_hist?
The same MySQL process will use the same CPU cores to process and move data between the same disk and the same memory, whether your reporting table is in the same MySQL database (schema) or in a different schema. Even if you have a separate MySQL instance on that machine, it will still compete with its sibling for hardware resources. For proper isolation you need a separate server.

A typical scenario includes a master-slave replicated pair, with reporting workload hitting the slave.