Hi, Inline comments.
On Tue, Sep 13, 2011 at 7:55 PM, Andrew Colin Kissa <[email protected]> wrote: > > On 13 Sep 2011, at 7:47 PM, Mikael Syska wrote: > >> The only thing is that the webinterface is a bit slow, but I hope that >> will be fixed when the data is moved to a document database or we try >> to limit the amount of data we are logging. > > What kind of volumes do you have, if you have very large volumes you > should think of scaling your setup. Not that big ... 414,150 rows in the Messages table. Using MyISAM. Could this be converted to InnoDB without problems? Thats about 2 month of data, with is where the cleanup kicks in. > > * Introduce read only slaves for the web servers With the above stats, I dont think that will do anything. > * write to the master that replicates to the slave Again ... but I could be mistaken. > * introduce a caching layer to cache most of your data. Cache what? Are there anything I have missed here? Maybe some hidden gems or anything to make Django/Apache run faster, if thats what we are waiting for. > > -- > Baruwa - www.baruwa.org > > _______________________________________________ > Baruwa mailing list > [email protected] > http://lists.baruwa.org/mailman/listinfo/baruwa > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > mvh _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
