Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.