[pLog-svn] r3167 - in plog/trunk: . install

Jon Daley plogworld at jon.limedaley.com
Fri Mar 31 17:17:29 GMT 2006


 	I have binlog'ing turned on.  I can't turn on the "old" full data 
slow logging way, it would slow down the server too much.  I host Oscar's 
personal site, so the answer is the same for his site as well.
 	If you can use the bin logs, that is easy, and I can filter out 
non lifetype stuff.

On Sat, 1 Apr 2006, Mark Wu wrote:
> Hi Christoph:
>
> Nice, we really need someone's help to let us know know how to improve our
> database design.
>
> Right now, Oscar already run lifetype in lifetype.net and his personal web
> site, so I think maybe he can give you some information if you can give us
> the necessary  instructions.
>
> And, I also run lifetype 1.1 everyday, but only in development environment.
> If you think it is still worth to know my development enviroment
> information. I love to help.
>
> And, I remember Jon also run lifetype in his website (not so sure), so ...
> Maybe he also can provide the information you need.
>
> Mark
>
>> -----Original Message-----
>> From: plog-svn-bounces at devel.lifetype.net
>> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of
>> Christoph Feddersen
>> Sent: Saturday, April 01, 2006 12:53 AM
>> To: plog-svn at devel.lifetype.net
>> Subject: Re: [pLog-svn] r3167 - in plog/trunk: . install
>>
>> If you're interested in some database optimizations, I should
>> be able to  have a closer look at the scheme and the queries
>> within the next two weeks. Database design and optimization
>> is part of my daily job.
>>
>> For query optimization, it would really help to get
>> information from a productive 1.1 system. I know that some of
>> you are already running 1.1, would anyone configure his mysql
>> server to log the mysql queries if I supply the necessary
>> instructions?
>> It should be a mysql server that is running Lifetype only.
>> Logging should be activated 24h, more would be better.
>>
>> Christoph
>>
>> Jon Daley wrote:
>>> On Fri, 31 Mar 2006, Mark Wu wrote:
>>>> I am not sure which table use what kind of  table type is more
>>>> proper, so, I set all of them as "TYPE=MyISAM" ..
>>>>
>>>> I will leave this part for you to decide which table  us innoDB
>>>
>>>     There is at least one forum post from a guy who sounds like he
>>> knows what he is talking about, and he had a number of
>> suggestions on
>>> which table is which.
>>> _______________________________________________
>>> pLog-svn mailing list
>>> pLog-svn at devel.lifetype.net
>>> http://devel.lifetype.net/mailman/listinfo/plog-svn
>>
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.lifetype.net/mailman/listinfo/plog-svn
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

**************************************
Jon Daley
http://jon.limedaley.com/

Nothing is as inevitable as a mistake whose time has come.
-- Tussman


More information about the pLog-svn mailing list