my web site is very slow
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    what is the problem?
    how to optimize the database?
    my ram and cpu is ok.

  • 16 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    please ask google: mysql tuning
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    my database size is 120M is problem this?
    my server is centos 6.2 minimal with mysql 5
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    but what is a problem? More details here please
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    my web site is very very slow i mack optimize and repair  the database but the problem is the same
    my site is
    alithia.com.cy
    do newscoop have any logs?
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    actually it's enough fast to me.
    I see some disadvantages in page design:
    1. too many css files (10)
    2. too many js files (26)
    3. too many images (127)
    4. too many iframes (8)
    In addition gzip is not enabled on apache server.

    yslow-results.png
    465 x 298 - 20K
  • Vote Up0Vote Down Petr JasekPetr Jasek
    Posts: 144Member
    do you have php opcode cache installed (like apc) ?
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    yes i have apc

    this is my code of gzip
    LoadModule deflate_module modules/mod_deflate.so
    <IfModule mod_deflate.c>
    SetOutputFilter DEFLATE
    SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.(?:exe|t?gz|zip|bz2|sit|rar)$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.pdf$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.avi$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.mov$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.mp3$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.mp4$ no-gzip dont-vary
    SetEnvIfNoCase Request_URI \.rm$ no-gzip dont-vary

    AddOutputFilterByType DEFLATE text/plain
    AddOutputFilterByType DEFLATE text/xml
    AddOutputFilterByType DEFLATE application/xhtml+xml
    AddOutputFilterByType DEFLATE text/css
    AddOutputFilterByType DEFLATE application/xml
    AddOutputFilterByType DEFLATE image/svg+xml
    AddOutputFilterByType DEFLATE application/rss+xml
    AddOutputFilterByType DEFLATE application/atom_xml
    AddOutputFilterByType DEFLATE application/x-javascript
    AddOutputFilterByType DEFLATE application/x-httpd-php
    AddOutputFilterByType DEFLATE application/x-httpd-fastphp
    AddOutputFilterByType DEFLATE application/x-httpd-eruby
    AddOutputFilterByType DEFLATE text/html

    DeflateCompressionLevel 9

    BrowserMatch ^Mozilla/4 gzip-only-text/html
    BrowserMatch ^Mozilla/4\.0[678] no-gzip
    BrowserMatch \bMSIE !no-gzip !gzip-only-text/html

    DeflateFilterNote Input instream
    DeflateFilterNote Output outstream
    DeflateFilterNote Ratio ratio

    LogFormat '"%r" %{outstream}n/%{instream}n (%{ratio}n%%)' deflate

    </IfModule>
     and is very slow again
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    sorry now i put this code
    AddOutputFilterByType DEFLATE text/html text/plain text/xml

    <Location />
    # Insert filter
    SetOutputFilter DEFLATE

    # Netscape 4.x has some problems...
    BrowserMatch ^Mozilla/4 gzip-only-text/html

    # Netscape 4.06-4.08 have some more problems
    BrowserMatch ^Mozilla/4\.0[678] no-gzip

    # MSIE masquerades as Netscape, but it is fine
    # BrowserMatch \bMSIE !no-gzip !gzip-only-text/html

    # NOTE: Due to a bug in mod_setenvif up to Apache 2.0.48
    # the above regex won't work. You can use the following
    # workaround to get the desired effect:
    BrowserMatch \bMSI[E] !no-gzip !gzip-only-text/html

    # Don't compress images
    SetEnvIfNoCase Request_URI \
    \.(?:gif|jpe?g|png)$ no-gzip dont-vary

    # Make sure proxies don't deliver the wrong content
    Header append Vary User-Agent env=!dont-vary

    SetInputFilter DEFLATE
    </Location>
    is lite better but is very slow
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    George,

    you can ask for professional service here: http://www.sourcefabric.com/en/services/whatwedo/


    Post edited by Andrey Podshivalov at 2012-03-01 05:31:57
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    this is very nice
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    if i enable and x-cache   is work faster?

  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    xcache is analog of apc
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    my database is 120 Mb this is a problem of fast my site?
    i optimize but i have the same problem
  • Vote Up0Vote Down Mike FustoMike Fusto
    Posts: 3Member
    may be the fault of hosting?
    Post edited by Mike Fusto at 2012-03-02 05:25:59
    dobra folia stretch | duże kartony
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
     i make the web server on Centos 6 minimal and mysql 5.1.61
  • Vote Up0Vote Down George HadjichristofiGeorge Hadjichristofi
    Posts: 85Member
    hello i update my mysql cache and i install Google mod_pagespeed and now is more better
Add a Comment