how to modify the way powerdns reads from mysql DB ?

the mysql log shows that it reads certain columns , rows, content et cetera.

how do i change the order of reading or manipulate with it ?

PowerDNS has its own schema it expects to see in the database - you can extend the schema if you wish as long as the expected tables/columns remain as a subset. Or, if needed, you can modify each of the individual queries it uses during operation through the *-query settings in your pdns.conf file, as long as the modified queries return the same set of information for the stage of processing in which the query is needed.

I'd suggest reviewing https://doc.powerdns.com/md/authoritati ... c-mypgsql/ for more detailed information.

-- David