Loading time

mrphantuan said:
Thus, I would suppose it's a domain resolving issue.
Click to expand...
Was reinstalled the vps in few times. I tried many ideas, and now tried with kloxo too. The results are the same. Possible, this is a network problem. After I make a click inside the website, is very fast,but if not viewed, (visited) for 3-4 hours, appear this problem. Must wait for 10-15 seconds until to appaer the site.
 
Last edited:
Each static site is fast, only the cms sites (like joomla) with mysql databases is slow for the first click.The mysql can be stopped itself,if not used?
 
Thanks for replay! Can you tell me how to use this script? Unfurtunatly, I dont no.
I alredy use my.cnf with following settings:

[mysqld]
local-infile=0
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=32M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

Thanks,
 
Your figures by themselves are useless for me. The script, the link I've given to which, would give some general recommendations, if the figures are bad in your case.

Code: 
cd /usr/local/src
wget http://mysqltuner.pl/mysqltuner.pl
chmod 700 mysqltuner.pl
./mysqltuner.pl --user da_admin --pass `cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2`
 
zEitEr said:
Your figures by themselves are useless for me. The script, the link I've given to which, would give some general recommendations, if the figures are bad in your case.

Code: 
cd /usr/local/src
wget http://mysqltuner.pl/mysqltuner.pl
chmod 700 mysqltuner.pl
./mysqltuner.pl --user da_admin --pass `cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2`
Click to expand...

Thanks, I tried
 
Unfurtunatly, I do not know yet what causing the problem. Now, with a cronjob (hourly) the site appaer normally, and fast, but I know this is not a solution.
 
As a supposition, on the very first hit something very heavy is getting into cache. While it is cached, your pages are quickly opened.

Just try to find, what is it.
 
I get the following message with mysqltuner:
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 5M (Tables: 299)
[!!] Total fragmented tables: 3

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 11s (34 q [3.091 qps], 14 conn, TX: 22K, RX: 2K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 112.0M global + 14.2M per thread (100 max threads)
[OK] Maximum possible memory usage: 1.5G (74% of installed RAM)
[OK] Slow queries: 0% (0/34)
[OK] Highest usage of available connections: 1% (1/100)
[OK] Key buffer size / total MyISAM indexes: 64.0M/3.1M
[!!] Query cache efficiency: 0.0% (0 cached / 17 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
[OK] Temporary tables created on disk: 0% (0 on disk / 9 total)
[OK] Thread cache hit rate: 92% (1 created / 14 connections)
[OK] Table cache hit rate: 97% (322 open / 329 opened)
[OK] Open file limit used: 7% (644/8K)
[OK] Table locks acquired immediately: 100% (19 immediate / 19 locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Variables to adjust:
query_cache_limit (> 2M, or use smaller result sets)
Click to expand...
I tried to modify the query_cache_limit and the query_cache_size with different value, but the message was the same.
Something is set incorrectly..
 
Yes, after every modification was restarted. But the query_cache_limit message was the same.
 
The query_cache_limit was changed for smaller, higher values, and the query_cache_size was changed too.The message of mysqltuner was the same, in other words, every time must be to increase.
 
The query cache is where it caches all queries for quicker execution, ours is
Code: 
query-cache-type=1
query_cache_size=32M
query_cache_limit=8M
Although it could go higher - it also depends on the ram the box has.
[OK] Query cache efficiency: 80.6% (26M cached / 32M selects)
Click to expand...
 
Last edited:
You must log in or register to reply here.
Back
Top