Eko and all,
The MyIsam storage engine is a non transactional engine and InnoDb is
a transactional engine. That is the main difference. So I think the
MyIsam engine should be faster.
However, some file systems that have journals are faster than non
journalling file system. It's not always
David,
Can anyone recommend this book? Or, if not, what book can you
recommend for a newbie.
I always recommend Paul Dubois' New Riders Book:
* http://www.kitebird.com/mysql-book/
Paul's probably lurking on the list. I bought the 1999 edition and I
still refer to it :)
DSL
--
MySQL
Hi There,
I have a replication setup on my local network (so any updates can be
transported at around ethernet speed).
Here's the behaviour I see:
* MySQL Master
- I do a whole slew of drop table and create tables
* MySQL Slave
- It doesn't pick them up
... until ...
- I restart the slave
It
Fafa,
I am running this non-profit organization working together with
various charity organizations across the world.
We would like to setup an efficient member database using MySQL
rather than having some ugly formatted MS Word document listing
them.
What would be the purest and
Hi,
I have a problem connecting to the mysql server. I installed a new
server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
websites running on it using the mysql server. Last friday I had a
crash of one off my other servers and I copied the websites and db's
to this new
Theresa,
Knowing that MySQL is an open source software I'm in favour of this
application and wldlike to try out this product, wonder why I can
download this application for my necessary practice for both
Client/Server application.
I assume you mean How can I download the Mysql server and
James,
We had a strange instance happen here with one of our MySQL servers.
We have multiple MySQL installations, and one of the MySQL servers had a
problem with daylight savings time.
Basically, when we ran a select now(); MySQL reported time that was two
hours ahead of the actual time.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
from network); 23 Nov 2002 12:49:23
- Received: from 202-6-129-44.ip.adam.com.au (HELO localhost)
(202.6.129.44)
by eden.adam.com.au with SMTP; 23 Nov 2002 12:49:23 -
Date: Sat, 23 Nov 2002 23:31:12 +1030
From: David Lloyd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: subscribe
)
by eden.adam.com.au with SMTP; 23 Nov 2002 12:54:37 -
Date: Sat, 23 Nov 2002 23:36:27 +1030
From: David Lloyd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Message-Id: [EMAIL PROTECTED]
X-Mailer: Sylpheed version 0.8.5 (GTK+ 1.2.9; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain
I know that there are binding that allow one to speak SQL to MySQL for:
* PHP
* Perl
* Java
...there must be more, all with their own idiosyncrancies, strong points
and weaknesses. Rather than having a holy war about which binding is
better (I prefer Perl but I certainly use PHP when it's
Mark,
Note that mysql does not support bind variables. If you think
you'reusing them, whatever API you are using is filling them in
beforesending the statement to mysql. Bind variables do solve
quotingproblems, though, so if you use them, know why you're using
them :)
Rumour has it,
Stephanie,
Does anyone know if there's a way in MySQL have the same functionality
without installing the whole program on a users machine? I'm using a Java
program along with Connector/J and a MySQL DB. We are trying to make it so
the user doesn't have to install MySQL everytime they want
Actually, I'd suggest the New Riders Book by Paul DuBois, Mysql...what
was it you wanted to achieve with your book:
* do you want a reference
* a tutorial
...?
mysql,query
DSL
-
Before posting, please check:
What's the advantages of using Embedded MySQL instead of, say, Berkely's
DB?
[mysql, query]
DSL
--
Qualcuno no mi basta.
Vivere cercando il grande amore.
Vivere come se mai dovessimo morire.
(Anastasio, Valli e Travato)
Any reason you can't upgrade to a newer version?
mysql,query
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Adam,
Obviously MySQL would have advantages if I intended to use it as a server
database with concurrent users. But is it faster than Access in the
single-user environment, when dealing with large databases?
MySQL in a single user environment is a pain in the arse because of its
lack of an
Gerald,
#!perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost,
jwp, x,
{'RaiseError' = 1});
$drh =
Gerald,
Now I am getting the following:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains;
C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
line 3;
I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I
fix this?
No, it's separate from the
Joao,
I think I've already asked this before, but I will try again. Do I loose
too much performance using InnoDB tables in autocommit mode instead of
using MyISAM tables?
Possibly, but too much is really relative on what your needs are. What
are you trying to achieve and what is more
Mysql Query
---
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Spiros,
linux:/home/db/TMPOUT # rpm -q mysql
package mysql is not installed
linux:/home/db/TMPOUT # rpm -qa | grep MySQL
MySQL-shared-4.0.3-0
MySQL-client-4.0.3-0
MySQL-devel-4.0.3-0
MySQL-4.0.3-0
linux:/home/spiros/TMPOUT #
Ok.
mypc@linux:~ /usr/bin/mysql
ERROR 2002: Can't
Hmmm,
(mysql, query)
Thanks
That's OK.
It's 2.4.18
Sorry, I meant distribution...eg is it RedHat, Slackware ;-?
So, I will try to unistall and install from the
tarball, yes?
It wouldn't hurt. How did you install it in the first place?
DSL
--
Con te partiro, su navi per mari
Che io
H,
Suppose I have a field named title that contains
one
of these
I am a Man
I am a Woman
We are Men
We are Women
Why not split this into two fields:
pronoun enum('I','WE')
gender enum('MAN','WOMAN')
OR a SET
title SET(I,WE,MAN,MEN,WOMAN,WOMEN)
...and then get your
You could do something like:
linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
Don't add the RPM on the end.
Also, what does:
* rpm -qa | grep MySQL
...show. It will be in there. Use that name.
mysql,query
DSL
--
Con te
Hmmm...
Specify the fields you want in your query.
example:
SELECT stat_id, stat_name, stat_data FROM build_stats
WHERE stat_date LIKE ...
I think you miss the point of the question. What if you have table with
50 fields and you just don't want field 45, 46 and 48? It would be much
You may want to check out CPAN for:
Apache::DBIx
...
(kill the mysql query spam thingo)
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Mark,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
Parse the contents of SHOW DATABASES and then use the ouput of that to
SHOW TABLES...
mysql, query.
DSL
Hi There,
(mysql, query)
From the online manual I see:
--
innodb_data_file_path
Paths to individual data files and their sizes. The full directory path
to each data file is acquired by concatenating innodb_data_home_dir to
the paths specified here. The file sizes are specified in megabytes,
Neal,
Sorry for the MySQL newbie question ... but are there not primary/foreign
key constraints in MySQL 3?
In MyISAM tables or ISAM tables no.
I can't imagine that this is right. Perhaps
I'm just overlooking something
innodb?
(mysql query)
DSL
( mysql, query )
Can anyone help.
I'm installing (at the mo) 4.0.3 Beta, but the error message is the same
which ever version..
libmysql.c: In function `mysql_real_connect':
libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1675: too
H...
( mysql, query )
What permissions does a user need to issue:
LOCK TABLES blah WRITE
???
I have a user which I have:
GRANT ALL ON * TO user (blah blah)
...but that user can't lock any tables. Only the mysql root user can...
Version 4.0.2, built from source on RH 7.1.
DSL
--
Paul,
(mysql, query)
It *can* use TCP, but that's just the transport protocol through which
the replication information is processed. Replication can also be
done between two servers on the same host, using a UNIX socket or (on
a Windows box) a named pipe. The replication protocol itself
Andy,
( mysql, query )
you could install MyODBC to write the tables directly from MS A. to MySQL
via ODBC.
Works ok and did a good job for me.
I've looked through the archives of this list but all methods of porting
a ms access db to mysql seem to require installing additional
Paul et al,
At 18:59 -0400 8/31/02, qlarry wrote:
here a file size limit in my sql
What?
I think that loosely should translate as Where is a file size limit in
MySQL which I would then interpret as Is there a file size limit in
MySQL.
All MyISAM tables are stored on the local file system
David
[ mysql,query ]
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
Can you show us the output of:
describe CompanyContacts
...and also what is the exact error message?
Are you connected as a user who is allowed to update the
Amit,
I am trying to run the following query:-
select red,green,blue from colorchanger where
colorcode = select value from jobattributekit where
attributekit = Color and jobnumber =
28200124RB4-001 and scenario=JN75K;
It doesn't support subselects. It's having a problem with the second
Dave
[ mysql query]
when I installed mysql 3.23.43 it instructed me to be sure to add a password with
the following results-
:
seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
Enter password:
/usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
[ mysql, query ]
could someone point me to the right direction please
Are you generating it in MySQL (using sql) or are you using a
programming language to do it?
DSL
-
Before posting, please check:
Adam,
[ mysql, query ]
However, you can do it manually (I think) by playing around with both
the order of the where clause and the order of the join clause
Yes.
Also, MySQL has a really wimpy default configuration (I can't figure out
why). Here is my /etc/my.cnf (I don't know what the
l,
I want to create an one to one relationship among
tables using SQL. How can i do this. I creates an
relation but it dose not expect my needs. For Ex they
are two table say tbset nad tb tbprocess. If i set an
one to one relation between the two tables in which
the master table is tbset.
Brent
Don't know if that's what you are trying to do. But I can't think of any
reason to permanently replicate a table in the same database.
Maybe the other person is duplicating the data to do test stuff to it...
mysql,query
[I hope the spam thing lets this through]
DSL
--
We are not
[in order to avoid the spam filter]
mysql
mysql
sql
[end avoid]
(this is a test, I've got the pips with the spam filter when I'm not a
spammer -- especially when MOST of the messages from this list register
above 3 on http://www.spamassassin.org/)
GRUMBLE
James Foley wrote:
Hi,
If
43 matches
Mail list logo