I got an "interesting" problem with creation of indexes on MyISAM
tables in MySQL 5.6.15 and MySQL 5.6.14 running on FreeBSD 8.4 for float
columns - I am not able to create indexes on these columns
Indexes on all other columns work just fine
The problem occur while I was loading data
In the last episode (Mar 17), PengXiaoxun said:
> The official support for freebsd 7.0 has been out of date since May 2009.
> So I update to the latest version is 8.0. However, I just found the mysql
> for freebsd 7.0. How can I get the mysql version for freebsd 8.0? Does
> it e
The official support for freebsd 7.0 has been out of date since May 2009. So I
update to the latest version is 8.0. However, I just found the mysql for
freebsd 7.0. How can I get the mysql version for freebsd 8.0? Does it exist?
I have problem at my replicated slaves. We have one master and 5 slaves. All of
its live in similar FreeBSD 7.0 systems. But by without understood for me
reasons 4 of 5 slaves are rebooted approximately one time at 30 minutes. There
are no signals and other reasons in logs. But one of slaves
Hi, this is my first time installing the MySQL server. I have built
and installed the databases/mysql60-server via the FreeBSD ports
system (using default configuration options). But let me discuss my
installation procedure, adopted from the manual:
The mysql group and user are already added by
ery thing without any issues.
The server is running FreeBSD 7.0-RELEASE #0 amd64 with an unchanged
kernel and mysql-server-5.0.45_1 installed from ports.
If anyone has any idea what caused this or steps I should take to
prevent it happening again I'd be eternally grateful.
Thanks.
-Stut
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
Hi all !
VeeJay wrote:
[[...]]
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (
use ports please.
On Tue, May 27, 2008 at 11:57 AM, kalin m <[EMAIL PROTECTED]> wrote:
> hi all.. i cant see a package
> for freebsd 7 on the mysql site. which onw should i build 6 or 5.1?
>
> thanks...
>
> --
> MySQL General Mailing List
> For list archives: htt
Hi
I am just wondering if anyone is running MySQL Database on a fairly busy
Website running on FreeBSD AMD64 7-stabble with PHP+Apache?
I am going to build a server for couple of websites having traffic 5 million
per month...
Any comments?
--
Thanks!
BR / vj
Hi
SO= FreeBSD 6.3
Ports Instalation. Version 5.0.51a
Im install mysql but mysqlmanager dont exist and mysql_multi to.
I update the Makefile with option.
--with-mysqlmanager
But doesnt work, it doesnt appear. I dont understand whats going on
Have you checked this?
http://www.slideshare.net/sim303/7020-preview/
http://www.freebsd.org/features.html
On Jan 22, 2008 4:05 AM, Mikhail Berman <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Is anyone has experience running MySQL 5.0.41 on FreeBSD 7.0-RC1 AMD64?
>
> I
Hi everyone,
Is anyone has experience running MySQL 5.0.41 on FreeBSD 7.0-RC1 AMD64?
If you do would you be able to comment on MySQL performance, possible
advantages and problems?
Regards,
--
Mikhail Berman
Running on our systems, we have had the replica load data and then
started. The longest delta was about 28 hours behind the master. The
slave status faithfully reported how far behind the master it was, when
the slave was started, even as it was loading its relay-logs from the
master which
Christopher E. Brown wrote:
On Sat, 3 Nov 2007, bob b wrote:
So, a slave is down for 8hrs. It comes online and pulls the binlog in
120 seconds. The "seconds behind master" does not reflect 8hrs, but how
many seconds (at current processing rate) before the slave finishes the
relay logs.
Th
On Sat, 3 Nov 2007, bob b wrote:
Good to hear that you found the problem.
The only remaining puzzle is why the replica reported that it was up to date
when it was several binlogs behind.
Possibly the replica was always caught up with the last entry from the very
slow link.
Perhaps you shoul
An update for those actually paying attention.
I have been fighing unusual performance issues with replication between
FreeBSD 6.2 machines.
The unusual part is that while replication would never top 10 writes per
second (even while the master was taking hundres of writes per second),
the
10:06:19 Ray wrote:
>> I am trying to debug another application and I need to enable logging of
>> all queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
>> installed from ports.
>--
>Regards
>Michael Cole
--
MySQL General Mailing List
For list a
:19 Ray wrote:
> I am trying to debug another application and I need to enable logging of
> all queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
> installed from ports.
--
Regards
Michael Cole
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hello,
I am trying to debug another application and I need to enable logging of all
queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL
installed from ports.
any Instructions, or pointers to documentation would be appreciated.
Thanks,
Ray
--
MySQL General Mailing List
For
Ronan Lucio wrote:
>
> Graham,
>
> > I was under the impression that in FreeBSD 5, you didn't need to change
> > the kernel, just the entry in /boot/loader.conf...
>
> Even if you use kern_securelevel="1"?
>
> Ronan
>
I'm running
kern.sec
Graham,
I was under the impression that in FreeBSD 5, you didn't need to change
the kernel, just the entry in /boot/loader.conf...
Even if you use kern_securelevel="1"?
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
MAXDSIZ=(1536UL*1024*1024)
>
> for MySLQ can you up to 1,5 Gb of RAM memory.
>
> I realy don´t know if it will solve your problem, but, if MySQL
> is tring to use more RAM memory than the permited, it seems
> to be the case.
>
> Ronan
>
I was under the impression that in
Graham,
/usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes)
when dumping table `Attachments` at row: 24285
Did you changed the values of MAXDSIZ in the kernel file?
I use this:
options MAXDSIZ=(1536UL*1024*1024)
for MySLQ can you up to 1,5 Gb of RAM memory.
I r
Gerald L. Clark wrote:
> Graham Dunn wrote:
>> The error:
>>
>> /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes)
>> when dumping table `Attachments` at row: 24285
>>
>> Platform details:
>>
>> Client:
>>
>> mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386)
>>
Graham Dunn wrote:
The error:
/usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes)
when dumping table `Attachments` at row: 24285
Platform details:
Client:
mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386)
# /usr/local/bin/mysqldump -u dba -h seisei -p rt3
=max_allowed_packet=256M Attachments > Attachments.sql
Server:
FreeBSD seisei.mydomain.net 5.3-RELEASE-p9 FreeBSD 5.3-RELEASE-p9
mysql-server-4.0.24_1 (from ports)
I have
kern.maxdsiz="751619277" #750 MB
kern.dfldsiz="751619277"
kern.maxssiz="134217728" #
On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote:
> I trying to run MySQL and Apache under a chroot envoirnment. But I am
> getting these errors.
[ ... ]
> # /usr/local/mysql/libexec/mysqld: Can't create/write to file
> '/var/tmp/ibPM3e0d' (Errcode: 13)
[ ... ]
> fopen: Operation not supp
Hello there
I was wondering if someone having great knowledge of FreeBSD chroot system
could give me some help. I trying to run MySQL and Apache under a chroot
envoirnment. But I am getting these errors. Could you please help me to
solve these problems. I have googled a lot but did't fin
Daniel Kasak wrote:
> VeeJay wrote:
>> Where one can find Source Distribution of MySQL Server 5.0 Standard for
>> FreeBSD?
>
> Not on the website, that's for sure.
> Have you tried the usual warez sites, p2p networks, etc?
Really? Seems pretty straightforward t
On Thursday 14 December 2006 14:37, Bruce Ferrell wrote:
> >> Where one can find Source Distribution of MySQL Server 5.0 Standard for
> >> FreeBSD?
> >
> > Not on the website, that's for sure.
> > Have you tried the usual warez sites, p2p networks, etc?
Daniel Kasak wrote:
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download site.
--
One d
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
--
Thanks!
BR / vj
Heya!
This fixed it for me, I didn't set kern.threads.max_groups_per_proc: earlier.
What is the max threads can FreeBSD go for?
Thanks,
-A
- Original Message
From: Ken Menzel <[EMAIL PROTECTED]>
To: Abdullah Ibn Hamad Al-Marri <[EMAIL PROTECTED]>; mysql@lists.mys
Have a look at kern.threads.max_threads_per_proc: 1500
and kern.threads.max_groups_per_proc: 1500
You are probably hitting one of these sysctl's. Here is a link to
some other info
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2006-01/msg2.html
There is also a wi
Hello folks,
I hope Greg is reading this list
I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading.
I have a huge app makes alot of connections to MySQL server.
The max I could reach is 1500 threads, even I made the max connection in my.cf
5k and I used
Hello folks,
I hope Greg is reading this list
I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading.
I have a huge app makes alot of connections to MySQL server.
The max I could reach is 1500 threads, even I made the max connection in my.cf
5k and I used
On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote:
> At 09:15 AM 7/14/2006, Jeremiah Foster wrote:
> >Nearly once or twice a day the mysql daemon on our FreeBSD server has to
> >be restarted since it is taking up most of the processor.
> >
> >That is about 3 hours
At 09:15 AM 7/14/2006, Jeremiah Foster wrote:
Hello,
Nearly once or twice a day the mysql daemon on our FreeBSD server has to
be restarted since it is taking up most of the processor.
One of the entries in our slow_queries log looks like this;
# Query_time: 14074 Lock_time: 0 Rows_sent: 11
Hello,
Nearly once or twice a day the mysql daemon on our FreeBSD server has to
be restarted since it is taking up most of the processor.
One of the entries in our slow_queries log looks like this;
# Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined:
1020472928
SELECT pp.art_num
wrote:
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared over NFS. It only seems to happen
with very frequently written-to tables. I sent this to the list last
week and
(My comments are at the bottom)
Greg Lehey wrote:
On Monday, 26 June 2006 at 10:41:16 -0400, [EMAIL PROTECTED] wrote:
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared
TED] wrote:
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared over NFS. It only seems to happen
with very frequently written-to tables. I sent this to the list last
week
using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
reside on a NetApp NAS share shared over NFS. It only seems to happen
with very frequently written-to tables. I sent this to the list last
week and no one responded. ***
Hi, I was
On Monday, 26 June 2006 at 10:41:16 -0400, [EMAIL PROTECTED] wrote:
> *** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
> recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files
> reside on a NetApp NAS share shared over NFS. It only seems to happen wi
*** This happens for me using FreeBSD 6.0 or FreeBSD 6.1 with the most
recent MySQL 4.1 or 5.0 built from ports and when the DBMS data files reside on
a NetApp NAS share shared over NFS. It only seems to happen with very
frequently written-to tables. I sent this to the list last week and no
Hi, I was wondering if anyone else had encountered this issue and/or come
up with what needs to be done to resolve it:
I currently have MySQL 5.0.22 built from ports on a FreeBSD 6.1 machine
with the DB data residing on a NetApp share connected via NFS. A strange
thing happens often after a
kalin mintchev wrote:
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
/usr/ports/databases/mysql50-server/
/usr/ports/databases/mysql51-server/
I s
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Re: MySQL 4.1.18 Client - FreeBSD Build
On Thu, 2006-02-23 at 09:28 -0800, Don O'Neil wrote:
> Where are the client libraries and such for the FreeBSD 4.x Build of
> MySQL 4.1.18? I downloaded the MAX binary yesterday, and tried to
> install it, but none of the libmysqlclient
On Thu, 2006-02-23 at 09:28 -0800, Don O'Neil wrote:
> Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
> 4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
> none of the libmysqlclient files are present in the distribution.
>
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
je killen wrote:
Is there a version of MySQL for FreeBSD v6.0 AMD64 compatible? I
haven't seen one explicitly on the MySQL site
and I don't know if it is a good idea to try and compile and install
from source code for this machine.
Install mysql from FreeBSD ports collection. I'
Is there a version of MySQL for FreeBSD v6.0 AMD64 compatible? I
haven't seen one explicitly on the MySQL site
and I don't know if it is a good idea to try and compile and install
from source code for this machine.
Thanks
JK
--
MySQL General Mailing List
For list arch
Just throwing this out there for the archives.
Installing 5.0.17 MySQL Client on a FreeBSD VPS2 Virtual server from
Verio kept throwing an error looking for zlib.la in the zlib library.
This system didn't have a system wide zlib installed, so the bundled
library kept trying to be used in
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.c
On Tue, 23 Aug 2005, Jeremiah Gowdy wrote:
The limit you are running into is the maxdsiz or max data size for a process.
It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your
kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting
kern.ma
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.c
SUMMARY
While I am fairly certain the problem is with FreeBSD, since this is
InnoDB/MySQL related, I thought I would post here to see if others have had
this problem. I have googled several different phrases to find this answer
-- how does FreeBSD 5 set resource limits, and how do I override
the kernel maintains for kernel and other code to be mapped into. It
is adjustable, for better or for worse.
In FreeBSD, look in /boot/defaults/loader.conf and you'll see kern.maxdsiz.
If you have 4GB of ram, you can probably get away with setting this to 3GB.
You can expirement wit
d page that talked about this was,
>
> http://www.oracle-base.com/articles/Linux/LargeSGAOnLinux.php
>
> Good luck.
>
> David
>
> Jeff Smelser wrote:
>
> >On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
> >
> >
> >>Have any of you MySQL/FreeB
Hi,
i don't think so. 2 go is a limit of almsot 32-bits plateform, linux or others.
Migrate to 64-bits.
Mathias
Selon Brady Brown <[EMAIL PROTECTED]>:
> Have any of you MySQL/FreeBSD cats successfully set
> innodb_buffer_pool_size > 2G without runing into any of the memory
&
.
A good page that talked about this was,
http://www.oracle-base.com/articles/Linux/LargeSGAOnLinux.php
Good luck.
David
Jeff Smelser wrote:
On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
Have any of you MySQL/FreeBSD cats successfully set
innodb_buffer_pool_size > 2G without
On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
> Have any of you MySQL/FreeBSD cats successfully set
> innodb_buffer_pool_size > 2G without runing into any of the memory
> allocation problems found on Linux platforms?
It has nothing to do with linux.. its an x86 thing.. So no.
Have any of you MySQL/FreeBSD cats successfully set
innodb_buffer_pool_size > 2G without runing into any of the memory
allocation problems found on Linux platforms?
Although I have been given good advice to migrate to an AMD platform
overcome this limitation (and will do so eventually), I
huang leo 写道:
> hi,everyone,
> I just did a test to find out the MySQL4.1.12 max connections on
> FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the
> MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB
> memory. The second test, I setted the MAXSS
hi,everyone,
I just did a test to find out the MySQL4.1.12 max connections on FreeBSD
5.4 Release and FreeBSD 4.11 Release.
The first test, the MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because
I have 1GB memory. The second test, I setted the MAXSSIZ=1GB, and the
MAXDSIZ is also 1GB. The
ysql.com
Subject: Re: What is best open-source platform alternative to overcome
innodb 2Gb memory limit on Linux? FreeBSD?
Why not go AMD-64? Dual Opteron, with 8/16/32 gig of RAM? Get a 3ware
SATA drive, and run Gentoo for AMD-64. You can increase your innodb
buffer pool to use almost all that spac
desires (or at least well
beyond 2Gb).
Do any of you have battle-tested recommendations?
How about FreeBSD? From what I can gather, it is a good idea to build
MySQL on FreeBSD linked with the Linux Thread Library. Would doing so
re- invoke the 2Gb limit?
I look foward to your collective responses
scale the application, so I need an
alternative solution that will allow me to set innodb_buffer_pool_size
as high as my heart desires (or at least well beyond 2Gb).
Do any of you have battle-tested recommendations?
How about FreeBSD? From what I can gather, it is a good idea to build
MySQL
We've been using mysql version 4.7 on a FreeBSD 4.10 machine for the
past few months, and while we've been putting a lot of load onto the
DB, it's been stable. This past weekend, our sysadmin updated FreeBSD
from 4.10 to 4.11, at which point mysql began having serious problems.
T
>Description:
I am using MySQL 5.x on FreeBSD 5.4-PRE together
with libpthread. These are the knobs I did provide
to make (to compile the actual FreeBSD port):
FORCE_PKG_REGISTER=yes \
WITH_OPENSSL=yes \
BUILD_OPTIMIZED=yes \
WITH_PROC_SCOPE_PTH=yes
If executing the following SQL query, mys
In the last episode (Mar 04), Chip Wiegand said:
> I made a change to my.cnf and want it to restart mysqld_safe so it
> will re-read my.cnf. How do I do this?
/usr/local/etc/rc.d/mysql-server.sh restart
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list arch
Someone else may have to chime in, but I think this will work:
mysqladmin -u root -p refresh
According to the help "refresh" will Flush all tables and close and
open logfiles. You may have to try it. Worst case just issue a
shutdown and then start it up again.
Scott
Chip Wiegand wrote:
I made a
I made a change to my.cnf and want it to restart mysqld_safe so it will
re-read my.cnf. How do I do this?
Thanks,
Chip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Use -U --force --nodeps options.
sam wun <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have installed the server and started up successfully. mysql.sock file
> is written to /var/lib/mysql/ directory as well.
> Now I found that I also need to install mysql 4.10-1 client. However
>
Hi,
I have installed the server and started up successfully. mysql.sock file
is written to /var/lib/mysql/ directory as well.
Now I found that I also need to install mysql 4.10-1 client. However
there is already mysql3 installed in the system. How can I remove the
old version in Redhat?
Here are
sam wun wrote:
Gleb Paharenko wrote:
Hello.
I used the following command backup database:
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
--quote-names --opt
I don't think this command backup user account info.
If you add --all-databases option it would also dump the
Gleb Paharenko wrote:
Hello.
I used the following command backup database:
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
--quote-names --opt
I don't think this command backup user account info.
If you add --all-databases option it would also dump the mysql d
Hello.
> I used the following command backup database:
> mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
> --quote-names --opt
>
> I don't think this command backup user account info.
>
If you add --all-databases option it would also dump the mysql database.
I've tried to
Gleb Paharenko wrote:
Hello.
I also want to copy the user accounts in MySQL5.0 db over to MySQL4.1 in
Redhat as well.
All user accounts and rights are stored in the tables of mysql database.
And fields of grant tables in 4.1.x version just a subset of fields in
5.0.x. You should set
gt; I just fresh install mysql4.1 in Redhat9.0.
>> I have another MySQL5.0 installed in FreeBSD5.3, and just tried to
>> copy all data in /var/db/mysql/ from FreeBSD5.3 to /var/db/mysql/data/
>> in Redhat9.0.
>> After finished copied the data over to Redhat, MySQL4.1 can&
inished copied the data over to Redhat, MySQL4.1 can't start. The
> DB data in MySQL5.0 in the FreeBSD box has database and tables with indexes.
> I don't want to rebuild the entire database from scratch in Redhat, how
> can I "transfer" all db files fro
data in MySQL5.0 in the FreeBSD box has database and tables
with indexes.
I don't want to rebuild the entire database from scratch in Redhat,
how can I "transfer" all db files from FreeBSD to Redhat and in
another version of MySQL?
I also want to copy the user accounts in
.0 in the FreeBSD box has database and tables with indexes.
I don't want to rebuild the entire database from scratch in Redhat, how
can I "transfer" all db files from FreeBSD to Redhat and in another
version of MySQL?
Thanks
Sam
--
MySQL General Mailing List
For list archives: ht
cd /usr/ports/databases/mysql41-server && make install clean
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Richard C Komatz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 12:00 PM
Subject
In the last episode (Dec 01), Richard C Komatz said:
> I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
> - FreeBSD 5). I can't find any documentation on how to install for this
> system, nor can I find the binaries.
cd /usr/ports/mysql41-server ; make i
Hi There,
I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
- FreeBSD 5). I can't find any documentation on how to install for this
system, nor can I find the binaries.
Thanks for any help!!
Richard
Hi There,
I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II
- FreeBSD 5). I can't find any documentation on how to install for this
system, nor can I find the binaries.
Thanks for any help!!
Richard
determine which specific query kills the server.
Also with enabled debugging you could find more information from trace
files (note that the trace file will become very big!). Next time
send us your my.cnf file.
>Hello
>
>I have upgraded from mySQL 4.0 to mySQL 4.1 on a FreeBSD
Hello
I have upgraded from mySQL 4.0 to mySQL 4.1 on a FreeBSD 4.10 box.
The upgrade went perfectly with no warning or error messages. However,
after the mySQL server was running for a few hours, it crashed. It
restarted itself thanks to mysqld_safe. However, it keeps crashing and
restarting
is error?
Something wrong which is unclear what. comp_err syntax is broken.
The Right Way(tm) to install MySQL on FreeBSD, is use the port
/usr/ports/databases/mysql40-server
Don't forget to add -DWITH_LINUXTHREADS=yes -DBUILD_OPTIMIZED=yes
--
For technical support contracts, goto https:
Making all in sql
make all-recursive
Making all in share
../../extra/comp_err -C./charsets/ danish/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile
*** Error code 255
what's this error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
AB "-O2 -fno-strength-reduce".
> Does anyone compared this? Or it make no sense?
>
> PS. MySQL 4.x and FreeBSD 4.x
I know that mine work. :-)
I suspect you'll have a hard time finding a performance differnce
between the two unless you try really hard to measure it.
Good day.
From these sources:
http://jeremy.zawodny.com/blog/archives/000458.html
http://dev.mysql.com/doc/mysql/en/FreeBSD.html
Jeremy is using "-O -march=pentiumpro" and
MySQL AB "-O2 -fno-strength-reduce".
Does anyone compared this? Or it make no sense?
PS. MySQL
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> äÏÂÒÙÊ ÄÅÎØ.
áÇÁ, ÄÏÂÒÙÊ, but we speak english here. :)
> Usually I run configure like this:
Well I don't remember the configure options used in mysql40-server port, but
these are recommended. You just want to enable linuxthreads and buildstatic
an
same problem and everything runs great now.
Ken
- Original Message -
From: "adp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 30, 2004 2:58 PM
Subject: FreeBSD and MySQL - mysqld eats CPU alive
> I have several MySQL and FreeBSD installs across
-db \
--without-isam \
--without-innodb \
--enable-thread-safe-client
because I need koi8 charset and etc...
And I don't have any problem
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
Did you compile mysql from source or you use precompiled binary package?
I use mysql with different versions
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> Did you compile mysql from source or you use precompiled binary package?
> I use mysql with different versions of FreeBSD without big problems.
On FreeBSD, you can compile MySQL from ports.
>>> I have several MySQL and FreeBSD
1 - 100 of 625 matches
Mail list logo
