Re: mysql

From: Mustafa N. Deeb (mustafa_at_palnet.com)
Date: 09/28/04

  • Next message: James Housley: "Re: mysql" 
    To: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
Date: Tue, 28 Sep 2004 18:29:42 +0300

    hi

    you might be suffering from an I/O problem

    if it takes a long time in big queries,

    consider raid and using InnoDB

    Cheers
    ----- Original Message -----
    From: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
    To: "Mustafa N. Deeb" <Mustafa@palnet.com>
    Cc: <freebsd-isp@freebsd.org>
    Sent: Tuesday, September 28, 2004 6:14 PM
    Subject: Re: mysql

    On Tue, 2004-09-28 at 17:01, Mustafa N. Deeb wrote:

    > 
    > i've meant our server configuration
    >
    > and are u doing big DBs?

    ah o.k.,
    freebsd 4.9 with mysql 4.018
    there is one site with a big index, a big select query for every visit.
    this generates the problem.
    Should I increase the number of connections? I don't believe this is the
    issue
    Should I increase some kind of read buffer? but is this not dynamically
    regulated by mysql already?

    hmm,. I now switched to the my-large.cnf configuration in
    /usr/local/share/mysql/
    I copied it to /usr/local/share/mysql/my.cnf
    and restarted mysql

    let's see how that goes..

    Greetings,
    -Erik.

    >
    > Cheers
    >
    > ----- Original Message -----
    > From: Erik @ Microcontroller.nl
    > To: Mustafa N. Deeb
    > Cc: freebsd-isp@freebsd.org
    > Sent: Tuesday, September 28, 2004 5:48 PM
    > Subject: Re: mysql
    >
    > On Tue, 2004-09-28 at 16:26, Mustafa N. Deeb wrote:
    >
    > > what is your configuration ?
    >
    >
    > I put:
    > [mysqld]
    > query_cache_type = ON
    > query_cache_size = 10M
    >
    > in /usr/local/etc/my.cnf
    >
    > I read that doing mysqld --help will give me all parameters,.
    > but how do we do that on a freebsd install where I use
    > mysqld_safe?
    >
    >
    >
    >
    > >
    > >
    > > ----- Original Message -----
    > > From: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
    > > To: <freebsd-isp@freebsd.org>
    > > Sent: Tuesday, September 28, 2004 5:01 PM
    > > Subject: mysql
    > >
    > >
    > > >
    > > > Hi all,.
    > > > Are you using any mysql tuning settings in my.cnf?
    > > > I'm having a bit of trouble with some have mysql sites with
    > big query's
    > > > resulting in a mysqld process at 80% continue.
    > > >
    > > > any tips are welcome.
    > > >
    > > > -Erik.
    > > >
    > > > _______________________________________________
    > > > freebsd-isp@freebsd.org mailing list
    > > > http://lists.freebsd.org/mailman/listinfo/freebsd-isp
    > > > To unsubscribe, send any mail to
    > "freebsd-isp-unsubscribe@freebsd.org"
    >
    > --
    > Erik @ Microcontroller.nl <erik@microcontroller.nl> 

    -- 
Erik @ Microcontroller.nl <erik@microcontroller.nl>
_______________________________________________
freebsd-isp@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" 
_______________________________________________
freebsd-isp@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"
  • Next message: James Housley: "Re: mysql"

    Relevant Pages