SPEED Up MySQL? is there a way?

. watching the website load off of a firewall... I see the following

php and mysql loads first before the website even begins to laod

it goes up to 100,000 and more before it loads...

this is seriously taking a long time.. any way to speed this process up (a lot perferably)

as it takes about 15 or more seconds to load my website on a lan. little lone users on the net.

any help will be greatly appreciated.

Sounds like hosting problems

I found this on the net.. don't know if it really makes a difference

log_slow_queries  = /var/log/mysql/mysql-slow.log
long_query_time  = 1
log-queries-not-using-indexe

seems to take just as long to load the website

opps cut and paste problem.. here is the real code insert into my.ini on mysql 4.1

log_slow_queries  = d:/website/indigoampp/mysqlLOG/mysql-slow.log
long_query_time  = 1
log-queries-not-using-indexes

hmm.. here's another one.. I'm still taking around 15 to 20 seconds to load my website on a 5meg upstream.. kinda slow..

this one does not work well with plugins.. maybe someone can edit it so it does work 100%

----------------------------------------------

# 1 YEAR

<FilesMatch "\.(ico|pdf|flv)$">

Header set Cache-Control "max-age=29030400, public"

</FilesMatch>

# 1 WEEK

<FilesMatch "\.(jpg|jpeg|png|gif|swf)$">

Header set Cache-Control "max-age=604800, public"

</FilesMatch>

# 2 DAYS

<FilesMatch "\.(xml|txt|css|js)$">

Header set Cache-Control "max-age=172800, proxy-revalidate"

</FilesMatch>

# 1 MIN

<FilesMatch "\.(html|htm|php)$">

Header set Cache-Control "max-age=60, private, proxy-revalidate"

</FilesMatch>

----------------------------------

had some strange glitches with polls/a you tube mod and sometimes online statuses..

Check out this link ... click here ... if you have a dedicated server for your D7 setup,

or ... click on this link ... if your D7 is shared with other users on the same server ....

Another interesting link is ... this one here ... for some additional input.

Hope that helps some.

I took advantage of the mod_deflate in Apache as recommended in the one post and my site now loads 8.4 X's faster. It's amazing.

Regarding MySQL, the first thing I would check is the cache settings. They can make a huge difference!

-LSB

I made an inappropriate stink about this a while ago and learned some very valuable lessons with MySQL.  Lesson 1: Check your sql setup, if your using default likely that is inadequate and you will need to tweek the amount of ram given to your executions and cache.  Lesson 2: check for indexes and add them where appropriate, this will help with execution time.  Lesson 3: Turn on slow logging to see what is causing you delay, once you find that repeat lesson 1 and 2 to fix the problem.  Boonex does a good job with most sql caching, and once your sql is tweeked right, it will run fine.

If you are in a shared environment, you likely are only able to use a small percent of the sql resources and will therefore have a slow sql response.  But the most likely cause of a slow site load is not the sql but the amount of info sent per page.  Look at the index page, 2000+ lines of code and 150+ pictures sent.  Turn on deflate or gzip mods, those alone will significantly increase your site's response.

does anyone have some lines of mysql.ini code they can share to speed this up...

I've been watching the firewall stats.. everytime you access the website mysql has a BIRD!!!!

it loads like 300,000 and then finally the website starts loading..

code for the mysql config file would be very much appreciated.

no matter what I try.. the mysql keeps loading over 300,000 and the website does not load until it is finished doing it's mysql thing.

Here is what I have tried off of web searches.. and it does nothing to stop the mysql loading (slow load) before the webpage actually starts sending to the browser.

-------------------------------------

[mysqld]
; default values
key_buffer_size = 80M
read_buffer_size = 80M
;max_c alt= 500
sort_buffer_size = 80M

;log_slow_queries  = d:/website/indigoampp/mysqlLOG/mysql-slow.log
;long_query_time  = 1
;log-queries-not-using-indexes

;query_alloc_block_size =30M
;query_cache_min_res_unit =1
;query_cache_wlock_invalidate
;query_prealloc_size =30M
;Qcache_free_blocks = 30M
;Qcache_free_memory =30M

set-variable=max_c alt=500
set-variable=wait_timeout=10
max_c alt= 100

query_cache_type=1
query_cache_limit=1M
query_cache_size = 32M
-------------------------------

can someone straighten out my code mess and try to give me something that may actually work?

it takes about 1 minute (no lie I timed it with a clock) for firefox and internet explorer to load the website...

This is really bad considering I got 5meg upstream.

Any ideas?

3 sec. here :D

Try Google Chrome, I hear its like getting a new computer.

nevermind rentacoder person is vamping my apache/mysql/php/perl on the 21st....

says needs new deticated modules etc. garentees speed.

unless someone is nice enough to post working config files on this site it's my only option.

cheerz

hmm.. strange. I managed to speed it up to 25 seconds from 1 minute by stripping cache code and adding the following

mysql.ini (only lines in it now)

max_c alt= 500

query_cache_typ = 2
query_cache_size = 40M

httpd.config

--------------

<IfModule mod_mem_cache.c>
        CacheEnable mem /
        MCacheSize 30M
        MCacheMaxObjectCount 1000
        MCacheMinObjectSize 1
        MCacheMaxObjectSize 20480
</IfModule>

hope this helps someone who has problems with speed on their own server..

anyone else come up with a way to speed it up even more.. like 3 second loads that prolaznik brags about?

heheheeh

after a bit of web seaching i found the following for httpd.config

it really speed up the process (in conjunction with the other posts on this topic) on my main server.. less then 10 second..

BUT initial load time is still over 6 seconds.. can anyone help out a bit.. anyways here's the code snip

----------------------------

LoadModule expires_module modules/mod_expires.so

############WEB HELP ADDITION##################
#ThreadStackSize = 30M
#ServerLimit = 1000
#MaxClients = 1000
#SendBufferSize = 30M

<IfModule mod_mem_cache.c>
CacheEnable mem /
MCacheSize 30M
MCacheMaxObjectCount 1000
MCacheMinObjectSize 1
MCacheMaxObjectSize 20480
</IfModule>

# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

#<IfModule mod_expires.c>
#   Include conf/expires.conf
#</IfModule>

ExpiresActive On
ExpiresDefault "access 1 month"
ExpiresByType image/png "access 3 months"
ExpiresByType text/php "access 3 months"
ExpiresByType text/css "access 3 months"

<Directory "d:/website/indigoampp/htdocs">
AllowOverride Indexes
ExpiresDefault "access 6 months"
</Directory>
#resByType text/html "access 1 week"
#resByType text/php "access 1 week"


##################################

i may have it all wrong buit at least it works really fast on the server.. about 8 seconds instead of 25 seconds... like i said initial load time is est 8 seconds or longer.. have to find a way to fix that... (and previously stated in this topic 3 seconds!?!?!?! ok i'm still at work) someone help out around here ok? I know a lot of boonex users would LOVE to know how to configure a server!!!

ooppss. made a mistake in my last code snip..

got to remember there are html and js files.. got it down to 8 seconds when the browser finally hits httpd.exe

can anyone further cut the time?

--------------------------

LoadModule expires_module modules/mod_expires.so

############WEB HELP ADDITION##################
#ThreadStackSize = 30M
#ServerLimit = 1000
#MaxClients = 1000
#SendBufferSize = 30M

<IfModule mod_mem_cache.c>
CacheEnable mem /
MCacheSize 30M
MCacheMaxObjectCount 1000
MCacheMinObjectSize 1
MCacheMaxObjectSize 20480
</IfModule>

# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

#<IfModule mod_expires.c>
#   Include conf/expires.conf
#</IfModule>

ExpiresActive On
ExpiresDefault "access 1 month"
ExpiresByType image/png "access 3 months"
ExpiresByType text/php "access 3 months"
ExpiresByType text/css "access 3 months"
ExpiresByType text/js "access 3 months"
ExpiresByType text/html "access 3 months"

<Directory "d:/website/indigoampp/htdocs">
AllowOverride Indexes
ExpiresDefault "access 6 months"
</Directory>
#resByType text/html "access 1 week"
#resByType text/php "access 1 week"


##################################
any help on reducing the time on all aspects of mysql / php / apache would be not only appreciated by me, but all the other server users as well.. please reply if you can help all of us... thank