URGENT - Hard code Mysql optimise then page optmisation

Discussion in 'MySQL' started by rajivv, Oct 14, 2010.

  1. #1
    Hi Site is very slow. ( can provide link via pm)

    Most important slow down is about 75% due to mysql and 25% your website layout etc.
    We checked and found out from my.cnf that the mysql-slow-query log file is 17mb when optimum is 1 mb or less first we will have to optimise mysql

    I will need to optimize mysql queries. then do following
    - optimize and lower number of mysql queries
    - compress JS and CSS scripts
    - grouping jscripts
    - compress PHP pages
    - remove unwanted scripts
    - gzip componenets
    - page loading badly ( probably solved with grouping jscripts)
    - varnish cache ( normal cache is done already)

    Let me know URGENT only experienced people offer
     
    rajivv, Oct 14, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    I would start going through the slow query log and fix the slow queries. After that, make sure you install APC. gzip often uses more server resources than not compressed files. It speeds things up for the user, but uses more server resources to do so.
     
    jestep, Oct 14, 2010 IP
  3. rajivv

    rajivv Peon

    Messages:
    335
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi Jestep I had sent you a pm did you receive
     
    rajivv, Oct 14, 2010 IP