On 2/24/07, Jean-Sebastien Pilon [EMAIL PROTECTED] wrote:
Hello,
I would like to get some of your input on file systems to use with
mysql. Should I use a journaling filesystem ? Should I choose a
different one based on what I store (log files, myisam dbs, innodb
datafiles, etc ) ? Is there any
%% Dan Nelson [EMAIL PROTECTED] writes:
dn That is because although Linux binaries can access files over 2gb,
dn they do not do so by default. Apache was probably not compiled
dn with the required defines (-D_LARGEFILE_SOURCE
dn -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even
Perhaps stated a bit more correctly:
Apache is NOT unique to Linux, so any system using Apache would need this
configuration, that would include windows, MAC OS, Solaris, Irix, etc.
Can't blame the OS on a softwares requirements...
Dan.
At 08:07 AM 4/9/2004, Paul Smith wrote:
%% Dan Nelson
Just to be complete, linux does have limitations depending upon
limitations of the file-system, and the kernel. All modern filesystems
(XFS, EXT3, ...) all allow files over a terabyte is size.
On Tue, 2004-04-06 at 13:39, Ronan Lucio wrote:
Uhm,
what are you talking about?!?
When I put
[EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: MySQL on Linux
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan Nelson wrote:
In the last
Nelson [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: MySQL on Linux
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan
The 2GB (not 2 Mb) file size limitation on Linux went away years ago.
Unless your distribution is very old you won't have a problem.
--Pete
On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote:
Hi All,
I always worked with MySQL on FreeBSD systems.
Now I need to install am MySQL
Uhm,
what are you talking about?!?
When I put our site on a Linux system, apache stop working when
it´s logfile get major than 2 Gb.
I was afraid of it´d happen with MySQL, too.
Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with
On Tuesday 06 April 2004 16:31, dan wrote:
Uhm,
what are you talking about?!?
Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with Mysql on a linux
system and the file is over 60 GIGS in size!
maybe you meant 2 Tb? and if you did,
nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.
it doesnt occur in vanilla distributions or any other
retail, commercial, or otherwise distribution...
well maybe Suse,
On Tuesday 06 April 2004 17:28, dan wrote:
nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.
it doesnt occur in vanilla distributions or any other
retail,
dan wrote:
the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).
Not to spoil a perfectly good pontification ... but i have to say that
we have a Redhat8 distribution running on a Dell PowerEdge Server and
when
I have had this happen on 2 boxes one running Redhat 7.2 and the other running
Redhat 8. I can tell MySQL does not like not being able to write to the file anymore.
We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing
a lot of corruption. In one instance it
Brad Tilley wrote:
On Tuesday 06 April 2004 17:28, dan wrote:
Just wanted to point out that 32 bit
systems have limitations. 2^32 = 4 billion that's the max. Addressing more space than that requires a bit of black magic.
All it takes a some arbitrary precision math. Since we are talking
In the last episode (Apr 06), Alan Williamson said:
the most popular would have been Red Hat, which doesn't have this
limit you speak of, even plain vanilla install (no twiddling
needed).
Not to spoil a perfectly good pontification ... but i have to say
that we have a Redhat8 distribution
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan Nelson wrote:
In the last episode (Apr 06), Alan Williamson said:
the most popular would have been Red Hat, which
PROTECTED]
Sent: Tuesday, April 06, 2004 4:54 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL on Linux
I have had this happen on 2 boxes one running Redhat 7.2 and the other
running Redhat 8. I can tell MySQL does not like not being able to write to
the file anymore. We were using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 5 Dec 2002, Andrew Sitnikov wrote:
after FLUSH QUERY CACHE
key_buffer_size=402649088
read_buffer_size=2093056
sort_buffer_size=2097144
max_used_connections=115
max_connections=200
threads_connected=6
It is possible that mysqld
You could set up a clustering configuration using our replication. Just
take a look at the replication section of our online docs:
http://www.mysql.com/documentation/index.html
Kerry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01,
?
--Mike
- Original Message -
From: Kerry Ancheta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, August 02, 2002 9:37 PM
Subject: RE: MySql on Linux Clustering..?
You could set up a clustering configuration using our
I should clarify that you could have a cluster of MySQL servers using our
replication. However for clustering you should consider the following:
Maybe the most powerful project in this area is Beowulf (not Linux only)
http://www.beowulf.org, but there are many such projects like:
Cplant
.
Mark
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Mysql' [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 8:14 PM
Subject: Re: mysql on Linux
When I execute mysqld -u root -p password
I am presented with the default variables.
The manual says to use safe_mysqld
try running safe_mysqld without any options
I wouldn't know why you would need to specify a user name to start the
daemon
-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 5:55 AM
To: [EMAIL PROTECTED]; 'Mysql'
Subject: Re: mysql on Linux
I know
Starting mysqld daemon with databases from /var/lib/mysql
020305 17:46:10 mysqld ended
This is written by safe_mysqld. It seems that mysqld was never started
successfully. I've had this issue before. Every time it was a
permissions issue.
When I execute mysqld -u root -p password
I am
.
Mark
Mark
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Intrex' [EMAIL PROTECTED]
Cc: Mysql [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 1:07 PM
Subject: RE: mysql on Linux
Starting mysqld daemon with databases from /var/lib/mysql
020305 17:46:10 mysqld ended
When I execute mysqld -u root -p password
I am presented with the default variables.
Which are? How about showing what mysqld --user=root displays?
Also, you see linux-bin.* files? That indicates that mysqld was running
at some point (maybe nine times). Can you get the directory listings
options are allowed. -u or --user are
valid, -p however is not listed in those options
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 3:13 PM
To: 'Intrex'
Cc: 'Mysql'
Subject: RE: mysql on Linux
When I execute mysqld -u root -p password
Today I migrated my system to RH7.1. I had been running mysql on Mandrake 7.2 but I
wanted to use the newer versions
which require kernel 2.4.x.
I experienced exactly the same problems as you with the RPM of mysql which came with
the RH distro. I looked at
everything and then some that had
Hi,
Download the binary distribution that suits your system and read the
INSTALL-BINARY file.
Also, make sure the online documentation at
http://www.mysql.com/documentation/index.html
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
. No cryptic mumbo jumbo, no PhD CRAPOLA.
I mean REALLY.
Mark
- Original Message -
From: Jorge del Conde [EMAIL PROTECTED]
To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql'
[EMAIL PROTECTED]
Sent: Tuesday, October 09, 2001 1:48 AM
Subject: RE: mysql on Linux
Hi,
Download the binary
PROTECTED]
Sent: Tuesday, October 09, 2001 1:48 AM
Subject: RE: mysql on Linux
Hi,
Download the binary distribution that suits your system and read the
INSTALL-BINARY file.
Also, make sure the online documentation at
http://www.mysql.com/documentation/index.html
Regards,
Jorge
distro
are you using, what type of hardware PPC, Intel, etc.
Scott
- Original Message -
From: Intrex [EMAIL PROTECTED]
To: Jorge del Conde [EMAIL PROTECTED]; 'Manish Mehta'
[EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 6:23 PM
Subject: Re: mysql on Linux
: Tuesday, March 05, 2002 6:54 PM
Subject: Re: mysql on Linux
Mark,
This probably won't get you the response you wanted. How about
letting
us know where you have gotten to and where things seem to be breaking. A
generalized request for what do I do often recieves little or no help.
Some
On Tue, 5 Mar 2002, Intrex wrote:
Ok.
SuSE 7.3
Digital HiNote VP745
mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
for SuSE
I have installed the .tar.gz and followed those instructions
I have
PROTECTED]
Cc: Scott Helms [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 10:59 AM
Subject: Re: mysql on Linux
On Tue, 5 Mar 2002, Intrex wrote:
Ok.
SuSE 7.3
Digital HiNote VP745
mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
Prior to completely
When I execute mysqld -u root -p password
I am presented with the default variables.
The manual says to use safe_mysqld to properly start mysqld. Also,
--user=root is clearer for that option. And, what are you doing with -p
password in starting the daemon? This is not an option, it is an
Tobias Lind - Telia Internet [EMAIL PROTECTED] writes:
Hello! I'm in the process of upgrading my Linux-server (currently a
dual P2-400MHz), and have been thinking about getting a system with
dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any
experience (good or bad) with a dual
Well, I don't have anything yet, but I've got a server in the mail
coming to me that is a dual Athlon MP 1900+. I'll be getting it either
today, or tomorrow with any luck, and I'll let you know how things go.
Gonna be running SuSE 7.3, PHP, MySQL, Apache, BIND9 and various other
packages on it.
On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote:
Our kernel people love them - Athlon goodness, no VIA chipset. Good
performance, good stability.
Note that the Via kt266a (_not_ SMP chipset) is quite good these days.
If I was building a dual-processor machine, there's no
On Thu, Jan 10, 2002 at 12:59:01AM +0200, Heikki Tuuri wrote:
Walt,
The kernel 2.4.4-SMP-64GB has been very stable on our 2-way
computer. Somewhere in about version 2.4.10 Linus changed the
virtual memory. I am not sure how stable kernels 2.4.10 - .17 are,
but at least some people are
600,000 row table?
what are you storing on that bad boy?
- Original Message -
From: Weaver, Walt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 09, 2002 2:17 PM
Subject: MySQL on Linux 2.4 question
Anyone else out there been playing with the new Linux 2.4 kernel?
Amazing! I've not had a chance to upgrade a server to
2.4 yet, though I've long imagined that the results would
be similar.
I imagine the biggest performance boost you received is
due to the built-in multi-threading that the 2.4 kernel
enjoys which is currently lacking in the 2.2 kernel.
Walt,
Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether
things are better than they were on 2.2 kernels but we're updating
tables just about that quickly I'd say. Largest table we have is a log
table which has 50 million rows in it so far. Thanks to Innodb row
locking,
Walt,
a possible reason is that fsync is much faster in Linux-2.4 than in 2.2.
Check that the combined size of your log files is 50 % - 100% of the buffer
pool size. Small log files cause more disk i/o and more fsyncs.
The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer.
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Mysql, innodb, linux problems
Bernard,
please upgrade to 3.23.47. There were several hang bugs in 3.23.39.
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http
Hi Heikki,
There is 4.xx version available. why upgrade to 3.xx version?
-- Prabhu
On Fri, 4 Jan 2002, Heikki Tuuri wrote:
Date: Fri, 4 Jan 2002 16:55:29 +0200
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Mysql, innodb, linux problems
Bernard,
please
Bernard,
please upgrade to 3.23.47. There were several hang bugs in 3.23.39.
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
Hello,
Hope it is a good place for
Hello,
As recommended I upgrade from 3.23.39 to 3.23.47
and now everything works very well
Intensive insert with simultaneous update and several simultaneous select
on the same table works perfectly on InnoDB tables
Regards
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
email:
Trond Eivind Glomsrød writes:
Robert Alexander [EMAIL PROTECTED] writes:
I know that, but I'm pretty sure sourceforge is one of their mirrors.
--
Trond Eivind Glomsrød
Red Hat, Inc.
Yes, it should be one of our mirrors.
I truly do not know whether files are exact copy.
But,
Trond Eivind =?iso-8859-1?Q?Glomsr=F8d?= writes:
Robert Alexander [EMAIL PROTECTED] writes:
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Ron Jamison writes:
Using MySQL 3.23.46 from:
http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp
Try a
Ron Jamison writes:
Hi,
I'm trying to use the available MySQL Linux Alpha binary distribution on
this AlphaServer:
Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST
2001 alpha unknown
Running RedHat 7.1 Alpha Deluxe,
Using MySQL 3.23.46 from:
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Ron Jamison writes:
Hi,
I'm trying to use the available MySQL Linux Alpha binary distribution on
this AlphaServer:
Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST
2001 alpha unknown
Running RedHat 7.1
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Ron Jamison writes:
Using MySQL 3.23.46 from:
http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp
Try a binary from our site.
The above one _is_ your site, isn't it?
--
Trond Eivind Glomsrød
Red Hat, Inc.
The
Robert Alexander [EMAIL PROTECTED] writes:
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Ron Jamison writes:
Using MySQL 3.23.46 from:
http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp
Try a binary from our site.
The above one _is_ your site,
PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL Alpha Linux binary distribution: Core dumped on
AlphaServer 1200
Sinisa Milivojevic [EMAIL PROTECTED] writes:
Ron Jamison writes:
Hi,
I'm trying to use the available MySQL Linux Alpha binary distribution
I'm seeking.
Sorry if this message gets to you twice, Trond.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Trond Eivind Glomsrød
Sent: Thursday, December 13, 2001 11:51 AM
To: Robert Alexander
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Alpha Linux binary
At 14:51 -0500 2001/12/13, Trond Eivind Glomsrød wrote:
I know that, but I'm pretty sure sourceforge is one of their mirrors.
--
Trond Eivind Glomsrød
Red Hat, Inc.
At 12:04 -0800 2001/12/13, Ron Jamison wrote:
SourceForge is indeed one of their mirrors. Robert if you look you'll see
Monty
On Wed, 25 Apr 2001, george wrote:
rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm
Better approach would be to use the update switch. rpm -Uvh
the output says:
file /usr/bin/safe_mysqld from install of mysql-3.23-36-1 conflicts with
file from package mysql-server
58 matches
Mail list logo