Previous Thread
Next Thread
Print Thread
Hop To
Slow Queries #251113 12/05/2012 3:55 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
My forums are still running very slowly so I'm trying a variety of things, including logging slow queries. I occasionally get one like this -

# Time: 121205 3:39:37
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 11.296875 Lock_time: 0.031250 Rows_sent: 200 Rows_examined: 2526
use wine;
SET timestamp=1354696777;
SELECT p.POST_ID
FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID,
ubbt_TOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','3','4','35','36','9','34','37','39','38','40')
AND p.TOPIC_ID = t.TOPIC_ID
AND MATCH (p.POST_SUBJECT,p.POST_DEFAULT_BODY) AGAINST ('eifrxxjofjousp, <a href=\"http://johannagonzalez.com/\">Online Casino</a>, AdhYOwh, Online casino cribbage, fiFOEJN, http://johannagonzalez.com/ Online casino us slot invaders moolah, DwGkfCT, <a href=\"http://vigrx2k.com/\">Does vigrx really work</a>, eTRCYvn, Vigrx suit, lVAymLd, http://vigrx2k.com/ Vigrx vs extagen, EzoPDHu, <a href=\"http://cnbook.org/\">Buy cheap viagra online uk</a>, oHZxUMG, Viagra alternative, KeiQGND, http://cnbook.org/ Viagra suppliers in the uk, pjUqTMs, <a href=\"http://searchuktravel.com/\">HCG</a>, GavChGj, Mushrooms on hcg diet, LEYaNFp, http://searchuktravel.com/ Hcg diet recipes, LxnKRRW, <a href=\"http://johnniesbaseball.com/\">Free online casino slot games</a>, dPpSxTV, Up bonus online casino, KdCltEk, http://johnniesbaseball.com/ Virtual online casino, YMnYNxO, <a href=\"http://capsiplextreatment.com/\">Capsiplex</a>, KPUsBOs, Trackback lascia un commento capsiplex in usa, fLyKZyB, http://capsiplextreatment.com/ Capsiplex, HGTWReR.' IN BOOLEAN MODE)

ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200;

I imagine this is spam I don't want to deal with. I thought I remembered a way to have only logged in users able to do searches. Was that my imagination or is that a real feature? I run a spammer-blocker add-on so I imagine that would help a fair amount.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251114 12/05/2012 4:07 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
OK I found it, just took a while. So I will turn that off in my forums, that might help a bit.

At this point I have upgraded MySQL to the latest, upgraded PHP to the latest in its line, added FastCGI, and converted one of my forums to InnoDB (all except the posts table which wouldn't convert). It seems to be running without any errors.

I'll test for a day and then tomorrow night I'll convert the others to InnoDB. Somehow I need to get these sped up a bit.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251116 12/05/2012 10:51 AM
Joined: Dec 2003
Posts: 5,998
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,998
the search has two permissions under:
Control Panel ยป Site Permissions
Oh, Nevermind you found it I guess


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Slow Queries [Re: BellaOnline] #251281 12/13/2012 9:19 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
My changes do seem to be helping. The server used to be flat-line pegged at 100% and now it at least has breaks in the pegging. So progress is being made. I have a dedicated server so it's all mine. On the downside it only has 2g of memory and that's its max. I would have to pay more to go to a new server and I can't afford that right now. So I am trying to squeeze the most I can out of this one.

I'm going to upgrade to the latest version of UBB. Then I'm going to upgrade from the PHP 5.3 line to the PHP 5.4 line and see if that helps.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251288 12/13/2012 10:24 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
InnoDB won't help, unless the software takes advantage of it. We aren't doing 'transactions', which InnoDB does MUCH better at. Also record level locking versus table level.

UBB and most forum software is heavily read intensive and MyISAM does that well..

Where it falls down is in the queries you mentioned above... the new 7.5.7 limits the query length to 50 characters ( reasonable value ) and discards crap like that one query was doing..

That alone will help huge...

Also, there are really two terribly inefficient queries that kill mysql.. They happen when there are very long topics ( lots of pages, so ubb uses an offset, which sucks ) and very large forum ( also lots of pagination )...

So just cleaning up showflat and postlist would take a HUGE load off any loaded server.

All in all, however.. RAM IS KING!! there is now way around that... to really run properly and with speed.. you should have enough ram to entirely cache your databases AND INDEXES into memory... whenever you have to hit the hard drive for any reason, you take two orders of magnitude hit in speed, if not more...

I never run with less than 8Gigs of ram ( a linux dedi with 8gb ram is $149/month )....

So favor RAM over CPU, if you are server shopping in the future and get as much RAM as possible... RAM RAM RAM laugh

wink

Re: Slow Queries [Re: BellaOnline] #251290 12/13/2012 10:27 PM
Joined: Jun 2004
Posts: 207
cascadeclimbers Offline
enthusiast
Offline
enthusiast
Joined: Jun 2004
Posts: 207
SD, how do you load MyISAM tables into memory? I thought you can only do that with innoDB?


Won't you take me to Funkytown?
Re: Slow Queries [Re: BellaOnline] #251296 12/13/2012 11:22 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
it's not that you need to declare a whole bunch of 'HEAP' type tables, but as the MYD files are accessed, they are actually ( where available ) sucked into RAM and cached automagically...

linux does this for you...

now, what i do is at startup, do a command like "cp /path/to/all/my/*.MYD /dev/null"

that gets the ball rolling immediately...

with 32gigs of ram, i'm off and running then with the OS handling all the writebacks on change smile

if you every look at your server ram usage, after it has been running for a long time, you will notice that regardless of how much RAM you have, there seems to be a very high percentage 'in use'... i reality, the OS is just hedging it's bets and using RAM wherever possible...

right now, for example my 32 GIG ram server is 'using' 29Gigs, but not really, if you get my drift...

normally i would NEVER get a 32 gig ram server, but i got 'lucky' in that there was a bad MOBO that caused a lot of pain and i was repaid with 4 sticks of 8Gigs to 'make me go away and stop complaining' laugh

bottom line, regardless of myisam or innodb.... RAM RAM RAM!!

get all you can and more.. it's cheap.... and it beats banging the HDD wink

Re: Slow Queries [Re: BellaOnline] #251298 12/13/2012 11:30 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
Link to some MySQL geekiness that i mentioned in the above post

they talk about what i described and even have some stats and 'wow, that really works!!' kinda comments too wink

i've been doing this on all my servers to quickly 'warm' up the Mysql tables on startup... makes life easier with a lotta RAM RAM RAM tho!

if you are low on ram, then disregard what i said in this and the last post laugh

you'll have to better use indexes and really have to TUNE my.cnf more smile

Re: Slow Queries [Re: BellaOnline] #251376 12/14/2012 7:48 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
I'm paying $99/month and with finances right now I can't afford to upgrade. So I need to tune this to run as cleanly as possible with what I have, which is 2g RAM.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251378 12/14/2012 7:57 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
ubbt_POSTS table... keep it as lean ( prune old content if possible )...

or implement a custom solution, like creating a ubbt_POSTS_ARCHIVE table, where you send older posts to...

then a small modification to ubbt_TOPICS to add 1 field 'IS_ARCHIVE'....

that way the ubbt_POSTS table only has current posts and runs lickity split...

i've done this for a couple large forums and it works quite well...

all in all.... it can be done.... but if you can double 2GB to 4GB of RAM, you buy yourself a quick solution laugh

Re: Slow Queries [Re: BellaOnline] #251379 12/14/2012 8:20 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
I'd love to see archiving as an option of the stock software; I've seen people leave with huge forums just because of this :/.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Slow Queries [Re: BellaOnline] #251431 12/16/2012 5:33 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
I'll consider the archiving option.

I'm happy to report that I just upgraded tonight to PHP 5.4.9. So I'm now on the latest version of MySQL, the latest version of PHP, and am running FastCGI. I've upgraded to the latest version of UBB. I converted the tables to INNODB. With all those changes, my processor, which used to be pegged solidly at 100%, is now floating at around 50%. Yes it still pegs occasionally but that's fine. The improvement is substantial.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251443 12/16/2012 2:18 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
So everything is running fine on the latest php


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Slow Queries [Re: BellaOnline] #251453 12/17/2012 1:35 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
Yes. I am now on PHP 5.4.9 on both of my servers and the forums haven't had any issues with it.

On the down side, while normal forum operations are now much faster, and the server isn't pegged constantly, making posts is still excruciatingly slow. It can literally take 90 seconds for a forum post to go in, and often the operation times out. Meaning I'd have to extend the wait time past 90 seconds - and how many people are going to wait 2+ minutes for a forum post to go in?

There's got to be some way to speed up the forum posts.

The BellaOnline forum has 54,000 members, 717,000 posts, and the database is 1.12 gig. When I upgraded to the latest version of MySQL I imported the database fresh, so it's nice and clean in terms of being laid onto the hard drive. It did speed up a bit when I went to InnoDB but clearly not enough.

Other operations are fast. It's just that post insert that drags on completely.

Thoughts? Is it all about that text index?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251454 12/17/2012 1:42 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
I think you're at the point of needing more ram to speed things up, perhaps dropping the indexes as sd said will help as well...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Slow Queries [Re: BellaOnline] #251455 12/17/2012 1:48 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
OK I looked in my slow query log and the three slow queries around the times of my timing-out-posts seem to have nothing to do with what I'm doing. They are all looking at the "General Parakeet Chat" area (forum 5) - which I'm not in. And two of them are ordering by username, which is confusing. If someone was looking at the forum area in general it would list items by date. What query lists by user name, for a given forum area?

So I'm not getting any sense, from the slow forum query log, what is slowing down my posts. I'll note the post *does* get in even though it times out. So it's something hanging it after the post goes in. Any ideas how to troubleshoot? Maybe something is simply locking up after the post is done?

Here are the three queries going on during my testing time.

# Time: 121217 1:28:32
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 15.328125 Lock_time: 0.000000 Rows_sent: 11 Rows_examined: 93778
SET timestamp=1355725712;
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY,t3.USER_GROUP_IMAGES
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_ID
where t1.FORUM_ID = 5
and t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t2.USER_DISPLAY_NAME asc
LIMIT 9860, 11;
# Time: 121217 1:40:56
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 10.859375 Lock_time: 0.000000 Rows_sent: 11 Rows_examined: 53307
SET timestamp=1355726456;
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY,t3.USER_GROUP_IMAGES
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_ID
where t1.FORUM_ID = 5
and t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_SUBJECT asc
LIMIT 9120, 11;
# Time: 121217 1:41:06
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 14.562500 Lock_time: 0.000000 Rows_sent: 11 Rows_examined: 93058
SET timestamp=1355726466;
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY,t3.USER_GROUP_IMAGES
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_ID
where t1.FORUM_ID = 5
and t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t2.USER_DISPLAY_NAME desc
LIMIT 9140, 11;


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251459 12/17/2012 2:38 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
Here's a sample progression.

I visit a forum area on my LisaShea forums. With the debug info turned on, I see it draws in under a second. So super quick.

I then make a new post there. Looking at the server itself, it is only 33% in use. So it's not pegged at all.

90 seconds later, the post times out.

I then went to the forum main page. I get:

Generated in 93.087 seconds in which 92.896 seconds were spent on a total of 26 queries. Zlib compression disabled.

So it's as if whatever the post was doing then affected the whole forum.

I now look at the main forum page fresh. Now I get:

Generated in 0.127 seconds in which 0.013 seconds were spent on a total of 26 queries. Zlib compression disabled.

So I'm back to a quick load.

So something about the post operation is causing a serious hit to the forum.

OK this time I ran it while watching in MySQL Workbench.

When the post starts up, I get an entry for "update ubbt_TOPICS" - and it goes to a status of query end.

And it sits there.

other processes around it come and go, and it just sits and sits. It doesn't have a time. Just a zero.

Then I get a select post ID beneath it, and that one does increment a time. It got up to 110 in this screenshot.

And eventually my actual submission page times out, and then they all go away.

[Linked Image]

So what is going on with the "query end" status?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251460 12/17/2012 3:05 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
OK in researching Query End hang status, I saw several reports saying it had to do with multiple queries trying to simultaneously hit the same table. Maybe something in that script is not quite right, so that it's doing two things at once? Can someone look into that?

To solve it, I edited my my.ini in my MySQL directory and set the query_cache_size to 0. Once I did that, POOF, my posts go through instantly.

So my problem is solved in that sense, and it means I don't have the advantages of a query cache. So a small degradation to solve a huge hurdle, until we can figure out what is jamming up in that post script.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: BellaOnline] #251467 12/17/2012 8:05 AM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
you are delaying the inevitable...

RAM RAM RAM wink

Re: Slow Queries [Re: BellaOnline] #251503 12/17/2012 6:53 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
If I could upgrade the ram in these systems, I would. They are maxed out.

I haven't heard back from the hosting company about how much money it would cost to upgrade to completely new servers.

I'll note that if anything all the advice I read on the web about sql cache was to *drop* its value - not raise it - to help with this problem. The problem apparently isn't RAM here. It's that two SQL threads are in contention and are crashing into each other. If anything the advice said a larger cache created a larger opportunity for that crashing to occur and that reducing the RAM dedicated to the sql cache minimized the chances of this happening (because the cache would clear before the collision occurred). But they said in general this event was indicative of something wrong with the code, that there was that potential for two threads to hit the same area at the same time. That the code should ensure one process finished before the next began.

So in this specific case I don't think more RAM will help, since everyone is saying to reduce the RAM used, not increase it.

See here and then follow the link to the bug report -

http://serverfault.com/questions/176465/mysql-thread-get-stuck-in-end-state

Again removing the cache made the problem go away. So putting all load on active memory fixed the problem. So to me that doesn't sound like RAM was the bottleneck.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts
Re: Slow Queries [Re: SD] #251519 12/18/2012 1:50 AM
Joined: Apr 2006
Posts: 143
Z65Paul Offline
member
Offline
member
Joined: Apr 2006
Posts: 143
Originally Posted by SD
... now, what i do is at startup, do a command like "cp /path/to/all/my/*.MYD /dev/null"

that gets the ball rolling immediately...



SD.. can you tell me where to that command string? I'd like to implement that on my server (Apache).

Thanks
Paul


Stress the system until it breaks. Hey.. it works for Spacecraft.. why not here?

UBB since 1999: MonteCarloSS.com
Re: Slow Queries [Re: BellaOnline] #251526 12/18/2012 9:31 AM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
You'd do it via the shell (command line) on your server.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Slow Queries [Re: BellaOnline] #251561 12/18/2012 8:43 PM
Joined: Apr 2006
Posts: 143
Z65Paul Offline
member
Offline
member
Joined: Apr 2006
Posts: 143
Thanks Gizmo.. I should have been more clear. Where would I place that command string to have it executed every time the server is rebooted? I know I can do that from the shell command line... but the benefit of that operation would be undone by a reboot. I'm not super savy on Apache / Unix startup scripts. Looking for the magical spot to place that 'cp ... > dev/null' code string.

Thanks
Paul


Stress the system until it breaks. Hey.. it works for Spacecraft.. why not here?

UBB since 1999: MonteCarloSS.com
Re: Slow Queries [Re: BellaOnline] #251608 12/21/2012 12:41 AM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
In case anybody finds this thread and has similar problems, I ended up resolving my issues and now have a quick, happy forum with the 2 gig RAM. I list the steps I took to get it here -

Tuning Ideas for 2G RAM


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 57,000 members / 800,000 posts

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Who's Online Now
0 registered members (), 62 guests, and 416 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)