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

Christoph Feddersen feddersen at herr-der-ringe-film.de
Fri Mar 31 17:51:41 GMT 2006


Ok, logs from a productive site helps to identify the current
bottlenecks more easily. If that's not possible, doing it on a
development box will also do it if you try to simulate a normal usage.

Setup should be:

- activate the general query log
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
- activate the slow query log
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Set long_query_time=1 and use --log-queries-not-using-indexes if you're
using MySQL 5.x

Depending on the hits the server is getting, doing this for a few hours
will be enough.
Please also provide me the my.cnf and some info about the used hardware
(CPU, RAM, disks).
Do a SHOW STATUS and SHOW VARIABLES at the end of the logging session
and send me that information, too.

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


More information about the pLog-svn mailing list