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

[Christoph Feddersen]

The problem with the binary log is that it doesn't contain that much
information, so it's harder to examine it. Can't you activate it just
for a few hours?
If not, can you configurate the lifetype logfile to print out all SELECT
queries? They just need to be seperated with newlines.

Jon Daley wrote:
>     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
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn