Home | Community | Message Board
You are not signed in.
Sign In New Account
Forum Index Search Posts Trusted Vendors Highlights Galleries FAQ User List Chat Store Random Growery


This site includes paid links. Please support our sponsors.

Feedback and Administration > Website Announcements and Feature Feedback
Threaded Mode Threaded  Previous topic Previous  View all topics Index  Next topic Next 

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post Pages: 1
Strange Glitch.
    #6817854 -

When a reply is mad to this thread in OTD...

http://www.shroomery.org/forums/showflat.php/Cat/0/Number/6817813/an/0/page/0

The reply forms as it's own new thread, weird.


--------------------
Coaster is an idiot...
[quote]Coaster said:
but i thnk everything thats pure is white?
[/quote]



Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Hanky]
    #6817861 -

I think I figured it out. I can't run mySQL with --low-priority-updates. I should have thought of it earlier. This should put an end to that kind of rare but recurring bug.

Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Ythan]
    #6817870 -

Cool, you may as well delete this thread now to save a smidgeon of server space.


--------------------
Coaster is an idiot...
[quote]Coaster said:
but i thnk everything thats pure is white?
[/quote]



Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Hanky]
    #6817879 -

Saving server space is like, so 2006. :wink: I'm quite proud that I tweaked it to where we shouldn't have to worry about that stuff anymore.

Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Ythan]
    #6817926 -

Sounds good to me, I'll still stick to hot linking my awful pics though, just out of habit.


--------------------
Coaster is an idiot...
[quote]Coaster said:
but i thnk everything thats pure is white?
[/quote]



Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Hanky]
    #6817929 -

That's good, I was talking more about posts in the database than images on the hard drive anyway. Although last I checked, all the uploads only totaled something like 20GB... that's pretty tiny, considering.

Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Ythan]
    #6817961 -

Wow that's far less than I would have imagined.


--------------------
Coaster is an idiot...
[quote]Coaster said:
but i thnk everything thats pure is white?
[/quote]



Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Ythan]
    #6818142 -

Ythan said:
That's good, I was talking more about posts in the database than images on the hard drive anyway. Although last I checked, all the uploads only totaled something like 20GB... that's pretty tiny, considering.


Then maybe you could increase the upload limit to 15 megs for us plebs?


--------------------
Coaster is an idiot...
[quote]Coaster said:
but i thnk everything thats pure is white?
[/quote]



Extras: Filter Print Post Top
Re: Strange Glitch. [Re: Ythan]
    #6823021 -

Ythan said:
Saving server space is like, so 2006. :wink: I'm quite proud that I tweaked it to where we shouldn't have to worry about that stuff anymore.


Is there a forum where you share your esoteric knowledge?


--------------------
HOW'S MY POSTING? CLICK HERE

Extras: Filter Print Post Top
Re: Strange Glitch. [Re: JunkFood]
    #6823101 -

Nothing too esoteric about it. :wink: Reduce the size of the database when possible, using tinyints or enums instead of varchars (especially important if the mongoloids at Madrona Park aka Infopop aka Groupee designed your DB structure :wink:). Use ip2long to store IPs as integers, which require 4 bytes instead of 15. Eliminate redundant indexes which slow down updates. Use insert delayed when you can. Use myISAM if you don't need transactional integrity. Fulltext search MUST be done through Sphinx or Lucerne or similar since mySQL chokes on large datasets. Increase your key_buffer_size if you have spare RAM and the ratio of key_reads to key_read_requests is worse than 1:100. If open_tables is at the max and opened_tables is very high increase your table_cache. Throw on xcache to speed up PHP. Then log slow queries, EXPLAIN them all, and rewrite the queries to make better use of existing indexes or add new ones. There are tomes written about mySQL optimization, I'm really a rank amateur but even with my very limited knowledge it was possible to obtain some serious improvements. The single most important factor for us was switching to Sphinx for searching, everything else was just icing on the cake. But YMMV.

Extras: Filter Print Post Top
Jump to top Pages: 1

Feedback and Administration > Website Announcements and Feature Feedback
Threaded Mode Threaded  Previous topic Previous  View all topics Index  Next topic Next 

Similar ThreadsPosterViewsRepliesLast post
* Another Glitch? blissedout 644 3 12/02/06 10:58 PM
by Ythan
* Weird Mark As Read Glitch fireworks_godS 472 2 06/02/07 12:12 AM
by Legend9123
* okay 2 things, nice new feature to pm's,. and theree are 3 dmpty drop down menus, on the index ZippoZM 469 1 09/29/05 10:18 AM
by ZippoZ
* strange... Prisoner#1 984 12 10/31/05 03:35 PM
by Prisoner#1
* Weird glitch AsanteM 726 2 11/04/06 11:23 AM
by Vvellum
* Strange pop up. Hanky 694 7 03/05/07 06:48 AM
by Colonel Kurtz Ph.D
* Forum Index Auto Updates
( 1 2 all )		 YthanA 4,201 35 02/15/07 04:19 PM
by Colonel Kurtz Ph.D
* rating glitch. Banez 662 3 02/22/07 02:09 AM
by Ythan

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Ythan, Thor, Seuss, geokills
985 topic views. 0 members, 14 guests and 0 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2026 Mind Media. Some rights reserved.

Generated in 0.032 seconds spending 0.007 seconds on 16 queries.