[slscripters] Problem with SL http_response errors
nexiim at gmail.com
Fri Oct 7 04:35:50 PDT 2011
Huh? If you have MySQL it should most deifnitely be available, you can set
any table to a specific engine. I think some common frameworks even use it,
I swear I had seen it on one table of phpBB or wordpress or wikipedia.
Yeah, wikipedia has got MEMORY engine set on the hitcounter table.
- Nexii Malthus
On Fri, Oct 7, 2011 at 9:15 AM, AnnMarie at SLFBI.com <AnnMarie at slfbi.com>wrote:
> Oh that would be great but its a hosted service. I've not checked but I
> don't think that would be available. I'm lucky to be doing what I am on a
> service that is only $6.50 a month. When running my vehicles at full
> capacity in SL my website approaches 500,000 queries a day.
> On 10/7/2011 3:31 AM, Nexii Malthus wrote:
> Can't you move away from HDD and onto memory?
> Read up on the MySQL 'MEMORY' engine for a temporary table that holds
> things more frequently accessed.
> Then copy to HDD infrequently.
> - Nexii Malthus
> On Fri, Oct 7, 2011 at 8:26 AM, AnnMarie at SLFBI.com <AnnMarie at slfbi.com>wrote:
>> Thanks for your suggestions, I think I've solved the problem, if anyone
>> is interested.
>> I suspected it might be due to file locking when incoming queries
>> synchronized randomly and suddenly bombarded the data base with 100
>> queries in less than a second. It doesn't explain why that should occur
>> more from 6PM to Midnight unless the MYSQL engine is just running slower
>> under peak hour load.
>> 95% of the queries access one data file that is "Read Frequently, write
>> rarely". The file is about 750K and about 2,000 records.
>> So I made two mirrors of the file which are accessed at random and kept
>> the original as a master copy. This reduced file locking time 50%.
>> Write functions are just applied to the master and periodically, or on
>> demand, the master is copied to the mirrors.
>> A simple solution that took 5 minutes to set up and so far it has been
>> running without a single http failure. It would be very easy to expand
>> to more mirrors later if needed but so far 2 data sources seems to be
>> Ann-Marie Otoole.
>> Click here to unsubscribe or manage your list subscription:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the secondlifescripters