Le 26/11/2007 à 13:31:12+0100, Jan Catrysse a écrit
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2,
I'm running
Mysql 5.X on this server and the performance of MySQL is
very bad.
For some complexe select I've got ~6secondes (on some basic Linux
it's take 0.6 sec
Le 26/11/2007 à 13:29:35+0100, Ivan Voras a écrit
Albert Shih wrote:
Hi all
I've already send a message. But I don't receive any answer :-(. I try again
and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
5.X on this server
Le 26/11/2007 à 07:20:43-0500, Philip M. Gollucci a écrit
Albert Shih wrote:
Hi all
I've already send a message. But I don't receive any answer :-(. I try again
and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
5.X
On Mon, 26 Nov 2007 13:03:19 +0100
Albert Shih [EMAIL PROTECTED] wrote:
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm
running Mysql 5.X on this server and the performance of MySQL
is very bad. For some complexe select I've got ~6secondes (on
some basic Linux it's
-Original Message-
From: Albert Shih [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007 5:00 AM
To: Ted Mittelstaedt
Cc: freebsd-questions@freebsd.org
Subject: Re: Help for very bad perf for MySQL
Le 26/11/2007 à 22:34:34-0800, Ted Mittelstaedt a écrit
Sorry
Is Hyperthreading enabled (by default it is not under
FreeBSD) mysql is heavily dependent on threading, if it is not
built and linked into the freebsd threads package you will get
poor performance. Some folks have installed the linux compat libs
and linked mysql into the linux threads
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-freebsd-
[EMAIL PROTECTED] On Behalf Of Josh Carroll
Sent: Tuesday, November 27, 2007 8:12 AM
To: Ted Mittelstaedt
Cc: [EMAIL PROTECTED]; freebsd-questions@freebsd.org
Subject: Re: Help for very bad perf for MySQL
Hi all
I've already send a message. But I don't receive any answer :-(. I try again
and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
5.X on this server and the performance of MySQL is very bad. For some
complexe select I've got ~6secondes
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Albert Shih
Sent: Monday, November 26, 2007 12:50 PM
To: freebsd-questions@freebsd.org
Subject: Help for very bad perf for MySQL
Hi all
I've already send a message. But I don't receive any answer
Le 26/11/2007 à 13:01:47+0100, Jan Catrysse a écrit
-Original Message-
I've already send a message. But I don't receive any answer
:-(. I try again and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm
running Mysql 5.X on this server
Albert Shih wrote:
Hi all
I've already send a message. But I don't receive any answer :-(. I try again
and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
5.X on this server and the performance of MySQL is very bad. For some
complexe
Albert Shih wrote:
Hi all
I've already send a message. But I don't receive any answer :-(. I try again
and hope there more solution
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql
5.X on this server and the performance of MySQL is very bad. For some
complexe
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2,
I'm running
Mysql 5.X on this server and the performance of MySQL is
very bad.
For some complexe select I've got ~6secondes (on some basic Linux
it's take 0.6 sec).
6 seconds seem to be an awful lot. What kind of query
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Albert Shih
Sent: Monday, November 26, 2007 3:50 AM
To: freebsd-questions@freebsd.org
Subject: Help for very bad perf for MySQL
Hi all
I've already send a message. But I don't receive any answer
MySQL has a handy graphical front-end called mysql-administrator. There used
to be a port for it (databases/mysql-administrator). The port was marked
broken in February and deleted in April.
The last CVS entry reads:
Remove databases/mysql-administrator.
It's a part of MySQL Tools now
On Thu, Nov 22, 2007 at 10:23:01AM -0800, jekillen wrote:
Hello;
I have installed mysql51-client, mysql51-server, and mysql51-scripts.
I looked for pkg_message in mysql51-scripts but there is none.
Where do I get info on what this port has and what it does?
Take a look at the port's
mysql-scripts|less -S
From there you can use man(1) or Google.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Hi all
I've some question about MySQL on FreeBSD 6.x.
I've running MySQL 5.x on FreeBSD 6.x on a dual Xeon 3.2Ghz (mono-core)
with 2 SAS 1 rpm. And the perf is very...poor (x10 vs Linux)
and it's nothing about thread because the performance is poor for a single
select in mysql.
I known
We have a php+mysql web server. It serves 15-20 http requests per
second, resulting in 100-200 sql qps. But according to vmstat(1),
it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks
are quite frequent, even at this load. During the peaks top(1)
shows 30-40k VCSW for mysql
Andrew Pantyukhin wrote:
We have a php+mysql web server. It serves 15-20 http requests per
second, resulting in 100-200 sql qps. But according to vmstat(1),
it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks
are quite frequent, even at this load. During the peaks top(1)
shows
On Thu, Nov 22, 2007 at 02:52:06PM +, Vince wrote:
Andrew Pantyukhin wrote:
We have a php+mysql web server. It serves 15-20 http requests per
second, resulting in 100-200 sql qps. But according to vmstat(1),
it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks
are quite
Hello;
I have installed mysql51-client, mysql51-server, and mysql51-scripts.
I looked for pkg_message in mysql51-scripts but there is none.
Where do I get info on what this port has and what it does?
Thank you for info
Jeff K
___
On Thu, Nov 22, 2007 at 12:43:25PM +0300, Andrew Pantyukhin wrote:
We have a php+mysql web server. It serves 15-20 http requests per
second, resulting in 100-200 sql qps. But according to vmstat(1),
it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks
are quite frequent, even
to solve this at a later stage, restart this script with
the --force option
This is strange because this is also secondary dns server for the
domain.
I looked in ports at what is available for mysql and there are a number
of
listings for various versions. For a particular version there appear
hostname.
If you want to solve this at a later stage, restart this script with
the --force option
This is strange because this is also secondary dns server for the domain.
I looked in ports at what is available for mysql and there are a number of
listings for various versions. For a particular version
Hi Dan,
One last thing (It's way past my bedtime here ;-p)
See that --with-berkeley-db in there? :-(
A little digging in the mysql ditribution's source files dredged up
the CONF_COMMAND variable.
Do-ing,
CONF_COMMAND=--without-berkeley-db; export $CONF_COMMAND
perl -pi -e
's
I'll check the build's output with ldd when the build finishes.
Looks like the simple workaround works :-)
ldd /usr/local/libexec/mysqld
libz.so.3 = /lib/libz.so.3 (0x284a8000)
libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284b9000)
libssl.so.5 =
Hi everybody,
I'm building my 1st FreeBSD-based box. Yay, I guess ;-p
I've already installed Berkeley DB v46 from the Ports system.
Now, I'ts on to MySQL server.
I can easily build manually from source, configuring whatever I need.
But, I'm trying to get the Ports system's knobs figured out
WITHOUT_CSV=true
WITHOUT_FEDERATED=true
WITHOUT_NDB=true
Turning INNODB on/off is clear.
But I haven't been able to grok how to
(1) Turn OFF use of BDB completely. The build seems to default to the
bundled BDB
Mysql 5.0's configure script doesn't seem to have a --without-bdb
Hi Dan!
(1) Turn OFF use of BDB completely. The build seems to default to the
bundled BDB
Mysql 5.0's configure script doesn't seem to have a --without-bdb flag,
so it always gets built.
(2) Use the Port install of BDB v46 I mentioned above.
It does have a --with-berkeley-db=DIR flag
In the last episode (Sep 19), Aliya Harbouri said:
(1) Turn OFF use of BDB completely. The build seems to default
to the bundled BDB
Mysql 5.0's configure script doesn't seem to have a --without-bdb
flag, so it always gets built.
(2) Use the Port install of BDB v46 I mentioned
,
grep berkeley-db ./work/mysql-5.0.45/config.log | grep $ ./configure
$ ./configure --localstatedir=/var/db/mysql --without-debug
--without-readline --without-libedit --without-bench
--without-extra-tools --with-libwrap --with-mysqlfs --with-low-memory
--with-comment=FreeBSD port: mysql-server
Philip M. Gollucci wrote:
my.cnf
innodb_thread_concurrency = 8
You want '0' or performance will suck. There's a basic architectural
flaw in how mysql handles non-zero concurrency values here (innodb
accesses are serialized by a global mutex that protects a counter to
check if it should try
. There's a basic architectural
flaw in how mysql handles non-zero concurrency values here (innodb
accesses are serialized by a global mutex that protects a counter to
check if it should try to allow more innodb concurrency. Duh.)
Anyway, assuming your disks can keep up you should see a big
Philip M. Gollucci wrote:
Philip M. Gollucci wrote:
my.cnf
innodb_thread_concurrency = 8
You want '0' or performance will suck. There's a basic architectural
flaw in how mysql handles non-zero concurrency values here (innodb
accesses are serialized by a global mutex that protects a counter
Philip M. Gollucci wrote:
Is it worth having the port remove that recommendation from the
/usr/local/share/mysql/*.cnf files ?
It probably is worth it, yeah.
Kris
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman
i have had many jails, and have never really had any problems with them until
this one. for some reason, mysql wont start. nothing else is having any
trouble starting, which is strange.
is there a log file i can look in that might give me some clues as to whats
going on? mysql_enable=YES
On Thursday 30 August 2007, Jonathan Horne said:
i have had many jails, and have never really had any problems with
them until this one. for some reason, mysql wont start. nothing
else is having any trouble starting, which is strange.
is there a log file i can look in that might give me
On Thursday 30 August 2007 14:34:34 Beech Rintoul wrote:
Read the *.err files in /var/db/mysql. It should tell you why it's
failing.
Beech
thanks, that led me right to it!
antares# /usr/local/etc/rc.d/mysql-server status
mysql is running as pid 1738.
cheers,
--
Jonathan Horne
http
trouble starting, which is strange.
is there a log file i can look in that might give me some clues as to whats
going on? mysql_enable=YES is in my rc.conf, and when i start it i get:
antares# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
antares# /usr/local/etc/rc.d/mysql-server
Hi
I have been trying to get mysql running for the past two days without luck.
I added these two packages using sysinstall from FTP.
mysql-client-4.0.26_1 Multithreaded SQL database (client)
mysql-server-4.0.26_2 Multithreaded SQL database (server)
I went to the folder /usr/ports
Add mysql_enable=YES to your /etc/rc.conf file, and use the /usr/
local/etc/rc.d/mysql-server script to start the process as follows:
% su root
# /usr/local/etc/rc.d/mysql-server start
HTH
Eric Crist
On Aug 17, 2007, at 9:01 AMAug 17, 2007, Fidel Garcia wrote:
Hi
I have been trying
This is what I found inside this file:
/var/db/mysql/fr.admin.err
070816 08:36:14 mysqld started
070816 8:36:14 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://dev.mysql.com/doc/mysql/en/InnoDB.html
InnoDB: for installation help.
InnoDB: The error means mysqld
This is the error I get. I ran the command as root.
fr# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
fr# /usr/local/bin/mysqld_safe: cannot create /var/db/mysql/fr.admin.err:
Permission denied
Fidel Garcia
System Engineer
SysTeam.
7205 NW 19th Street, Suite 302
Miami, Florida 33126
Hi all,
I've got an unusual problem with my server. It just restarted after a
power cut. Everything came back up apart from MySQL. The server refuses
to chroot it.
%sudo /uetc/rc.d/mysql-server start
Password:
[: chroot: unexpected operator
Starting mysql.
%chroot: /jail/mysql: Operation
Hi,
I recently upgraded from 3.23 to 4.027. My steps were:
1. Stopped the mysql server
2. make deinstall in mysql-server 3.23
3. make deinstall in mysql-client 3.23
4. make install clean in mysql-server 4.0.27
5. Ran the mysql_fix_privilege_tables
6. Started the mysql server again
(and ofcourse
In the last episode (Jul 29), David Banning said:
I have recently converted from mysql 4.1 to 5.0 and some of my tables
are not recogized. Using the mysql_upgrade utility is not effective
as -it- does not recognize certain tables.
On closer examination I see that the tables
I have recently converted from mysql 4.1 to 5.0 and some of my
tables are not recogized. Using the mysql_upgrade utility is
not effective as -it- does not recognize certain tables.
On closer examination I see that the tables that are -not- recognize
have the following extensions;
-rw-rw 1
David Banning wrote:
I have recently converted from mysql 4.1 to 5.0 and some of my
tables are not recogized. Using the mysql_upgrade utility is
not effective as -it- does not recognize certain tables.
On closer examination I see that the tables that are -not- recognize
have the following
Hello,
I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most
current ports version is 5.0.45. So I tried to portupgrade and it tells me:
--- Session started at: Fri, 27 Jul 2007 09:17:39 +0200
** No need to upgrade 'mysql-server-5.0.45' (= mysql-server-5.0.45).
(specify -f
Zbigniew Szalbot wrote:
Hello,
I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most
current ports version is 5.0.45. So I tried to portupgrade and it tells me:
--- Session started at: Fri, 27 Jul 2007 09:17:39 +0200
** No need to upgrade 'mysql-server-5.0.45' (= mysql
Hello,
On Fri, 27 Jul 2007 11:06:42 +0300, Manolis Kiagias [EMAIL PROTECTED]
wrote:
Zbigniew Szalbot wrote:
Hello,
I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most
current ports version is 5.0.45. So I tried to portupgrade and it tells
me:
--- Session started
Zbigniew Szalbot wrote:
Yes, indeed I now know what happened. The *-server version got upgraded and
I was unaware that *-client stayed at 0.27. I was sure that upgrading
*-server will upgrade *-client too. Apparently it did not happen:
$ pkg_info -Ix mysql
mysql-client-5.0.27 Multithreaded
David Banning writes:
I installed mysql 5.1 on a new system and I want to run a 4.1
database. I notice that not all tables work. Is there a
conversion to take the database from 4.1 to 5.1?
It is my understanding that you will have to dump (using the
appropriate MySQL utilities
I installed mysql 5.1 on a new system and I want to run a 4.1 database. I
notice that
not all tables work. Is there a conversion to take the database from 4.1 to 5.1?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman
Gerard wrote:
On July 25, 2007 at 12:14PM Noah wrote:
Even with the following IGNORE settings
mysql-4.1.22 is still attempting to be built.
# grep IGNORE /usr/local/etc/portmanager/pm-020.conf
#IGNORE|editors/openoffice*|
#IGNORE|java/jdk14|
IGNORE|www/apache13|
IGNORE|www/apache13*|
IGNORE
David Banning escribió:
I installed mysql 5.1 on a new system and I want to run a 4.1 database. I
notice that
not all tables work. Is there a conversion to take the database from 4.1 to 5.1?
I think you only have to run REPAIR TABLE or OPTIMIZE TABLE on the
broken tables. IIRC, the indexing
Although MySQL has worked very hard to ensure a high level of quality,
protect your data by making a backup as you would for any other software
beta release. MySQL generally recommends that you dump and reload your
tables from any previous version to upgrade to 5.2.
Troy
http://primoris.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Gabor Kovesdan wrote:
David Banning escribió:
I installed mysql 5.1 on a new system and I want to run a 4.1
database. I notice that
not all tables work. Is there a conversion to take the database from
4.1 to 5.1?
I think you only have
Hi there Gerard,
Even with the following IGNORE settings
mysql-4.1.22 is still attempting to be built.
# grep IGNORE /usr/local/etc/portmanager/pm-020.conf
#IGNORE|editors/openoffice*|
#IGNORE|java/jdk14|
IGNORE|www/apache13|
IGNORE|www/apache13*|
IGNORE|www/mod_perl|
IGNORE|net/openldap23
On July 25, 2007 at 12:14PM Noah wrote:
Even with the following IGNORE settings
mysql-4.1.22 is still attempting to be built.
# grep IGNORE /usr/local/etc/portmanager/pm-020.conf
#IGNORE|editors/openoffice*|
#IGNORE|java/jdk14|
IGNORE|www/apache13|
IGNORE|www/apache13*|
IGNORE|www
Hi,
I've FreeBSD 6.1-RELEASE-p16 #3 and the
php5-extensions 1.1 doesn't have anything related
to pdo mysql.
Can somebody tell me how do I install pdo mysql?
Thanks in advance...
Sé un Mejor Amante
On July 24, 2007 at 09:46AM Efren Bravo wrote:
I've FreeBSD 6.1-RELEASE-p16 #3 and the
php5-extensions 1.1 doesn't have anything related
to pdo mysql.
Can somebody tell me how do I install pdo mysql?
Perhaps you are looking for: php5-pdo_mysql-5.2.3, located in:
/usr/ports/databases/php5
Hi there,
I am attempting to stop portmanager from installing mysql-client-4.1.22
so I added the following lines to my portmanager config file.
$ grep IGNORE /usr/local/etc/portmanager/pm-020.conf
#IGNORE|editors/openoffice*|
#IGNORE|java/jdk14|
IGNORE|www/apache13|
IGNORE|www/apache13*|
IGNORE
On July 20, 2007 at 01:09PM Noah wrote:
Hi there,
I am attempting to stop portmanager from installing mysql-client-4.1.22
so I added the following lines to my portmanager config file.
$ grep IGNORE /usr/local/etc/portmanager/pm-020.conf
#IGNORE|editors/openoffice*|
#IGNORE|java/jdk14
facility). The problem I'm having is that it's a fairly
well-trafficked site. The ipnat entries table fills up quickly (30,000
I think is the max), and so I have to ipnat -F fairly often (every 5
minutes or so). The problem with this is that it kills any outgoing
connections (like my mysql replication
facility). The problem I'm having is that it's a fairly
well-trafficked site. The ipnat entries table fills up quickly (30,000
I think is the max), and so I have to ipnat -F fairly often (every 5
minutes or so). The problem with this is that it kills any outgoing
connections (like my mysql replication
is, it even says
that if mysqld is not running.
I'm running under freebsd 6.1.
You can examine my server setup at http://geekfleet.tai-gear.com/server-info
You can examine the php setup at http://geekfleet.tai-gear.com/phpinfo.php
The problem I'm having now is that php5 won't connect to the mysql
at
http://geekfleet.tai-gear.com/phpinfo.php
The problem I'm having now is that php5 won't
connect to the mysql server.
It's not a gallery thing, I've confirmed that I have
the exact same problem
with a simple script to just connect to the mysql
server and read the
database
Just a general question about mysql remote access.
Is it possible to login to my remote mysql server and create a
new db table using a file on the local system which contains
the definition statements?
Thanks
___
freebsd-questions@freebsd.org
Just a general question about mysql remote access.
Is it possible to login to my remote mysql server and create a
new db table using a file on the local system which contains
the definition statements?
Thanks
___
freebsd-questions@freebsd.org
On Mon, Jul 09, 2007 at 11:40:07PM -0400, fbsd2 wrote:
Just a general question about mysql remote access.
Is it possible to login to my remote mysql server and create a
new db table using a file on the local system which contains
the definition statements?
Thanks
Of course, it's
On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated:
Just a general question about mysql remote access.
Is it possible to login to my remote mysql server and create a
new db table using a file on the local system which contains
the definition statements?
Sure. As long
On Tue, 10 Jul 2007 at 12:01 -, [EMAIL PROTECTED] confabulated:
On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated:
Just a general question about mysql remote access.
Is it possible to login to my remote mysql server and create a
new db table using a file on the local
On Tue, 2007-07-10 at 12:15 +, Duane Hill wrote:
On Tue, 10 Jul 2007 at 12:01 -, [EMAIL PROTECTED] confabulated:
On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated:
Just a general question about mysql remote access.
Is it possible to login to my remote mysql
To autostart mysql at boot add this to /etc/rc.conf
mysql_enable=YES
Add this to /etc/rc.conf to direct to use location where there is a large
enough free disk space
to hold your databases
mysql_dbdir=/usr/local/mysql
To start or stop mysql server do this
/usr/local/share/mysql/mysql.server
This is pretty pathetic but I'm batting a 1000 on this one. I
installed mysql a few weeks ago on this web server I'm making for my
church and didn't do anything with it at that point (that was the
first mistake). I've not used mysql (I usually use PostgreSQL) but
WebGUI wants mysql. So, being
On July 04, 2007 at 06:00PM Andrew Falanga wrote:
This is pretty pathetic but I'm batting a 1000 on this one. I
installed mysql a few weeks ago on this web server I'm making for my
church and didn't do anything with it at that point (that was the
first mistake). I've not used mysql (I
--On July 4, 2007 4:00:48 PM -0600 Andrew Falanga [EMAIL PROTECTED]
wrote:
This is pretty pathetic but I'm batting a 1000 on this one. I
installed mysql a few weeks ago on this web server I'm making for my
church and didn't do anything with it at that point (that was the
first mistake). I've
To autostart mysql at boot add this to /etc/rc.conf
mysql_enable=YES
Add this to /etc/rc.conf to direct to use location where there is a large
enough free disk space
to hold your databases
mysql_dbdir=/usr/local/mysql
To start or stop mysql server do this
/usr/local/share/mysql/mysql.server
Hi,
I am posting this here thinking this may be more of an OS thing than a mysql
thing...
Since all mysql databases and tables need to be owned by the mysql user, is
there, er, has anyone figured out a way to impose disk quotas per database for
mysql?
-Grant
Grant Peel wrote:
I am posting this here thinking this may be more of an OS thing than a mysql
thing...
Since all mysql databases and tables need to be owned by the mysql user, is
there, er, has anyone figured out a way to impose disk quotas per database
for mysql?
Databases tend to lose
this:
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes but
it's pretty broad too so i'm not sure. Has anyone done it with amavisd-new?
--
View this message in context:
http://www.nabble.com/Spamassassin-Bayes-mySQL-%2B-Amavisd-new-tf3893449.html#a11037822
Sent from the freebsd
-- Forwarded message --
From: Agus [EMAIL PROTECTED]
Date: 18-may-2007 19:14
Subject: Re: mysql start error...
To: Hanatsu Tori [EMAIL PROTECTED]
2007/5/17, Hanatsu Tori [EMAIL PROTECTED]:
Hi!
Please
id
ls -la /bin/csh
ls -la /usr/local/etc/rc.d/mysql-server
Dmitry
2007/5
Hi!
Please
id
ls -la /bin/csh
ls -la /usr/local/etc/rc.d/mysql-server
Dmitry
2007/5/17, Agus [EMAIL PROTECTED]:
Hi,
I am getting an error while trying to run mysql-server...
Wired thing is that it was running ok for a month.suddenly i got this
error..
su: /bin/csh: Permission denied
Hi,
I am getting an error while trying to run mysql-server...
Wired thing is that it was running ok for a month.suddenly i got this
error..
su: /bin/csh: Permission denied
thanks for any hints you could give
see ya
___
freebsd-questions
Hello,
I have dual xeon server with 2 GB of ram.
FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386
Which runs heavily MySQL with MyISAM, the problem I have it maxes out
one cpu, and doesn't use the other one.
Could someone tell me what shall
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote:
Hi,
It depends on the threading library you use. Can you please
show us the output of
ldd /usr/local/libexec/mysqld ?
You should use libthr instead of libpthread or libc_r in /etc/libmap.conf
for mysqld.
--
Martin
Martin Blapp, [EMAIL
Hi,
So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster
or it's not optimized for dual cpu yet?
Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because
some bottlenecks (unix domain sockets etc, old malloc) have been removed.
--
Martin
Hi,
Ohh, I overread that you already use libthr.
But ...
90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld
It looks like you did not turn on 'showing threads' in top, else you would
have seen that many mysqld's are running on cpu 0, other on cpu 1.
--
Martin
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote:
Hi,
Ohh, I overread that you already use libthr.
But ...
90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld
It looks like you did not turn on 'showing threads' in top, else you would
have seen that many mysqld's
--
On Fri, 11 May 2007, Abdullah Ibn Hamad Al-Marri wrote:
Hello,
I have dual xeon server with 2 GB of ram.
FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386
Which runs heavily MySQL with MyISAM, the problem I have it maxes
Martin Blapp wrote:
So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster
or it's not optimized for dual cpu yet?
Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because
some bottlenecks (unix domain sockets etc, old malloc) have been removed.
On the other
utilization dropped significantly.
HTH
I have dual xeon server with 2 GB of ram.
FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386
Which runs heavily MySQL with MyISAM, the problem I have it maxes out
one cpu, and doesn't use the other one
Hi, can anybody direct me to the subjected topic? I tried to google it out,
but only chrooting of old versions is explained.
Regards
Lubos
---
avast! Antivirus on Lubnet Server: Odchozi zprava cista.
Virova databaze (VPS): 000734-2, 18.04.2007
Testovano: 18.4.2007 23:57:13
avast! (c)
Lubomir Matousek [EMAIL PROTECTED] wrote:
Hi, can anybody direct me to the subjected topic? I tried to google it out,
but only chrooting of old versions is explained.
This isn't exactly the answer to your question, but as an alternative
you could jail Apache and whatever else you wanted to
In the last episode (Apr 13), Don O'Neil said:
Nevermind on the badly formatted number... I specified the full path
/usr/bin/nice and it worked ok this time :-)
However, I still want to know if there is a way to specify a nice
level for an entire users processes.
If you create a login class
.
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
In the last episode (Apr 13), Don O'Neil said:
Nevermind on the badly
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
Is there a way to prioritize or set the amount of resources that
MySQL is
allowed to have? Do I need to set it up as a jailed process maybe?
I've
never done that before, so I'm not sure if it's the right approach
or not.
Um, didn't
:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
Is there a way to prioritize or set the amount of resources that MySQL
is allowed
401 - 500 of 1650 matches
Mail list logo