Results 1 to 2 of 2
Thread: Website Slow due to database
Sep 30, 2013, 04:55 #1
Website Slow due to database
If I have a database driven website with hundreds of pages, and someday if my users starts complaining that the website is very slow, how do I know the bottleneck?
Is there anyway in mysql to know what query is causing slowness?
Oct 5, 2013, 18:37 #2
- Join Date
- May 2007
- Poole, UK
- 88 Post(s)
- 0 Thread(s)
There is the slow query log: http://dev.mysql.com/doc/refman/5.5/...query-log.html
but afaik that doesn't work with prepared statements. Does each script open it's own database connection or are you passing a single database connection around all the scripts that need it?