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 16:48:44 +0200

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

    Relevant Pages

    • Re: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes
      ... 040413 07:10:29 mysqld started ... 040413 7:10:32 Can't init databases ... Starting service MySQL ... Preparing host table ...
      (SuSE)
    • Re: mysql ??
      ... >>Mike I seem to be making some head way, I have the server running a sock ... > Definitely looks like a grant table problem. ... this is the weakest point in the mysql install procedure - you ... > the whole permission system while I muck with getting mysqld set up ...
      (alt.os.linux.suse)
    • Re: EMERGENCY - need to secure my server against an ongoing SPAMMER
      ... Most of my sites are dynamic and heavily rely on MySql. ... > that mysqld actually failed. ... Putting back the old files I noticed the log error was specifically ... access rights, disabled SELinux, and hey presto mysqld works again. ...
      (Fedora)
    • MySQL 4.0.18 server problem on FreeBSD 5.2-Current
      ... 040323 19:52:50 mysqld restarted ... 040323 19:52:50 InnoDB: Started ... I tried with linuxthreads-2.2.3_15 and linuxthreads-2.2.3_13 but mysql ... I even tried to downgrade mysql server to 4.0.17 but same error. ...
      (freebsd-current)
    • Errors in MYSQL 4.1.1
      ... Although a log ot really good work has been done on MYSQL, ... Lost connection to MySQL server during query ... $ Set NoOn ... It is possible that mysqld could use up to ...
      (comp.os.vms)