Slow database.
Asked Modified Viewed 2,837 times
asked
Hi
I am rebulding my website and I am using mysql version 5.0.58 for the database
when I log into my site i get the page displaying that I am not logged in though if I click a public visible page, the members pages are then displayed in the menu. After a while the frontpage then properly displays my log in status.
same with setting up new pages in the site links - they only show up their positiuon after a few min.
members are thinking they are not logged in, when they actually are.
slow database or wrong mysql version?
Best regards
Dave
I am rebulding my website and I am using mysql version 5.0.58 for the database
when I log into my site i get the page displaying that I am not logged in though if I click a public visible page, the members pages are then displayed in the menu. After a while the frontpage then properly displays my log in status.
same with setting up new pages in the site links - they only show up their positiuon after a few min.
members are thinking they are not logged in, when they actually are.
slow database or wrong mysql version?
Best regards
Dave
answered
i think slow database, ask your host for more details
krispy_b
krispy_b 10
Webmaster of THREE PHP Fusion driven community sites;
Lord of the Rings Online, Jumpgate Evolution Fansite, & Da Orcs Ead - Warhammer Online fansite
Lord of the Rings Online, Jumpgate Evolution Fansite, & Da Orcs Ead - Warhammer Online fansite
- Junior Member, joined since
- Contributed 41 posts on the community forums.
- Started 8 threads in the forums
Hmm - the MySql Version should be fine. I'm not even sure about a 'slow database' - if that was the case, your pages would take a long time to display , but you'd get the right state .. most the content you see needs database access, and in order (it can't call the selects and continue on until the database responds). I guess on a shared database if the 'updates/inserts' are a lower priority than reads, and there's a big queue.. your selects could come through, and the updates take a while..
answered
Looking at the database i see these messages highlighted in red
theres a few more...:|
Quote
Slow_queries 17 k The number of queries that have taken more than long_query_time seconds.
Quote
Handler_read_rnd 609 M The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Quote
Handler_read_rnd_next 2,564.97 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Quote
Qcache_lowmem_prunes 210 M The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache.
Quote
Created_tmp_disk_tables 2,836 k The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Quote
Select_full_join 2,849 k The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
theres a few more...:|
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
Do you have access to my.cnf? (configuration file of MySQL)
Do you have one large database or do you separate your databases to keep them small?. (one database per installation of a script)
Did you try repairing and optimizing in PHPmyAdmin?
Do you have one large database or do you separate your databases to keep them small?. (one database per installation of a script)
Did you try repairing and optimizing in PHPmyAdmin?
answered
Quote
Wanabo wrote:
Do you have access to my.cnf? (configuration file of MySQL)
Do you have one large database or do you separate your databases to keep them small?. (one database per installation of a script)
Did you try repairing and optimizing in PHPmyAdmin?
Nope
one large database
no access to phpmyadmin.
I got this message back from the hosting company -
Quote
I have checked this end and the forum software is not creating login sessions on the browser, this basically means that users cannot login. This issue is related to the forum software and as we do not provide support for third party applications something you will need to escalate to the software developers.
Dave
Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
Are you hosted on Servage by any chance?
Is there some optimizer script running on the server?
Try checking the 'remember me' checkbox.
Is there some optimizer script running on the server?
Try checking the 'remember me' checkbox.
answered
Servage? nope - namesco
answered
Quote
Dash wrote:
I got this message back from the hosting company -Quote
I have checked this end and the forum software is not creating login sessions on the browser, this basically means that users cannot login. This issue is related to the forum software and as we do not provide support for third party applications something you will need to escalate to the software developers.
Dave
PHPFusion uses cookies; no sessions whatsoever.
Category Forum
Content Administration - 8Labels
None yet
Statistics
- Views 0 views
- Posts 8 posts
- Votes 0 votes
- Topic users 5 members
5 participants
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
krispy_b 10
Webmaster of THREE PHP Fusion driven community sites;
Lord of the Rings Online, Jumpgate Evolution Fansite, & Da Orcs Ead - Warhammer Online fansite
Lord of the Rings Online, Jumpgate Evolution Fansite, & Da Orcs Ead - Warhammer Online fansite
- Junior Member, joined since
- Contributed 41 posts on the community forums.
- Started 8 threads in the forums
DubSev 10
......................................
let's go f***ing mental! la la la la...
let's go f***ing mental! la la la la...
- Senior Member, joined since
- Contributed 285 posts on the community forums.
- Started 5 threads in the forums
Dash 10
- Newbie, joined since
- Contributed 7 posts on the community forums.
- Started 2 threads in the forums
- Started this discussions
ytterx 10
YtterX
- Member, joined since
- Contributed 163 posts on the community forums.
- Started 1 thread in the forums
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions