Re: mysql

From: Erik _at_ Microcontroller.nl (_at_)
Date: 09/28/04

  • Next message: Mustafa N. Deeb: "Re: mysql" 
    To: "Mustafa N. Deeb" <Mustafa@palnet.com>
Date: Tue, 28 Sep 2004 17:14:25 +0200

    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"
  • Next message: Mustafa N. Deeb: "Re: mysql"

    Relevant Pages

    • Re: sql statement + fulltext search
      ... change the server configuration: ... searching for 2 character words will return a large amount of useless ... mysql "match against" try sphinx. ...
      (php.general)
    • Re: mysql
      ... i've meant our server configuration ... To: Mustafa N. Deeb ... Subject: Re: mysql ... > resulting in a mysqld process at 80% continue. ...
      (freebsd-isp)
    • Re: mysql
      ... you might be suffering from an I/O problem ... > i've meant our server configuration ... freebsd 4.9 with mysql 4.018 ... To unsubscribe, ...
      (freebsd-isp)
    • Re: MySQL Performance 6.0rc1
      ... Nevertheless I run a production MySQL on a double-Xeon (Supermicro ... etc) which eventually kill MySQL with FreeBSD ... CPU: AMD OpteronProcessor 246 ... <ACPI PCI bus> on pcib0 ...
      (freebsd-current)
    • What am I doing wrong with MOUNT?
      ... I'm brand new to FreeBSD and Unix world in general. ... I installed MySQL version 3.23 from the ports ... of his database that I had MySQL dump on his FreeBSD server and FTP'd it to ... I mounted the new drive 1 to a temporary mount point and used the cp command ...
      (freebsd-newbies)
    • Quantcast