[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