Re: mysql

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

  • Next message: Erik _at_ Microcontroller.nl: "Re: mysql" 
    To: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
Date: Tue, 28 Sep 2004 18:01:40 +0300

    i've meant our server configuration

    and are u doing big DBs?

    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>
    _______________________________________________
    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: Erik _at_ Microcontroller.nl: "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 ... > and are u doing big DBs? ... freebsd 4.9 with mysql 4.018 ...
      (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: Phantom /var full messages
      ... Paul Schmehl probably wrote: ... See some recent previous posts on the subject. ... I have no experience with mysql, but I'd think something is creating ... to show the number of files open by the mysqld process (or any other ...
      (freebsd-questions)
    • Stopping MySQL
      ... I have mysql running, and have connected via MySQLAdministrator and have ... Control, but, when going to the terminal and typing mysql it states ... A mysqld process already exists ...
      (Fedora)
    • Quantcast