On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
Pros: performance and bypassing the filesystem cache.
I believe most OSes support direct file access which either bypasses or
minimizes cache effects, and InnoDB will enable it if possible.
Solaris direct file I/O performance on UFS is within a couple
I have redhat 9.0 and Server version: Apache/2.0.40.
i have installed rpms php-4.2.2-17.2.i386.rpm
php-mysql-4.2.2-17.2.i386.rpm
After i create a database called mydb and serveral tables in mysql,
I tried to run following testdb.php script
On 13 May 2004, at 4:02 pm, Jacob Friis Larsen wrote:
I'd go with Reiser on SuSE.
What about Reiser on Debian?
It shouldn't matter too much. This functionality is in the kernel, so
if the kernel version on SuSE and Debian is the same, the filesystem
code will be the same, with the possible
Does the filesystem matter as much as disk throughput? I'd imagine that
is where the bottleneck would be, at least as I've seen...
Tim Cutts [EMAIL PROTECTED]
05/13/2004 11:13 AM
To: Jacob Friis Larsen [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:
From: Jianping Zhu [mailto:[EMAIL PROTECTED]
but i got error message with:
http://coopunit.forestry.uga.edu:8080/testdb.php
the error is:
Fatal error: Call to undefined function:
mysql_connect() in /var/www/html/testdb.php on line 13
How can Fix this problem? Thanks
Hi Dirk,
from the excellent on-line manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html
Columns selected for output can be referred to in ORDER BY and GROUP BY clauses
using column names, column aliases, or column positions. Column positions are
integers and begin with 1:
mysql SELECT
Hi!
On May 12, Larry Lowry wrote:
A uniqueidentifier in MS SQL is basically a guid. I am generating
them via System.Guid.NewGuid().ToString(N) in the Dot Net
framework which now returns me a string of 32 characters (hex).
Internally I understand it is a 128-bit integer. As an option I
Hello,
thanks for your response.
The zlib-Library was already installed on the machine.
The command find / | grep zlib showed my the file zlib.h at
/usr/include/linux/zlib.h
I've update from zlib 1.1.4-105 to 1.1.4-232 and installed the
zlib-devel package too.
I've tried to compile with
Hi!
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 3:01 AM
Subject: Re: unexpected create table as lock issue
[EMAIL PROTECTED] wrote:
I have a table called web_master which has as
David,
- Original Message -
From: David Griffiths [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, May 13, 2004 7:50 AM
Subject: InnodB Hot Backup Questions
I'm hoping someone on the list has some experience with the tool
(specifically, restoring a backup), as
Hi!
- Original Message -
From: mayuran [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, May 12, 2004 7:56 PM
Subject: Innodb - next key locking
I have a perl script which fork()'s many children and each
child is updating a table, and each child is
Deepak,
I tested this, and MySQL refused to rename the column in either the parent
table or the child table. I do not understand how you have been able to
rename the column x1 to to y1 in the parent table.
Can you make a simple, repeatable test case where the renaming in the parent
table
Hi!
- Original Message -
From: mayuran [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, May 10, 2004 11:11 PM
Subject: innodb log
When I do a SHOW INNODB STATUS i see a query which is
waiting for a lock to be released, but innodb status
doesnt show the whole
Hi!
I haven't installed MySQL to LInux for ages (mostly I use FreeBSD) and
now I get the problem I remember of in past but I can't recall its
cure. :0)
When I start mysqld it works fine but doesn't leave console and block it.
As far as I put mysqld launch into /etc/rc.d/rc.local script I get
Thank you for correction. You are absolutly right!
Best regards,
Mikhail.
- Original Message -
From: Brian Mansell [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: A Z [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 10:11 AM
Subject: Re: Max
Just a
The InnoDB storage engine can use raw disks without a filesystem.
Would that be the fastest possible setup?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, May 13, 2004 at 10:21:15AM +0200, JFL wrote:
The InnoDB storage engine can use raw disks without a filesystem.
Would that be the fastest possible setup?
Probably, yes.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
I am considering this:
mysqlbinlog --database=mydb logfiles | mysql -f
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that those binary
Hi,
I have found that messages
a.. Non-standard behavior of UNION statements has changed to the standard
ones. So far, a table name in the ORDER BY clause was tolerated. From now on
a proper error message is issued (Bug #3064).
a.. Added max_insert_delayed_threads system variable as a synonym
On Thu, May 13, 2004 at 10:28:26AM +0200, JFL wrote:
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
I am considering this:
mysqlbinlog --database=mydb logfiles | mysql -f
There is a faster way, but it is
I've been told that InnoDB on a raw partition is the fastest setup.
To setup my system for this, could I create a partition called /innodb
and adjust the my.cnf like this?
innodb_data_home_dir = /innodb
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
I suppose
On Thu, May 13, 2004 at 11:00:17AM +0200, JFL wrote:
I've been told that InnoDB on a raw partition is the fastest setup.
Actually, you've been told that it's probably the fastest.
To setup my system for this, could I create a partition called /innodb
and adjust the my.cnf like this?
I've been told that InnoDB on a raw partition is the fastest setup.
Actually, you've been told that it's probably the fastest.
Correct. Sorry :)
Check the InnoDB docs. They explain how to setup raw disk
partitions. You'll be using device names, not mount points.
Thanks. I forgot to check the
Hello all, I would like to find out if anyone has implemented an architecture
where a hardware load balancer is placed in front of some MySQL servers in a
Multi-master replication scheme. I want to use the load balancer more for high
availability, than for load balancing. All connections to
Alle Wednesday 12 May 2004 21:51, hai scritto:
Hi!
On May 12, Nico Sabbi wrote:
Alle Wednesday 12 May 2004 14:12, hai scritto:
Hi!
On May 12, Nico Sabbi wrote:
Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto:
Hi!
sorry for replying to myself, but I
Dear MySQL experts!
I'm at something of a loss here. I'm testing MySQL on a new hardware
platform. Previously, we had it running on Tru64 Alpha boxes. We're
now moving it onto Itanium2 boxes running Debian Linux. Each machine
has 4 CPUs and 16 GB RAM. Kernel version is 2.6.5.
We couldn't
David Blomstrom [EMAIL PROTECTED] wrote:
I just switched my primary key from a numerical column
to abbreviations, primarily because the latter are
more distinctive and easier for me to work with. The
flip side is that my row order has been turned upside
down.
I made my database in a
On Thu, May 13, 2004 at 06:49:01AM -0400, PARTHA DUTTA, BLOOMBERG/ 499 PARK wrote:
Hello all, I would like to find out if anyone has implemented an architecture
where a hardware load balancer is placed in front of some MySQL servers in a
Multi-master replication scheme. I want to use the
In the last episode (May 13), JFL said:
I've been told that InnoDB on a raw partition is the fastest setup.
Actually, you've been told that it's probably the fastest.
Correct. Sorry :)
Check the InnoDB docs. They explain how to setup raw disk
partitions. You'll be using device names,
Sounds like you might be interested in Emic Networks' Application
Cluster 2.0 for MySQL. We've begun taking a look at it ourselves --
without arriving at any conclusions at this point.
(However, it is not strictly a hardware solution.)
General Info:
Tom Cunningham [EMAIL PROTECTED] wrote:
In short: what is the standard MySQL handling of temporary tables,
*especially* when you've got a slave filter on to only replicate certain
tables?
These options apply to the temporary tables too.
My replication stopped over the weekend, because
Need someone with some insight or experience with InnoDB (Heikki?? :-)
1) According to a book I'm reading (High Performance MySQL) InnoDB uses MVCC,
effectively allowing readers to not block writers. In Oracle (with which I am more
familiar) this is accomplished via rollback segments, and now,
I'd go with Reiser on SuSE.
What about Reiser on Debian?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I thought that only InnoDB tables could be joined -
and only if they had foreign keys. But it sounds like
any kind of table can be joined, and it doesn't need a
foreign key.
Can someone explain InnoDB, MyISAM and foreign keys in
plain English? If I understand correctly, foreign keys
simply help
OK, I'm sorry. The solution I gave doesn't work.
You need to have some sort of conditional in the sort expression so that
numbers are sorted numerically and other things are sorted alphanumerically.
I'm not aware of a test for numeric vaues in MySql, so you need to use some
trick to
I thought that only InnoDB tables could be joined -
and only if they had foreign keys. But it sounds like
any kind of table can be joined, and it doesn't need a
foreign key.
The ability to join a bunch of tables in a query is different from foreign
keys. A foreign key is a relationhip
On Thu, 13 May 2004 10:34:37 -0700 (PDT)
David Blomstrom [EMAIL PROTECTED] wrote:
I thought that only InnoDB tables could be joined -
and only if they had foreign keys. But it sounds like
any kind of table can be joined, and it doesn't need a
foreign key.
Exactly, you can do a join with any
I have MySQL 3.23.41 running on an Apache server with Red hat. it's hosted at EV1
(formerly Rackshack) but they do not provide any support for the server.
I'd like to upgrade to the latest MySQL. Does anyone know of a bulletproof,
step-by-step, online guide to doing this? Perhaps a reasonable
OK, I'm sorry. The solution I gave doesn't work.
You need to have some sort of conditional in the sort expression so
that
numbers are sorted numerically and other things are sorted
alphanumerically.
I'm not aware of a test for numeric vaues in MySql, so you need to use
some
trick to
On Thu, May 13, 2004 at 11:16:18AM -0400, Peter J Milanese wrote:
Does the filesystem matter as much as disk throughput? I'd imagine that
is where the bottleneck would be, at least as I've seen...
Throughput or seek time?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
I've just tried the three column solution (designating each column as
null), but the empty cells produce a 0 just as the two cells with an
actual 0. How do I avoid that, preferably with a blank in that place?
*
On Thu, 13 May 2004 13:53:37 -0400, Bill Easton [EMAIL PROTECTED]
wrote:
OK,
I would think that seek time may be interdependent on disk speed and
Filesystem type... I can see why it would matter sort of...
Jeremy Zawodny [EMAIL PROTECTED]
05/13/2004 02:45 PM
Please respond to mysql
To: Peter J Milanese [EMAIL PROTECTED]
cc: Tim Cutts [EMAIL
In the mysql documentation it stands:
max_user_connections
The maximum number of simultaneous connections allowed to any given MySQL
account. A value of 0 means ``no limit.'' This variable was added in MySQL
3.23.34.
In my configuration file I wrote: max_user_connections = 0
That did not
Hello,
I am trying to figure out a problem I am having with a query involving
multiple joins but am not having much luck.
I currently have this query working:
db1 LEFT JOIN db2 ON db1.files_groupId = db2.group_id
LEFT JOIN db3 ON db1.files_userId = db3.user_id
Basically the above
Piece of cake :)
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
I've recently upgraded our servers from 3.23.57 to 4.0.18. No
problems at all.
Luck!
- Original Message -
From: Joe Harkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 2:23 PM
Subject:
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that those binary logs are in
fact the relay logs that it gathered from the master. So
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Some of you may have noted that we have uploaded the MySQL 4.0.19 binaries
to our mirrors, but have not sent out an announcement or updated the web
pages yet.
The MySQL 4.0.19 binaries were uploaded to the download mirrors on May,
10th. However,
Hello List,
Please forgive this rather lengthy post. I thought I had something worked
out to answer Rob's question but when I put it to the test I found what MAY
be a bug in 4.1.1a-alpha-nt-log. Here is what I did.
I created two tables, tablea and tableb. Here are their defs:
mysql show create
On Thu, May 13, 2004 at 10:16:52PM +0200, Jacob Friis Larsen wrote:
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that
Hi,
Can I insert specifying the data into a auto-incremental column?
Explain better:
We have a database (MySQL-4.0.17) that I need to syncronize
with a off-line software.
If a client was inserted in the off-line software, I´ll need to import
the client datas to the central database.
The client
Hi all,
I have the following data
Users : user(varchar), entreprise_1(int), entreprise_2(int)
Entreprise: idx(int, prim, auto_incr), code(varchar)
some users have one entreprise, and some two.
if I decide that 'no entreprise x' is coded with entreprise_x=0, i have
obviously a problem with
Ronan Lucio wrote:
Hi,
Can I insert specifying the data into a auto-incremental column?
Explain better:
We have a database (MySQL-4.0.17) that I need to syncronize
with a off-line software.
If a client was inserted in the off-line software, Ill need to import
the client datas to the
I've got a very high traffic discussion forum database that is
constantly running into a problem with lots and lots of threads in the
Locked state. i was under the impression that MySQL could
update/insert and select from the same table at the same time, but it
doesn't seem to be the case.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
Sent: Thursday, May 13, 2004 3:21 PM
To: [EMAIL PROTECTED]
Subject: avoiding Locked threads
I've got a very high traffic discussion forum database that is
constantly running into a problem with lots
Hi everyone. I seem to be getting some funny results when I combine the
IFNULL and QUOTE functions. Maybe I have overlooked something I can't
see what.
Anyway here's the situation.
SELECT version();
4.0.18-max-debug-log
The query I'm having problems with is as follows:
SELECT attachment,
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 6:45 AM
To: [EMAIL PROTECTED]
Subject: InnoDB Questions
Need someone with some insight or experience with InnoDB (Heikki?? :-)
a) Where does InnoDB store all of this information (such as
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
Pros: performance and bypassing the filesystem cache.
MySQL can't use all that
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 4:03 PM
To: Dathan Vance Pattishall
Cc: 'Tim Cutts'; 'MySQL List'
Subject: Re: InnoDB filesystem
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
I think
Will MyISAM support transactions in the future versions? Is it possible?
-thaks, Lorderon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 14 May 2004 04:38:56 +0200
Lorderon [EMAIL PROTECTED] wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
Not at the moment, I think 5.1 will support foreign keys in MyISAM, but not sure about
transactions...
Josh
--
MySQL General Mailing List
For list
On Fri, May 14, 2004 at 04:38:56AM +0200, Lorderon wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
It's possible, but I don't see it happening for quite a while...
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
Jacob,
I'd go with Reiser on SuSE.
What about Reiser on Debian?
I'd choose SuSE since Reiser is their default filesystem and they have
been an early implementor of Reiser-related patches. If you use Linux
kernel 2.4.24 (or later) and the latest 3.6 series of ReiserFS+tools,
the Linux
Jeremy Zawodny wrote:
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
In my view, when you have a one-to-many relationship like users to
enterprises, you should always design the database to handle *any* number of
occurrences (enterprises in this case). The standard way of doing that would
be to normalize to Third Normal Form. Your current design isn't even in
First
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 04:38:56AM +0200, Lorderon wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
It's possible, but I don't see it happening for quite a while...
Additionally, is there much of a point considering the fact that
I get the same behavior in my copy of 4.0.17. This looks like a bug to me,
so I've submitted it as one http://bugs.mysql.com/bug.php?id=3756.
Michael
Toro Hill wrote:
Hi everyone. I seem to be getting some funny results when I combine the
IFNULL and QUOTE functions. Maybe I have overlooked
67 matches
Mail list logo