I have been developing with PHP and mySQL. The report I use (TCPDF) is running well and doesn't have any problems. But after I try to import a lot of data, the report is not run and is blank. I Can't generate to PDF and mySQL is very slow

1 Answer
1

Basically you should enable MySQL slow query logging (more info here). Also could you please post your my.cnf for review. Most probably you should tune MyISAM or InnoDB buffer size depending on what storage engine you use. You can use mysqlreport to get a comprehensive report on buffers usage/effectivenes and a bunch of other important parameters.