On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass
wrote:
Hi,
We've been having this problem with a customer for a while and it
seems that some funky query makes MySQL use 100% of CPU. Nevertheless,
even though you can see in top that it's only 1 CPU in 100% (out of 8)
the server eventually
On Wed, May 22, 2013 at 2:04 PM, Michael Ross wrote:
> On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass
> wrote:
>
>> Hi,
>>
>> We've been having this problem with a customer for a while and it
>> seems that some funky query makes MySQL use 100% of CPU. Nevertheless,
>> even though you can see
On 01/24/12 07:06, Crow wrote:
I want to create MySQL localhost.
Can you provide some more information? Like which version of FreeBSD you
are using (or other OS if you happen to be needing other support), what
you have completed so far, other parameters that you are able to tell us
which may h
First hit on google:
http://www.google.com/search?q=mysqlnd
On Thu, Aug 11, 2011 at 01:31:11PM +0200, Dick Hoogendijk typed:
> PhpMyAdmin shows:
>
> Server: Localhost via UNIX socket
> Server version: 5.5.15
> Protocol version: 10
> User: root@localhost
> MySQL charset: UTF-
quot;Chris Rees"
To: "Glenn McCalley"
Cc:
Sent: Tuesday, June 07, 2011 8:37 AM
Subject: Re: MySQL update
On 7 June 2011 12:56, Glenn McCalley wrote:
Trying to update MySQL from 4.1 to 5.5.
Updating mysql-client first.
Make works great, but make install refuses to install saying
On 07/06/2011 13:37, Chris Rees wrote:
> On 7 June 2011 12:56, Glenn McCalley wrote:
>> Trying to update MySQL from 4.1 to 5.5.
>> Updating mysql-client first.
>> Make works great, but make install refuses to install saying 5.5 conflicts
>> with 4.1, run
>> pkg_delete for 4.1.
>> pkg_delete for 4.
On 7 June 2011 12:56, Glenn McCalley wrote:
> Trying to update MySQL from 4.1 to 5.5.
> Updating mysql-client first.
> Make works great, but make install refuses to install saying 5.5 conflicts
> with 4.1, run
> pkg_delete for 4.1.
> pkg_delete for 4.1 refuses to deinstall as all the php52 package
"Glenn McCalley" writes:
> Trying to update MySQL from 4.1 to 5.5.
> Updating mysql-client first.
> Make works great, but make install refuses to install saying 5.5
> conflicts with 4.1, run
> pkg_delete for 4.1.
> pkg_delete for 4.1 refuses to deinstall as all the php52 packages
> (extensions, m
I could install FreeBSD 6.4 on a virtual machine, replace the data dir
and run mysqldump from there.
Thank you for your help!
L
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
___
fr
On 26 March 2011 21:40, Laszlo Nagy wrote:
>
> There is nothing in /var/log/messages.
>>>
>>> It was working with 4.1 server, but I just uninstalled that (because
>>> the upgrading faq told me to install 4.0 instead.)
>>>
>> Do you have the following in your "/etc/rc.conf" file:
>>
>>mys
On Sat, 26 Mar 2011 18:56:03 -0400
Fbsd8 articulated:
> Laszlo Nagy wrote:
> >
> >> Sounds like you'll have to do some debugging. Try adding
> >> --verbose to mysql_args in /etc/rc.conf, and see the other advice
> >> in http://dev.mysql.com/doc/refman/4.1/en/starting-server.html
> >
> > gw# /u
Laszlo Nagy wrote:
Sounds like you'll have to do some debugging. Try adding --verbose to
mysql_args in /etc/rc.conf, and see the other advice in
http://dev.mysql.com/doc/refman/4.1/en/starting-server.html
gw# /usr/local/bin/mysqld_safe --verbose
Starting mysqld daemon with databases from /v
Sounds like you'll have to do some debugging. Try adding --verbose to
mysql_args in /etc/rc.conf, and see the other advice in
http://dev.mysql.com/doc/refman/4.1/en/starting-server.html
gw# /usr/local/bin/mysqld_safe --verbose
Starting mysqld daemon with databases from /var/db/mysql
STOPPING
There is nothing in /var/log/messages.
It was working with 4.1 server, but I just uninstalled that (because
the upgrading faq told me to install 4.0 instead.)
Do you have the following in your "/etc/rc.conf" file:
mysql_enable="YES"
Yes. I'm in the process of installing FreeBSD 6.4 i
On Sat, 26 Mar 2011 20:21:08 +0100
Laszlo Nagy articulated:
> On 2011-03-26 18:41, John Levine wrote:
> > In article<4d8e1e4a.5000...@shopzeus.com> you write:
> >> Hi,
> >>
> >> I have an old backup from a MySQL data directory. It was created
> >> with MySQL version 3. If I install MySQL 4 then
Starting mysql.
gw# /usr/local/etc/rc.d/mysql-server status
mysql is not running.
gw#
There is nothing in /var/log/messages.
Sounds like you'll have to do some debugging. Try adding --verbose to
mysql_args in /etc/rc.conf, and see the other advice in
http://dev.mysql.com/doc/refman/4.1/en/s
On 2011-03-26 18:41, John Levine wrote:
In article<4d8e1e4a.5000...@shopzeus.com> you write:
Hi,
I have an old backup from a MySQL data directory. It was created with
MySQL version 3. If I install MySQL 4 then I get this message telling
that the table was created with a different MySQL version
Quick glance
/usr/ports/databases/mysql323-server/
65 .if ${OSVERSION} >= 70
66 IGNORE= obsolete and does not build with gcc4.2; use mysql 5 or later
67 .endif
Get FreeBSD-6x installed somewhere and mysql port SHOULD compile and run.
On Sat, Mar 26, 2011 at 7:11 PM, Laszlo Nagy wro
In article <4d8e1e4a.5000...@shopzeus.com> you write:
>
>Hi,
>
>I have an old backup from a MySQL data directory. It was created with
>MySQL version 3. If I install MySQL 4 then I get this message telling
>that the table was created with a different MySQL version.
You should be able to restore t
Quoth Gary Kline on Friday, 04 March 2011:
✂ snip ✂
> it into my www/data/blog/* and extract. My proposed site is
> titled "...And miles to go before I sleep"; the blog directory
> is, literally "blog". (I posted a question on the forum about
> where to change the autho
[Just a top post to say that recent troubles of unknown cause on
my server --7.3-- have drained time from my thought of joining
the "Blogger World."]
On Fri, Mar 04, 2011 at 09:09:20AM -0800, Chip Camden wrote:
> Quoth Chad Perrin on Friday, 04 March 2011:
> > On Fri, Mar
Quoth Chad Perrin on Friday, 04 March 2011:
> On Fri, Mar 04, 2011 at 07:27:44AM -0800, Chip Camden wrote:
> >
> > I have not had a lot of luck with upgrading from within the admin panel,
> > but it is still easy to upgrade by downloading the latest tarball and
> > simply extracting it over the in
On Fri, Mar 04, 2011 at 07:27:44AM -0800, Chip Camden wrote:
>
> I have not had a lot of luck with upgrading from within the admin panel,
> but it is still easy to upgrade by downloading the latest tarball and
> simply extracting it over the installation. Then go into the admin panel
> to see if
Quoth Zbigniew Szalbot on Friday, 04 March 2011:
> Hello,
>
> > Thanks duly noted to everyone. I was beginning to wonder if I
> > had lost what mind I've got left! Not used to losing my two trial
> > blog, (1), and beyond that, being dumbfounded at how messy it
> > ma
Hello,
> Thanks duly noted to everyone. I was beginning to wonder if I
> had lost what mind I've got left! Not used to losing my two trial
> blog, (1), and beyond that, being dumbfounded at how messy it
> may be to keep WP "current." (2)
It seems to me you are maki
On Thu, Mar 03, 2011 at 02:34:56PM -0500, Michael J. Kearney wrote:
> Wordpress install ftw
>
> I created a new database manually
>
> Http://www.inverselog.info
>
> John D Jones III wrote:
>
>
> On 03/01/2011 03:50 PM, Gary Kline wrote:
> > On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn
Wordpress install ftw
I created a new database manually
Http://www.inverselog.info
John D Jones III wrote:
On 03/01/2011 03:50 PM, Gary Kline wrote:
> On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote:
>> On 3/1/11 3:53 PM, Gary Kline wrote:
>>>
>>> Any clues why I get a one-
On 03/01/2011 03:50 PM, Gary Kline wrote:
On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote:
On 3/1/11 3:53 PM, Gary Kline wrote:
Any clues why I get a one-liner from wordpress that my database
extention is missing? I re-installed everything; it is running.
Th
On Tue, Mar 01, 2011 at 08:35:25PM -0300, Rodrigo Gonzalez wrote:
> you just need to delete them from /usr/local/etc/php/extensions.ini
>
> mysql extension is loaded when you are using cli, I would check at web server
> module.
>
> Create a file called info.php in your document root
>
> then go
On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote:
> On 3/1/11 3:53 PM, Gary Kline wrote:
> >
> > Any clues why I get a one-liner from wordpress that my database
> > extention is missing? I re-installed everything; it is running.
> > The "wordpress" db is there when I check '
you just need to delete them from /usr/local/etc/php/extensions.ini
mysql extension is loaded when you are using cli, I would check at web server
module.
Create a file called info.php in your document root
then go to http:///info.php
Check if there is a block called mysql
Regards
Rodrigo
On
On Tue, Mar 01, 2011 at 06:22:13PM -0300, Rodrigo Gonzalez wrote:
> And enabled
>
> php -m
>
> check that mysql extension is loaded
>
> Regards
>
> Rodrigo
Hmmm. Good one! ... well, maybe. I have no idea why PHP
Startup can't load these libraries.
PHP Warning: PHP Star
And enabled
php -m
check that mysql extension is loaded
Regards
Rodrigo
On Tuesday, March 01, 2011 06:03:13 PM Glenn Sieb wrote:
> On 3/1/11 3:53 PM, Gary Kline wrote:
> > Any clues why I get a one-liner from wordpress that my database
> > extention is missing? I re-installed everyth
On 3/1/11 3:53 PM, Gary Kline wrote:
>
> Any clues why I get a one-liner from wordpress that my database
> extention is missing? I re-installed everything; it is running.
> The "wordpress" db is there when I check 'show database'. What
> else?
Check and make sure the MyS
Jerry ha scritto:
I have seen it posted here and on the Dovecot forum that upgrading to
mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot.
Fixed.
--
Alex Dupre
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listi
On Wed, Jan 5, 2011 at 10:09 PM, Jerry wrote:
> On Wed, 5 Jan 2011 15:37:38 +0300
> Odhiambo Washington articulated:
>
> > On Wed, Jan 5, 2011 at 2:49 PM, Jerry
> > wrote:
> >
> > > I have seen it posted here and on the Dovecot forum that upgrading
> > > to mysql-5.5.8 on FreeBSD breaks both Po
On Wed, 5 Jan 2011 15:37:38 +0300
Odhiambo Washington articulated:
> On Wed, Jan 5, 2011 at 2:49 PM, Jerry
> wrote:
>
> > I have seen it posted here and on the Dovecot forum that upgrading
> > to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot.
> > Apparently reverting to the mysql-clien
On Wed, Jan 5, 2011 at 2:49 PM, Jerry wrote:
> I have seen it posted here and on the Dovecot forum that upgrading to
> mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently
> reverting to the mysql-client-5.5.7 corrects this problem.
>
> Can any one else confirm this or is this simpl
30.12.2010 14:23, Odhiambo Washington wrote):
I am seeing a problem I am unable to solve after upgrading from 5.5.7 ->
5.5.8.
I am installing Request Tracket and I get the following error (which is in
no way related to RT, I think):
Character set 'latin1' is not a compiled character set and is
Oops, forgot the reply-all. :X Sorry Bill. :)
I ran the update two nights ago, and it went rather smoothly for me
(updating from the 5.5.7 RC to 5.5.8 GA), but your mileage may vary.
Additionally, you can find some general rules for updating your MySQL
install here: http://dev.mysql.com/doc/r
In response to Odhiambo Washington :
> On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys wrote:
>
> > I read this in /usr/ports/UPDATING today:
> >
> > =
> > 20101227:
> > AFFECTS: users of databases/mysql55-server
> > AUTHOR: a...@freebsd.org
> >
>
On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys wrote:
> I read this in /usr/ports/UPDATING today:
>
> =
> 20101227:
> AFFECTS: users of databases/mysql55-server
> AUTHOR: a...@freebsd.org
>
> MySQL 5.5 has been updated to 5.5.8 GA release. Since
Michael Powell wrote:
> m.anis wrote:
>
>> Please help, mysql can't running
>> i had installed it and using phpmyadmin
>> when i check /etc/rc.d/mysql-server status
^
This indicates to me that you just unzipped a tarball and did ./configure &&
make &&
m.anis wrote:
> Please help, mysql can't running
> i had installed it and using phpmyadmin
> when i check /etc/rc.d/mysql-server status
> it says mysql is not running
phpMyAdmin will not work until you have configured config.inc.php correctly.
> when i tried /usr/local/bin/mysqld_safe &
> startt
>>
>
> hei i just restart my system and it goes well
> but i still don't know why
> thanks for all your answer
>
> --
> --
Hi
You dont need restart your system just type rehash.
Check on the handbook;
Note: Some shells keep a cache of the commands that are available in
the directories listed in
On Tue, Mar 23, 2010 at 11:12 AM, m.anis wrote:
> On 23/03/2010 22:32, Alejandro Imass wrote:
>>
>> On Tue, Mar 23, 2010 at 10:45 AM, m.anis wrote:
>>
>>>
[..]
> /tmp/mysql.sock
I think that is created in the fly is you are using unix sockets. I
think it depends on your my.cnf configuration (l
On 23/03/2010 22:32, Alejandro Imass wrote:
On Tue, Mar 23, 2010 at 10:45 AM, m.anis wrote:
Please help, mysql can't running
i had installed it and using phpmyadmin
when i check /etc/rc.d/mysql-server status
it says mysql is not running
when i tried /usr/local/bin/mysqld_safe&
startting mys
On 23/03/2010 22:32, Alejandro Imass wrote:
On Tue, Mar 23, 2010 at 10:45 AM, m.anis wrote:
Please help, mysql can't running
i had installed it and using phpmyadmin
when i check /etc/rc.d/mysql-server status
it says mysql is not running
when i tried /usr/local/bin/mysqld_safe&
startting mys
On Tue, Mar 23, 2010 at 10:45 AM, m.anis wrote:
> Please help, mysql can't running
> i had installed it and using phpmyadmin
> when i check /etc/rc.d/mysql-server status
> it says mysql is not running
> when i tried /usr/local/bin/mysqld_safe &
> startting mysqld daemon with database from /var/db/
I thought mysql is controlled from /usr/local/etc/rc.d/mysql-server. At
least that is what I have. I am running FreeBSD 8.0, 7.x and some 6.x and
5.5 and all are the same. It runs!
You need some lines in /etc/rc.conf to make the syatem start mysql server!
On Tue, Mar 23, 2010 at 6:24 PM, Jorge Bi
On Tue, Mar 23, 2010 at 4:15 PM, m.anis wrote:
> Please help, mysql can't running
> i had installed it and using phpmyadmin
> when i check /etc/rc.d/mysql-server status
> it says mysql is not running
if you installed it from ports you must have and use
/usr/local/etc/rc.d/mysql start|stop
and o
Hello.
WHat version of Freebsd are you using?
I hacve the same issue in a recnet installed and updated Freebsd 7.3
At 09:15 a.m. 23/03/2010, you wrote:
Please help, mysql can't running
i had installed it and using phpmyadmin
when i check /etc/rc.d/mysql-server status
it says mysql is not runnin
surely, pkgdb. not pkg_db. I have misspelled.
2010/3/8 Polytropon
> On Mon, 8 Mar 2010 15:52:29 +0300, Антон Клесс
> wrote:
> > # pkg_db -F
> > - that will auto-fix versions collisions between dependencies - it may
> help
> > you.
>
> I'm sure you need the command "pkgdb -F" (without underscore
On Mon, 8 Mar 2010 15:52:29 +0300, Антон Клесс wrote:
> # pkg_db -F
> - that will auto-fix versions collisions between dependencies - it may help
> you.
I'm sure you need the command "pkgdb -F" (without underscore)
here; for automated run, use "pkgdb -aF". Note that pkgdb
program is part of the p
# pkg_db -F
- that will auto-fix versions collisions between dependencies - it may help
you.
2010/3/8 n dhert
> MySQL and Postgresql appear in the freebsd with many different versions.
> Normally ports have only one version (the latest) and you upgrade with
> portupgrade.
>
> Sometimes a mysql-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/03/2010 12:23:04, n dhert wrote:
> MySQL and Postgresql appear in the freebsd with many different versions.
> Normally ports have only one version (the latest) and you upgrade with
> portupgrade.
>
> Sometimes a mysql-client or postgresql-client
On Mon, Feb 01, 2010 at 09:13:40PM -0600, John typed:
>
> Good job, Mike! You nailed it, though what some of the other helpful
> folks wrote had me on the right path, too. For some reason, the
> binary-configure after the pkg_add left everything owned by
> root:wheel. "cd /mysql ; chown -R mys
On Sun, Jan 31, 2010 at 11:35:22PM -0500, Michael Powell wrote:
> John wrote:
>
> > If this isn't the right list - if I should try another let me know -
> > but since this is the mysql-server-5.4.2 package, and since you
> > folks have been so helpful, I thought I'd give it a go.
> >
> > Anyway,
On 01/02/2010 5:34 π.μ., John wrote:
> If this isn't the right list - if I should try another let me know -
> but since this is the mysql-server-5.4.2 package, and since you
> folks have been so helpful, I thought I'd give it a go.
>
> Anyway, the system is 8.0-RELEASE and that package is installed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John wrote:
> If this isn't the right list - if I should try another let me know -
> but since this is the mysql-server-5.4.2 package, and since you
> folks have been so helpful, I thought I'd give it a go.
>
> Anyway, the system is 8.0-RELEASE and th
John wrote:
> If this isn't the right list - if I should try another let me know -
> but since this is the mysql-server-5.4.2 package, and since you
> folks have been so helpful, I thought I'd give it a go.
>
> Anyway, the system is 8.0-RELEASE and that package is installed,
> and I can't start t
In the last episode (Jan 31), John said:
> If this isn't the right list - if I should try another let me know - but
> since this is the mysql-server-5.4.2 package, and since you folks have
> been so helpful, I thought I'd give it a go.
>
> Anyway, the system is 8.0-RELEASE and that package is inst
On Sun, Jan 31, 2010 at 9:34 PM, John wrote:
> If this isn't the right list - if I should try another let me know -
> but since this is the mysql-server-5.4.2 package, and since you
> folks have been so helpful, I thought I'd give it a go.
>
> Anyway, the system is 8.0-RELEASE and that package is
OK Thanks again, still having problems with setting the root password.
There is no my.cnf file
Matthew Seaman-2 wrote:
>
> jaymax wrote:
>
>> Post installation SNAFUS
>>
>
>
>> [iv] /usr/local/bin/mysqladmin -u root password ==>
>> ax# /usr/local/bin/mysqladmin -u
jaymax wrote:
Post installation SNAFUS
[i] support-files/mysql.server are apparently in "/usr/local/share/mysql" am
I correct, all of them?
Yes, except that mysql-server is the rc.subr(8) script to start up mysql on
boot, and that is to be found in /usr/local/etc/rc.d/
To the mysql init script, I added:
# REQUIRE: dhclient
And to the dhclient init script I added:
# REQUIRE: NETWORKING
In addition to changing DHCP to SYNCDHCP in rc.conf, mysql now starts up
on boot. I would think the dhclient change should be required in the
default setup since NETWORKING
On Wed, Jan 6, 2010 at 11:20 AM, Dário P. wrote:
> Qua, 2010-01-06 às 18:03 +0100, Samuel Martín Moro escreveu:
>> About apache, maybe it's the ServerName option that's missing.
>
> I don't think so, because I have it on httpd.conf.
>
> #
> # ServerName gives the name and port that the server uses
Qua, 2010-01-06 às 18:03 +0100, Samuel Martín Moro escreveu:
> About apache, maybe it's the ServerName option that's missing.
I don't think so, because I have it on httpd.conf.
#
# ServerName gives the name and port that the server uses to identify
itself.
# This can often be determined automatic
About apache, maybe it's the ServerName option that's missing.
On Wednesday, January 6, 2010, Dário P. wrote:
> Qua, 2010-01-06 às 16:16 +, Matthew Seaman escreveu:
>> Rob wrote:
>> > Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting
>> > on boot anymore. It starts fine
Qua, 2010-01-06 às 16:16 +, Matthew Seaman escreveu:
> Rob wrote:
> > Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting
> > on boot anymore. It starts fine once the system has booted, and looking
> > at the mysql log I see:
> >
> > 100105 17:46:56 mysqld_safe Starting m
Rob wrote:
Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting
on boot anymore. It starts fine once the system has booted, and looking
at the mysql log I see:
100105 17:46:56 mysqld_safe Starting mysqld daemon with databases from
/var/db/m
ysql
100105 17:46:56 [ERROR] Can
Olivier Nicole wrote:
Hi,
I have been strugling to find the correct syntax for the mysql(1)
command to connect with SSL.
My server is accepting SSL connections:
db2: mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
2009/6/28 Matthew Seaman
> thanos trompoukis wrote:
>
>> Hi all, I am new with FreeBSD and I have a problem with mysql.
>>
>> I have 6.2Release i386
>> I am running mysql 5.0.27 and It worked perfectly until the time that I
>> formated /tmp (for some other reason)
>> and now when I am trying to
thanos trompoukis wrote:
Hi all, I am new with FreeBSD and I have a problem with mysql.
I have 6.2Release i386
I am running mysql 5.0.27 and It worked perfectly until the time that I
formated /tmp (for some other reason)
and now when I am trying to connect on mysql *I get this:*
*[r...@leonida
thanos trompoukis wrote:
> Hi all, I am new with FreeBSD and I have a problem with mysql.
>
> I have 6.2Release i386
> I am running mysql 5.0.27 and It worked perfectly until the time that I
> formated /tmp (for some other reason)
> and now when I am trying to connect on mysql *I get this:*
>
> *[
thanos trompoukis wrote:
> Hi all, I am new with FreeBSD and I have a problem with mysql.
>
> I have 6.2Release i386
> I am running mysql 5.0.27 and It worked perfectly until the time that I
> formated /tmp (for some other reason)
> and now when I am trying to connect on mysql *I get this:*
>
On Mon, 2009-04-27 at 18:49 +0200, Zbigniew Szalbot wrote:
> hello,
>
> Today I have finally upgraded my system to 7.1-RELEASE and just noticing
> that mysql process is not being shown via the top command.
>
> PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND
> 1612 root
> True, although if it's readily reproducible, it would be good to fix.
I'd be happy to test but I do not know what to do/where to start. I know
it is a permanent issue, because I even restarted the mysql server
thinking that something is wrong that it is not being shown in top but the
history rep
--On Monday, April 27, 2009 11:49:55 -0500 Zbigniew Szalbot
wrote:
hello,
Today I have finally upgraded my system to 7.1-RELEASE and just noticing
that mysql process is not being shown via the top command.
PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND
1612 root
On Apr 27, 2009, at 10:33 AM, Zbigniew Szalbot wrote:
Ah-- I've heard rumors that top or something doesn't handle
accounting
for CPU time used by multithreaded processes very well...
OK. Well I have never had any problem with that on FreeBSD 7.0-
RELEASE. It
started misbehaving today right a
> Ah-- I've heard rumors that top or something doesn't handle accounting
> for CPU time used by multithreaded processes very well...
OK. Well I have never had any problem with that on FreeBSD 7.0-RELEASE. It
started misbehaving today right after an upgrade to 7.1-RELEASE. Like I
said, I can really
On Apr 27, 2009, at 10:22 AM, Zbigniew Szalbot wrote:
PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU
COMMAND
[ ... ]
32906 mysql 37 40 76636K 41664K sbwait 1 0:00 0.10%
mysqld
It does appear at times but it is showing 0:00 TIME. But compare it
to the
same
Hi there,
> The process is sleeping-- perhaps it isn't using enough CPU to make it
> into the list using default sort ordering? Try "top -o time",
> perhaps
No, this is a different issue. Take a look:
PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND
88268 www
Hello,
> Top doesn't show *all* processes. It shows the processes using the most
> cpu
> (by default. You can also display by io.) So, if mysqld isn't using a
> lot of
> cpu, it's not going to show up in the list. You might be able to force it
> to
> show up by giving top a number (of processe
Hi--
On Apr 27, 2009, at 9:49 AM, Zbigniew Szalbot wrote:
However, if you grep processes, you can see it should be displayed
in the
top entries.
$ ps ax |grep mysql
32880 p0- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe...
32906 p0- S 1:33.72 /usr/local/libexec/mysqld...
I can liv
On Apr 23, 2009, at 7:08 AM, Mark wrote:
I'm getting a weird compilation error (see below); hence, I figured
I skip
as much engines as possible during the compilation process. Done
with gcc 2.95.4, btw.
Really...why such an old compiler version? I think that even
FreeBSD-5.0 shipped with g
On Thu, Apr 23, 2009 at 3:59 PM, Mark wrote:
> Hello,
>
>
>
> > I'm trying to compile MySQL 5.1.34, but I can't find options to not
> >compile in innodb database support. Have these been removed?
> >And, if so, why?
> Why does it bother you? It will be built but if your tables are MyISAM type,
>
On Thu, Apr 23, 2009 at 8:31 AM, Mark wrote:
> Hello,
>
> I'm trying to compile MySQL 5.1.34, but I can't find options to not compile
>
> in innodb database support. Have these been removed? And, if so, why?
>
Can't comment on if/why the options were removed, but adding
"skip-innodb" to your my.cn
On Thu, Apr 23, 2009 at 3:59 PM, Mark wrote:
> Hello,
>
>
>
> I'm trying to compile MySQL 5.1.34, but I can't find options to not compile
>
> in innodb database support. Have these been removed? And, if so, why?
Why does it bother you? It will be built but if your tables are MyISAM type,
the I
I think 'top' is showing the external view of the process and how many
pages total of heap have been allocated (under 'RES'). Possibly your
tuner program is just showing the size of the cache specifically.
-Will
Valentin Bud wrote:
Hello community,
I have mysql installed on FreeBSD 7.0 i38
On Wednesday 08 April 2009 02:30:03 Lars Eighner wrote:
> On Tue, 7 Apr 2009, Dave Stegner wrote:
> > I am venturing into Mysql. I am trying to install it from the port,
> > 5.1.33.
> >
> > Simple question:
> >
> > Immediately after the start of make, you are presented with a list of
> > options.
On Tue, 7 Apr 2009, Dave Stegner wrote:
I am venturing into Mysql. I am trying to install it from the port, 5.1.33.
Simple question:
Immediately after the start of make, you are presented with a list of
options.
Are those options selected by entering them on the make line like:
make BUILD_
Yes. Linux threads is a port of the linux threading library
(devel/linuxthreads).
OK... this setup still seems to underperform 64 bit RHEL 5.x for at least
our setup. Unless I'm missing something. Our sites are higher traffic -
100-300 threads/connections at any given time. Perhaps that's w
On Friday 20 March 2009 10:46:20 Matt Juszczak wrote:
> > You're confusing linux-threads with pthreads. The performance boosts
> > mentioned are done using the FreeBSD Posix threads ("pthreads") library,
> > in FreeBSD 7.x they are implemented using libthr(3).
> > The benchmarks also assume you are
You're confusing linux-threads with pthreads. The performance boosts mentioned
are done using the FreeBSD Posix threads ("pthreads") library, in FreeBSD 7.x
they are implemented using libthr(3).
The benchmarks also assume you are using SCHED_ULE, rather then SCHED_4BSD.
Nothing should be configure
Matt Juszczak wrote:
Hi all,
About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).
I read at the time that the use of pthreads with FreeBSD would
significantly improve performance, but as I was running the 64 bit
version of FreeBSD, I could not use them.
Fast forward to tod
Matt Juszczak wrote:
Hi all,
About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).
I read at the time that the use of pthreads with FreeBSD would
significantly improve performance, but as I was running the 64 bit
version of FreeBSD, I could not use them.
Fast forward to tod
On Friday 20 March 2009 09:38:27 Matt Juszczak wrote:
> I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 GB
> RAM in the box) and attempt to build with pthreads enabled, as well as a
> static build and optimized compiler options. Once again, got the
> error/warning in ports t
Problem solved. What I did is:
- using Matthew's pkg_info -rx php5-mysql
- after that Aryeh's solution on the php5-mysql port
thanks for your help,
Jos
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-que
Matthew Seaman wrote:
Actually, you may only need to recompile databases/php5-mysql
(possibly plus some dependencies) and then restart apache. If your DB
is on the same machine as where you're running phpMyAdmin, then you
will have the 5.0.77 client libraries already installed and
recompiling
1 - 100 of 501 matches
Mail list logo