Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

I have been optimizing my tables and not changed anything.

Can anyone help me?

share|improve this question

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.