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 an
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 <[EMAI
%% 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
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
ough :-/
>
>
> P
>
>
>
>
>
> Alan Williamson <[EMAIL PROTECTED]>
> 04/06/2004 05:57 PM
>
> To: Dan Nelson <[EMAIL PROTECTED]>
> cc: [EMAIL PROTECTED]
> Subject:Re: MySQL on Linux
>
>
>
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 N
EMAIL 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
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 doesn't
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 distri
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
ab
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 ac
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 A
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, c
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 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
> 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
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 MyS
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, let's see you make one that big.
Dan.
On Tue, 6 Apr
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 http://ww
MySQL?
--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 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
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
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 my
> When I execute mysqld -u root -p
> 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
with
ls
- 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 daem
> 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
> > > I am pr
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
get mysqld daemon running.
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
> When I execute mysqld -u root -p
> 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
in starting the daemon? This is not an option, it is an
error.
http://www.
>
To: "Intrex" <[EMAIL 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.
> >
&g
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 ha
s" <[EMAIL PROTECTED]>
To: "'mysql'" <[EMAIL PROTECTED]>
Sent: 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 t
; <[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 bina
lt;[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 di
. 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, Octo
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/
__ ___ ___ __
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 n
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. O
"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
ozeman, Montana
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 3:59 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL on Linux 2.4 question
Walt,
a possible reason is that fsync is much faster in Linux-2.4 than in 2.2.
Check that the combine
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 ar
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.
Somewh
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,
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.
L
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 ker
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-serv
46 matches
Mail list logo
