List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:March 18 2010 10:31am
Subject:Re: MySQL Storage Engine
View as plain text  
Thanks for the useful information.  Can you let me know any other things I
need to consider ?

Regards
Neil

On Thu, Mar 18, 2010 at 9:50 AM, Krishna Chandra Prajapati <
prajapatikc@stripped> wrote:

> Hi Neil,
>
> Many times we need to generate reports (weekly, montly, yearly) from the
> data we have. For detailed reports we have to use joins on many tables. So,
> it takes time from 2 to 5. So these types of activities must be performed on
> slave server.
>
> If you need reports then you should have master - slave replication.
>
> http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
>
> _Krishna
>
>
> On Thu, Mar 18, 2010 at 3:11 PM, Tompkins Neil <
> neil.tompkins@stripped> wrote:
>
>> Hi
>>
>> How do you mean "executed on slave" ?
>>
>> Neil
>>
>>
>> On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati <
>> prajapatikc@stripped> wrote:
>>
>>> Hi Neil,
>>>
>>> Recommend : Innodb storage engine
>>>
>>> Even, i would suggest inner join select query (if report query might
>>> takes few seconds) should be executed on slave.
>>>
>>> Before doing any thing. Plan out all the requirement.
>>>
>>> Regards,
>>> Krishna
>>>
>>>
>>> On Thu, Mar 18, 2010 at 2:48 PM, Tompkins Neil <
>>> neil.tompkins@stripped> wrote:
>>>
>>>> Hi
>>>>
>>>> I'm currently looking to develop an on line web application - which is
>>>> going
>>>> to be used by around 200+ concurrent users at any one time.  Can
>>>> you recommend to me the best/preferred MySQL database engine to use for
>>>> example MyISAM ?
>>>>
>>>> Also, in your experiences, do you recommend that SELECT statements
>>>> containing a number of INNER JOINS should be execute from a Stored
>>>> procedure
>>>> or purely from the webpage ?
>>>>
>>>> Cheers
>>>> Neil
>>>>
>>>
>>>
>>
>

Thread
MySQL Storage EngineTompkins Neil18 Mar
  • Re: MySQL Storage EngineKrishna Chandra Prajapati18 Mar
    • Re: MySQL Storage EngineTompkins Neil18 Mar
      • Re: MySQL Storage EngineKrishna Chandra Prajapati18 Mar
        • Re: MySQL Storage EngineTompkins Neil18 Mar
  • Re: MySQL Storage EngineIan Simpson18 Mar
  • Re: MySQL Storage Enginemos18 Mar
    • Re: MySQL Storage EngineTompkins Neil20 Mar