]
Sent: Friday, April 13, 2007 2:41 PM
To: 'Chuck Swiger'
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Mysql Hogging all system resources
Is there a way to set a 'nice' priority for a particular user?
Also, when I run this:
nice -n 5 /usr/bin/spamd -d -c -m 5
I get:
nice: Badly formed
On Apr 13, 2007, at 2:40 PM, Don O'Neil wrote:
Is there a way to set a 'nice' priority for a particular user?
Why, yes-- see /etc/login.conf and the priority keyword.
Some shells also let you adjust the priority levels for various users.
Also, when I run this:
nice -n 5 /usr/bin/spamd -d -c
his processes (old and new) with a nice of 0.
Is there something else I'm missing?
-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
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.
I'm running FreeBSD 6.1.
___
[EMAIL PROTECTED] mailing list
http
was unplug it.
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.
man login.conf should tell you all you need to know
PROTECTED]
Subject: Re: Mysql Hogging all system resources
In response to Don O'Neil [EMAIL PROTECTED]:
I have a customer that loaded up a HUGE table and was doing all sorts
of fancy stuff in it, and not waiting for the process to finish before
sending the same query, and eventually loading up
a certain % CPU, but still lives, esentially
taking longer
to process than if it had unlimited resources. That way the process
still
runs and the system isn't taken to it's knees.
Use the nice or renice commands to lower the priority of the MySQL
server so that it will not preempt other
I've asked this question on the mysql-users list, but there wasn't any
more information than what I've seen on google.
The problem is that I get an error when trying to use mysqldump to get a
backup of our RT Attachments table (all other tables will process fine)
/usr/local/bin/mysqldump: Error
Hi all,
(Questions towards the end of the mail)
Recently I've been looking at my web-applications and all of them
support both mysql and mysqli php-modules (i.e. phpMyAdmin, roundcube,
gallery2).
Both php5-mysql and php5-mysqli ports are installed on my system.
Only phpMyAdmin offers a knob
Hi,
After i follow you taught me that step it display.
= couldn't fetch it - please try to retrieve this
= port manually into /usr/ports/distfiles/adstudio-4.5.2_1 andt try again.
*** Error code 1
Stop in /usr/ports/databases/adstudio.
*** Error code 1
how should i do? maybe you have taught
On 21/03/07, Frank [EMAIL PROTECTED] wrote:
Hi,
After i follow you taught me that step it display.
= couldn't fetch it - please try to retrieve this
= port manually into /usr/ports/distfiles/adstudio-4.5.2_1 andt try again.
*** Error code 1
Stop in /usr/ports/databases/adstudio.
*** Error
this is true, Frank alias Andreas tries to build mysql, but has
issued make in /usr/ports/databases instead of issueing make in
/usr/ports/databases/mysql51-server.
regards,
usleep
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org
On startup of mysql-server 5.0.12 on FBSD 5.4-RELEASE my server always has 3
0-size unreferenced files with 69 links reported by lsof +L1.
23 groups of:
mysqld 6179 mysql6u VREG 4,170 09 /var (/dev/aacd0s1d)
mysqld 6179 mysql7u VREG 4,170 0 23 /var
hi this is Frank,
after i finish MySQL. how should i know it's work or
not? then how should i install php and apache? last question is how you learned
FreeBSD?
regards,
by Frank
___
freebsd-questions@freebsd.org mailing list
Frank,
The majority of your questions has nothing to do with FreeBSD. Please
submit your questions to the appropriate mailing lists for those
projects (Apache, MySQL, PHP, etc.).
As for how one goes about learning FreeBSD, there are dozens of books,
manuals, documentations, how-to's available
On Wednesday March 21, 2007 at 09:27:06 (AM) Frank wrote:
hi this is Frank,
after i finish MySQL. how should i know it's work or not? then how
should i install php and apache? last question is how you learned
FreeBSD?
Add the following to your '/etc/rc.conf' file:
mysql_enable=YES
On Wed, Mar 21, 2007 at 09:27:06PM +0800, Frank wrote:
hi this is Frank,
after i finish MySQL. how should i know it's work or not? then how
should i install php and apache? last question is how you learned FreeBSD?
For Apache, for example, you install it from ports.
cd /usr/ports/www
On Mar 21, 2007, at 7:24 AM, Jim Flowers wrote:
On startup of mysql-server 5.0.12 on FBSD 5.4-RELEASE my server
always has 3
0-size unreferenced files with 69 links reported by lsof +L1.
23 groups of:
mysqld 6179 mysql6u VREG 4,170 09 /var (/
dev/aacd0s1d)
mysqld
mysql-server stop removes unreferenced files and links, however, mysql-server
start just creates them again (of course with higher inodes). The link count
does go down some over time (now at 54).
Must be something in the startup routine. Just thought someone might have run
into it before
hi,
i have questions about install MySQL in FreeBSD 6.0, after type # make it
would be display like bottom.
make all-recursive
Making all in .
Making all in include
make all-am
Making all in Docs
Making all in cmd-line-utils
Making all in libedit
Making all in sql-common
Making all in pstack
Frank wrote:
hi,
i have questions about install MySQL in FreeBSD 6.0, after type # make it
would be display like bottom.
make all-recursive
Making all in .
Making all in include
make all-am
Making all in Docs
Making all in cmd-line-utils
Making all in libedit
Making all in sql
Frank,
On 3/18/07, Frank [EMAIL PROTECTED] wrote:
hi,
i have questions about install MySQL in FreeBSD 6.0, after type # make
it would be display like bottom.
make all-recursive
Making all in .
Making all in include
make all-am
Making all in Docs
Making all in cmd-line-utils
Making all
On Mar 18, 2007, at 8:21 AM, Frank wrote:
Stop in /usr/home/frank/mysql-5.0.33.
P.S I'm a new, so i don't know how to solve this problem hope you
can solve for me easily.
From Frank
Frank,
Install MySQL from Ports - it'll save you a lot of headache.
su root
cd /usr/ports/databases
Hai Every One,
Do The Low Performance of MySQL on FreeBSD Still Exists ? ( in FreeBSD6.2 )
Please HELP
SUSANTH K
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail
On 3/10/07, Susanth K [EMAIL PROTECTED] wrote:
Hai Every One,
Do The Low Performance of MySQL on FreeBSD Still Exists ? ( in FreeBSD6.2 )
Please HELP
SUSANTH K
since FreeBSD 6.0 and using libthr instead of linuxthread, there is no
low performance issues.
Make sure you'll use MySQL 5.0.x
In the last episode (Mar 06), Greg 'groggy' Lehey said:
[Moving to -questions; this isn't really a ports issue]
On Monday, 5 March 2007 at 23:28:53 -0800, Drew Jenkins wrote:
I built MySQL 5.1 from port on FBSD 6.2. But it doesn't start up on
boot. There's a mysql-server script in /usr
On Tue, 6 Mar 2007 18:24:39 +1030
Greg 'groggy' Lehey [EMAIL PROTECTED] wrote:
On Monday, 5 March 2007 at 23:28:53 -0800, Drew Jenkins wrote:
I built MySQL 5.1 from port on FBSD 6.2. But it doesn't start up on
boot. There's a mysql-server script in /usr/local/etc/rc.d/ but if I
try
Hi there,
I just upgraded to 6.2 and now I do not see my mysql privileges. is
there an easy way to get them back in place. I thought they would
magically appear in the /var/db/mysql directory and stuff.
Is there an easy way to recover these accounts or do I need to readd
them manually
Noah schrieb:
Hi there,
I just upgraded to 6.2 and now I do not see my mysql privileges. is
there an easy way to get them back in place. I thought they would
magically appear in the /var/db/mysql directory and stuff.
Is there an easy way to recover these accounts or do I need to readd
the user accounts are gone. where does that information reside? I dont
know how else to say or ask that question.
Cheers,
Noah
Björn König wrote:
Noah schrieb:
Hi there,
I just upgraded to 6.2 and now I do not see my mysql privileges. is
there an easy way to get them back in place. I
user accounts are held in /etc/passwd
the default UIDs created by ports are listed in
/usr/ports/UIDs
including mysql
mysql:*:88:88:MySQL Daemon:/var/db/mysql:/sbin/nologin
you can either re-add it using pw or just paste the line in using vipw
Vince
Noah wrote:
the user accounts are gone
thanks Vince,
yeah - I have about 15 other user accounts specific to my mysql
installation that were not in the /etc/passwd file. where were those
stored?
Cheers,
Noah
Vince Hoffman wrote:
user accounts are held in /etc/passwd
the default UIDs created by ports are listed in
/usr/ports
In the last episode (Mar 06), Noah said:
yeah - I have about 15 other user accounts specific to my mysql
installation that were not in the /etc/passwd file. where were those
stored?
If you're just talking about mysql users, those are in
/var/db/mysql/mysql/user.* . An OS upgrade shouldn't
- Original Message
From: Jeremy Chadwick [EMAIL PROTECTED]
To: Drew Jenkins [EMAIL PROTECTED]
Cc: freebsd-ports@freebsd.org
Sent: Tuesday, March 6, 2007 5:33:11 PM
Subject: Re: MySQL Startup Script
This isn't a good idea. ldconfig is supposed to take care of this for you.
Can you
binary install. okay I backed up teh dir
let me look for them now
cheers,
Noah
Dan Nelson wrote:
In the last episode (Mar 06), Noah said:
yeah - I have about 15 other user accounts specific to my mysql
installation that were not in the /etc/passwd file. where were those
stored
Dan,
okay you got me on the right track.
I can see mysql files in that directory. but mysql is not aware of the
users in the user files
is there something that I need to tell to mysql to use those files to
reincorporate the mysql related users?
# ls -l /var/db/mysql/mysql
total 648
-rw
In the last episode (Mar 06), Noah said:
yeah - I have about 15 other user accounts specific to my mysql
installation that were not in the /etc/passwd file. where were those
stored?
If you're just talking about mysql users, those are in
/var/db/mysql/mysql/user.* . An OS upgrade shouldn't
I dont think that is the issue. the problem is with the mysql virtual
users
they do not appear in the /etc/passwd or /etc/master.passwd files.
so that is the wrong direction.
cheers,
Noah
Steve Bertrand wrote:
In the last episode (Mar 06), Noah said:
yeah - I have about 15 other user
In the last episode (Mar 06), Noah said:
okay you got me on the right track.
I can see mysql files in that directory. but mysql is not aware of the
users in the user files
is there something that I need to tell to mysql to use those files to
reincorporate the mysql related users?
# ls
I hope this is the right place--i looked over the MySQL docs but they talk
about a different startup practice than what FreeBSD uses.
I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my
MySQL data directory in a place other than /var/db/mysql. I thought i do
Hello Dr. Nussbaum,
I do this quite alot but I prefer to do it like this:
1. stop mysqld.
2. copy the /var/db/mysql to where I want it to be
3. rename /var/db/mysql to keep the original (just in case)
4. create a symlink in /var/db that points to where I want it to be
You create a symlink
Kalashnikov Ilya [EMAIL PROTECTED] wrote: On Mon, 2007-03-05 at
07:05 -0800, Dr. Jennifer Nussbaum wrote:
I hope this is the right place--i looked over the MySQL docs but they talk
about a different startup practice than what FreeBSD uses. I have a new
install of MySQL 5.1
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote:
I hope this is the right place--i looked over the MySQL docs but they talk
about a different startup practice than what FreeBSD uses.
I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my
MySQL data
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote:
I hope this is the right place--i looked over the MySQL docs but they talk
about a different startup practice than what FreeBSD uses.
I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my
MySQL data
: On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote:
I hope this is the right place--i looked over the MySQL docs but they talk about a different startup practice than what FreeBSD uses. I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my MySQL data
On Mon, 5 Mar 2007, Kalashnikov Ilya wrote:
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote:
I hope this is the right place--i looked over the MySQL docs but they talk
about a different startup practice than what FreeBSD uses.
I have a new install of MySQL 5.1 on a FreeBSD
[Format recovered--see http://www.lemis.com/email/email-format.html]
Single line message.
[Moving to -questions; this isn't really a ports issue]
On Monday, 5 March 2007 at 23:28:53 -0800, Drew Jenkins wrote:
I built MySQL 5.1 from port on FBSD 6.2. But it doesn't start up on
boot. There's
Hello,
I have 2 database servers running as slaves from a
Master database. One (db2) is running FreeBSD
6.2-PRERELEASE from October. The other, (db3) on a new
build of FreeBSD 6.2-STABLE. Both are AMD64.
Db2 is running mysql 5.0.24a and has been working
fine.
Db3 however, running mysql 5.0.33
are php5-extensions and to be more precise
php5-mysql.
php5-mysql and php5-extensions reports
configure: error: mysql configure failed. Please check config.log for
more information.
=== Script configure failed unexpectedly.
Please report the problem to [EMAIL PROTECTED]
The requisites
Hi people.
I'm testing pure-ftpd from FreeBSD 6.2, i want to test with MySQL
4.1which already is running, i read the docs from the site but didn't
see
anything about how pure-ftp authenticated users from Mysql. My both
servers are running but, where is the PureFTPD database inf MySQL
On 2007/02/14 13:50, perikillo seems to have typed:
Hi people.
I'm testing pure-ftpd from FreeBSD 6.2, i want to test with MySQL
4.1which already is running, i read the docs from the site but didn't
see
anything about how pure-ftp authenticated users from Mysql. My both
servers
and to be more precise
php5-mysql.
php5-mysql and php5-extensions reports
configure: error: mysql configure failed. Please check config.log for
more information.
=== Script configure failed unexpectedly.
Please report the problem to [EMAIL PROTECTED]
The requisites are met, all the following
except a few and among those are php5-extensions and to be more precise
php5-mysql.
php5-mysql and php5-extensions reports
configure: error: mysql configure failed. Please check config.log for
more information.
=== Script configure failed unexpectedly.
Please report the problem to [EMAIL
to be up to date
except a few and among those are php5-extensions and to be more precise
php5-mysql.
php5-mysql and php5-extensions reports
configure: error: mysql configure failed. Please check config.log for
more information.
=== Script configure failed unexpectedly.
Please report the problem
On Monday, 12 February 2007 at 20:45:16 +0100, Roger Olofsson wrote:
Alain Wolf skrev:
On 12.02.2007 11:52, * Roger Olofsson wrote:
After a recent buildworld/portupgrade everything seems to be up to date
except a few and among those are php5-extensions and to be more precise
php5-mysql.
I
/portupgrade everything seems to be up to date
except a few and among those are php5-extensions and to be more precise
php5-mysql.
I am not really sure if its the same issue, but I had the same problems
on two of my systems.
After I deinstalled and reinstalled mysql-client-5.0.33 it went fine again
so I am running FreeBSD 6.2
and installing phpMyAdmin for the first time.
even after recompiling php5 with the mysql extension phpMyAdmin still
complains Cannot load mysql extension
what else cna I try?
here are the server stats:
ns1# pkg_info | grep MyAdmin
phpMyAdmin-2.9.2A set of PHP
Hello all,
I have a question. I am using mysql (Ver 14.12 Distrib 5.1.11-beta, for
portbld-freebsd6.1 (i386) using 5.0) on a FBSD 6.2-RELEASE box. Today it
got a bit of work to do and as a result the load was between 8-10 at peak
times. I connect to mysql through socket. Mysql is mostly needed
p5-DBD-mysql50 and mysql itself
Date: 03 Feb 2007 19:58:22 +
Message-ID: [EMAIL PROTECTED]
Lines: 128
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
I've upgraded Perl (via portupgrade), but the ports I need
to re-install
, your just lucky
that this very minor thing was the only thing that blew up.
Ted
- Original Message -
From: Robert Inder [EMAIL PROTECTED]
To: freebsd-questions@freebsd.org
Sent: Saturday, February 03, 2007 11:58 AM
Subject: Port upgrade/install problem: MySQL and Perl I/F
p5-DBD
Hello;
I'm trying to build MySQL 5.0 (server) on FBSD 6.1 from port. I ran make
install clean but now I'm lost. mysqld is not up. What is my username? Never
asked me for one in the install. Tried this:
# /usr/local/libexec/mysqld -umysql
070109 16:39:30 InnoDB: Operating system error number 13
On 1/10/07, Stan Halprin [EMAIL PROTECTED] wrote:
Hello;
I'm trying to build MySQL 5.0 (server) on FBSD 6.1 from port. I ran make install
clean but now I'm lost. mysqld is not up. What is my username? Never asked me for
one in the install. Tried this:
# /usr/local/libexec/mysqld -umysql
Check if user mysql exists. If it doesn't - create it.
# echo 'mysql_enable=YES' /etc/rc.conf
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql
#chown -R root .
#chown -R mysql var
#chgrp -R mysql .
#bin/mysqld_safe --user=mysql
#bin/mysqladmin -u root password ''
#bin/mysql
grant all
- Original Message
From: George Vanev [EMAIL PROTECTED]
From: Andrew Patyukhin
Andrew:
/usr/local/etc/rc.d/mysql-server start
Worked. MySQL up! Thanks!
George:
Since MySQL is up, I don't know if the following matters any more,
nonetheless...
Check if user mysql exists. If it doesn't
Helo friends,
1. I have installed Mysql 5 and media wiki 1.7 in FreeBSD 6.0 version. but
forgot to install PHP before media wiki installation.
but while installing mediawiki (through ports collection) some PHp
packages its installed automatically.
2 . after the mediawiki installation I
Im in the middle of installing Mysql max on a bsd 6.2 box, anyone have
an idea how to make it start on boot? the script is in the
/usr/local/etc/rc.d file and the mysql_enable=YES is in the rc.conf
file but it still isn't starting. since this is max i couldn't install
it from the ports, i
Hi
I've just instal apache2 server and php4 on a freebsd 6.1.
I want to instal mysql server 4.1 or 5 (i tryed both) and when i want to start
this deamon, it isn't started because when i want to change the password root,
there is a message say that may be the service is not started or may
On Tue, Dec 05, 2006 at 09:02:39AM +0100, sebcouf wrote:
Hi
I've just instal apache2 server and php4 on a freebsd 6.1.
I want to instal mysql server 4.1 or 5 (i tryed both) and when i want to
start this deamon, it isn't started because when i want to change the
password root
compiled with default options ( not setting WITHOUT_INNODB ), but when I
start the server, I can't create or convert any tables to InnoDB format.
I tried various my.cf files ( including my-innodb-heavy-4G.cnf and without
any cnf files,
show engine innodb status;
ERROR 1235 (42000): Cannot call
[EMAIL PROTECTED] wrote:
show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is
defined
How do I get InnoDB working ? please help !!
___
freebsd-questions@freebsd.org mailing list
On Wednesday November 15, 2006 at 08:33:20 (PM) Warren Liddell wrote:
Im running FreeBSD 6.2-PRERELEASE .. below is the error when trying to build
this port..
==
=== Building for php5-mysql-5.2.0
/bin/sh /usr/ports/databases/php5-mysql/work/php-5.2.0/ext/mysql/libtool
Im running FreeBSD 6.2-PRERELEASE .. below is the error when trying to build
this port..
==
=== Building for php5-mysql-5.2.0
/bin/sh /usr/ports/databases/php5-mysql/work/php-5.2.0/ext/mysql/libtool
--mode=compile
cc -I. -I/usr/ports/databases/php5-mysql/work/php-5.2.0/ext
I figured that must have something to do with the way
MySQL stores and php encrypts/decrypts data.
I used mysqldump and saw that the passwords in MySQL
are stored as Blowfish hashes, and I suspect that php
uses a different algorithm when it tries to
authenticate against the mysql database
adjustments to mysql, php and apache configuration
files. I grabbed the compressed archive from
vtiger.com and extracted it under my Apache document
root. The web-based setup went smoothly, on both
machines. However after the setup was done and it was
time to test the CRM, I was able to go past the login
On Friday, 3 November 2006 at 19:56:00 +0800, ke han wrote:
I need feedback from users with mysql 5.0.x (or even 4.1.x) in
production on SMP systems. X86_64 Opteron is my platform.
I have heard rumors of it not scaling and it crashes and odd errors
Have these been worked out in the latest
I need feedback from users with mysql 5.0.x (or even 4.1.x) in
production on SMP systems. X86_64 Opteron is my platform.
I have heard rumors of it not scaling and it crashes and odd errors
Have these been worked out in the latest releases of freebsd and mysql?
Any thoughts on this topic may
On Oct 24, 2006, at 6:52 PM, jan gestre wrote:
On 10/25/06, Jonathan Horne [EMAIL PROTECTED] wrote:
i do know how to import a .sql database dump, i was just wondering
if i
can do
it via a restore job from netbackup. any opinions i can get, are
greatly
appreciated.
to backup a mysql
typical OT thread apologies, but the truth *really* is that this is the best
and most intelligent list i read. so...
i use veritas netbackup 5.1 to backup my bsd machines, and i would like to
restore some mysql databases onto another machine. is restoring any mysql
database, as simple
typical OT thread apologies, but the truth *really* is that this is the best
and most intelligent list i read. so...
You're really going to get better answers from the mysql lists... really.
:)
i use veritas netbackup 5.1 to backup my bsd machines, and i would like to
restore some mysql
On 10/25/06, Jonathan Horne [EMAIL PROTECTED] wrote:
typical OT thread apologies, but the truth *really* is that this is the
best
and most intelligent list i read. so...
i use veritas netbackup 5.1 to backup my bsd machines, and i would like to
restore some mysql databases onto another machine
Hello,
This is not a FreeBSD question... but The community is much more helpful
than most, so I thought I'd try here.
I have MySQL server on my laptop. Its just for play so not really
worried about any data. I recently portupgraded a ton of stuff. Jumped
though some unforeseen hoops
Eric Schuele wrote:
Hello,
This is not a FreeBSD question... but The community is much more helpful
than most, so I thought I'd try here.
I have MySQL server on my laptop. Its just for play so not really
worried about any data. I recently portupgraded a ton of stuff. Jumped
though some
On 10/19/06 09:19, Eric wrote:
Eric Schuele wrote:
Hello,
This is not a FreeBSD question... but The community is much more
helpful than most, so I thought I'd try here.
I have MySQL server on my laptop. Its just for play so not really
worried about any data. I recently portupgraded a ton
X-No-Archive: true
Hi,
With the gracious help of a poster here, I managed to get roundcube up and
running, and had to resort to MySQL, which I know very little of.
After it was all up and running, and we'd added the users and tested their
access to webmail, we decided to put some
Hi,
With the gracious help of a poster here, I managed to get roundcube up and
running, and had to resort to MySQL, which I know very little of.
After it was all up and running, and we'd added the users and tested their
access to webmail, we decided to put some more memory
for the response from experienced people for the above
command which i think will work.
All these provided that you have the mysql server installed..
Regards, Spiros
On 13/10/06, Desmond Coughlan [EMAIL PROTECTED] wrote:
X-No-Archive: true
Hi,
With the gracious help of a poster here, I managed to get
you started.
and if you (original mysql-newbie-poster) want to check the logfiles,
they're usually in /var/db/mysql/
you'll want to look at the *.err file(s),
it could just be a problem with the socket
--
grtjs,
albi
___
freebsd-questions@freebsd.org
Olivier Nicole wrote:
[...]
If you installed MySQL through FreeBSD mechanism, it should be started
with the comand:
/usr/local/etc/rc.d/mysql.sh start
Actually, mine is: /usr/local/etc/rc.d/mysql-server
I think it depends on what version is installed.
provided you have put mysql_enable
X-No-Archive: true
Thanks guys.. it worked. I still don't know why MySQL didn't start at boot.
That's worrying, 'cos if I get hit by a car on my way home tonight, and the
bloke who does IT here knows MySQL even less than I do (no really.. that _is_
possible..)
I've printed
Helo, freebsd-questions.
I have FreeBSD 6.2 with 2GB RAM, 4GB SWAP and MySQL 5.0
In my.cnf I write innodb_buffer_pool_size = 1G
When Mysql 5.0 starting his write to errorr log:
InnoDB: Error: cannot allocate 1073758208 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB
Desmond Coughlan wrote:
X-No-Archive: true
Thanks guys.. it worked. I still don't know why MySQL didn't start at
boot. That's worrying, 'cos if I get hit by a car on my way home tonight,
and the bloke who does IT here knows MySQL even less than I do (no really..
that _is_ possible
Hi again,
On 13/10/06, Desmond Coughlan [EMAIL PROTECTED] wrote:
X-No-Archive: true
Thanks guys.. it worked. I still don't know why MySQL didn't start at
boot.
I am using MySQL occasionally in my FreeBSD. For this reason when i first
had the same with you problem and i found this way
I have a server running 6.1-STABLE. One of the jails on that machine
runs MySQL 4.1.21. If I have mysql_enable=YES in /etc/rc.conf when I
start the jail it hangs indefinitely. If I set it to NO the jail starts
fine. I can then login to the jail via SSH and change it to YES and
start MySQL
while wanting to compile with
MySQL support in driver-mysql.c (please see below for more information).
Is there someone experiencing the same issue? Or should I file pr?
i believe they just checked in an update to rc7 for dovecot with the fix
for high kqueue loads yesterday. Update your ports
Hello Eric,
Eric wrote:
i believe they just checked in an update to rc7 for dovecot with the fix
for high kqueue loads yesterday. Update your ports tree and you should
see it. The check in notes specifically mentioned the kqueue fix.
It's okay, but issue with compiling is reoccuring.
Hello all,
Martin Hudec wrote:
It's okay, but issue with compiling is reoccuring.
yesterday Martin Werner provided me with fix to this issue. Though it's
a mysql issue in 5.0.x [1] , one can workaround it [2] when compiling
dovecot with mysql support.
[1] http://bugs.mysql.com/bug.php?id
with
MySQL support in driver-mysql.c (please see below for more information).
Is there someone experiencing the same issue? Or should I file pr?
thanks,
Martin Hudec
RELEVANT INFORMATION
1.) config options
MySQL support enabled, kqueue support disabled.
2.) output from
Hello
Just wondering if I can get an advice from this forum?
What kind of hardware i.e.(Processor, RAM) I need to accomplish following
jobs on a FreeBSD plateform:
I have some mysql dumps around 2 GB eachwith each record is 100 KB...
1. What is the best method to import them into a mysql
You would do better posting to the mysql lists, as this isn't really
related to the OS.
I would suggest you use the command line utilities to load the records. I
would first slice them into chunks not too big, then iterate through
them. If the records are in some order, if you get an error
On Thursday 07 September 2006 6:17 am, VeeJay wrote:
Hello
Just wondering if I can get an advice from this forum?
What kind of hardware i.e.(Processor, RAM) I need to accomplish following
jobs on a FreeBSD plateform:
I have some mysql dumps around 2 GB eachwith each record is 100 KB
501 - 600 of 1650 matches
Mail list logo