Dear List,
I did a data warehouse comparison of a number of databases a while back - for
full details of data structures and queries see :
http://homepages.slingshot.co.nz/~markir
Altho I spent more time on Mysql than any of the others, I was not able to
optimize some aspects as much as I
Venu writes:
Hi !!!
Can anyone has the answer for him ? How we can have a secure data transfer
over the web using MySQL and its APIs ? He is desperately needed some idea
in order to take further steps with MySQL ?
Regards
Venu
Something like this :
ssh1 -C [EMAIL PROTECTED] -L
Jeremy Zawodny writes:
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
Hello-
I poked around on the site but didn't find any definite answer.
Roughly when is version 4.0 of MySQL expected out? I saw the
information on the todo in regards to version 4.0 and the
I would also strongly suggest not storing your images in the
database but
rather a link to the image.
even that - why?
if you're using an ultrafast webserver like Tux in combination with
Apache/php-perl
the Tux webserver serves the images incredibly fast (see specweb tests)
what
Description:
I want to install MySQL on my PC. But I'm using Windows ME as
operation system. So I downloaded the Windows 95/98/NT/2000
(Intel)-version.
Was this correct?
After installation I tried to start the server using following
MS DOS-commando
Hi guy's,
does anybody has experience with running mysql on a linux system or on an
winnt-server-system?
If I have the same hardware for both operating systems ( e.g PIII with 256
MB Ram and a 36 GB SCSI-HF)
which one gives me or the mysql users the best performance?
At the moment I used a
While I have not specifically done a linux vs NT shootout, I have worked
with many similar programs on both platforms. My closest experience was
with the commercial database Sybase (ASE 12.0)
With the same data, and the same database schema on the exact same
hardware, we found that linux (RH
Sigh, that wasnt realy the point of the email, but ok, i knew it could
happen when i wrote it.
The images -are- stored in the database in the product i'm activly
marketing, its a content management system, which can be administered via a
web interface. All text / html / images are stored in the
I use kernel 2.4.9 ,I compiled mysql-3.23.41(./configure --with-low-memory; make ),
when make, it said :
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la)
make[2]: Leaving directory
What compiler you use? I have similar problem with some software packages,
when I try compile it with RedHat gcc-2.96. Try another version, gcc 3.01 or
gcc 2.95
On Sun 26 Aug 2001 18:39, sailer-sh wrote:
I use kernel 2.4.9 ,I compiled mysql-3.23.41(./configure --with-low-memory;
make ), when
On Sun, Aug 26, 2001 at 11:29:31AM +, Greg Cope wrote:
Jeremy Zawodny wrote:
On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
The other solution is rsync. I dont know much about this guy
yet, but I have some concerns with using it to copy over large
remote files.
Ryan,
if you can run the recovery inside gdb
with mysqld compiled with the gcc option -g
and print the stack trace with bt, it may help
me to see where the problem is and fix it.
If you have updated the primary key of a 8000-byte
row then the table is certainly corrupt and cannot be
saved. But
On Fri, Aug 24, 2001 at 09:59:38AM -0400, Tac/Smokescreen wrote:
I have a large (40 million rows) table that currently consists of a
few integers and a varchar. I need to add a memo (text 255 chars)
field to about 2% of the rows. Originally I was going to create
another table with a key
Hi!
A serious bug has been found in the big BLOB and TEXT
support of InnoDB. If you update the primary key of a
row whose length is 8000 bytes, then the table
becomes corrupt. Also the tablespace may become
corrupt. Note that also a REPLACE can internally be
handled as an update.
A fixed
Hi,
recently I converted a table containing a large amount of text fields from
myISAM to inno-DB and encountered a problem I can't help with. The table
structure consists of:
textref_id INT(12) UNSIGNED
textref_cat_id INT(12) UNSIGNED
textgroup_key CHAR(5) NOT
On Sun, Aug 26, 2001 at 09:10:31PM +0200, Ralph Graulich wrote:
Hi,
recently I converted a table containing a large amount of text
fields from myISAM to inno-DB and encountered a problem I can't help
with. The table structure consists of:
textref_id INT(12) UNSIGNED
the table becomes corrupted. Is this some limitation of inno DB or should I
separate the UPDATE process in two separate UPDATE statements?
It's a known and confirmed bug that will be fixed in 3.23.42. There
was an announcement just posted about this a few minutes ago.
Hi Jeremy,
thanks alot
I'm always seeing stuff like:
MySQL 3.23.41-max: up 9 days, processed 115,312,654 queries (140/sec.
avg)
On the bottom of emails. My question is HOW do you add this to emails?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
Running Windows 2000 Advanced Server (SP2)
Also running Suse Linux
On Sat, Aug 25, 2001 at 09:24:25PM -0500, Paul DuBois wrote:
At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
For single values I usually use this DBI function and query:
my $val =3D $dbh-selectrow_array(SELECT value FROM tab1 WHERE test=3D=
2);
However, what if I want to store a
Does mysql have something like NO LOCK?
SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I'm just beginning with MySQL, and I have the following question. Is there
something like events in MySQL. What I want to do is write some message
automtically into a table every time a record in some table is changed.
Many thanks, Darius Blaszijk
On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote:
Does mysql have something like NO LOCK?
SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
By default, no. But if you use InnoDB tables in MySQL, you'll get
non-locking SELECTS, which is probably what you're looking for. See
the
Darius Blaszijk [EMAIL PROTECTED] writes:
I'm just beginning with MySQL, and I have the following question. Is there
something like events in MySQL. What I want to do is write some message
automtically into a table every time a record in some table is changed.
You're looking for triggers,
Hi!
Jeremy Zawodny did already answer this email, but I have a couple of
additions to his answer.
Chris == Chris Chabot [EMAIL PROTECTED] writes:
Chris Dear Everyone,
Chris I have been looking at this mysql.com/org dispute for a while now,
Chris and i must say i am getting more and more
On Sun, Aug 26, 2001 at 04:45:07PM +0200, Chris Chabot wrote:
Hi Jeremy, thanks for a good reply. In awnser to some of your questions :
Jeremy Zawodny wrote:
Now, a few years after first using MySql, a major dispute seems to
plague the 'image' of MySql, and posibly also the future
Hi
I need to set the max_allowed_packet to 16M. below is my
01mysql-server.sh file. I use DBI and I know that I have to start this
before the DBI program and I did but if I use ./mysqld --help it shows
that my max_allowed_packet is still 1M. Any help would be really great
since I've been working
Hey Jeremy, Michael,
I wanted to thank you both for your replies, they definatly have given me
some more insight into the situation, and also gave me some extra motivation to
keep my commitment to mysql. Like most other people, i hope this 'mess' can be
resolved in the near future.
Jeremy,
Hi
Can you help me locate the information on your website about converting
Access 2000 to MySQL.
I host with Webfusion, who use MySQL, but my site has been created using
Access and I need to convert it before uploading. I understand the
conversion is quite easy and that all the information is
http://www.mysql.com/downloads/contrib.html#SEC607 The Access one works
pretty good.
Cheers
M;)
If you ever fall off the Sears Tower, just go real limp, because maybe
you'll look like a dummy and people will try to catch you because, hey, free
dummy.
- author
-Original Message-
From:
I'm in the process of building a tree-structured message base, or rather
porting software I wrote back in mid-80s to the web. This isn't the
ubiquitous threaded BBS software. It's tree-structured. This means that
every message on the message base is related through a single ancestor, Msg
Is it possible to set a differenent password per database for the same user?
It doen't appear to be possible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Sun, Aug 26, 2001 at 10:40:20PM -0500, Mark Johnson wrote:
Is it possible to set a differenent password per database for the
same user? It doen't appear to be possible
Not that I know of. The user is tied to a single password.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
CREATE TABLE MSJOURNL (ACCT INT(3),
DESC CHAR(29),
DTE DATE)
This query fails when MySQL encouters DESC. Changing DESC to DESCRIP causes
the query to work. I'm wondering if filtering for the reserved word DESCRIBE
causes DESC not to be legal for use in field names?
Hi !!
)-Original Message-
)From: Bill Angus [mailto:[EMAIL PROTECTED]]
)Sent: Sunday, August 26, 2001 1:58 PM
)To: [EMAIL PROTECTED]
)Subject: Query fails
)
)
)CREATE TABLE MSJOURNL (ACCT INT(3),
)DESC CHAR(29),
)DTE DATE)
)
)This query fails when MySQL encouters DESC. Changing DESC to
On Sun, Aug 26, 2001 at 01:58:23PM -0700, Bill Angus wrote:
CREATE TABLE MSJOURNL (ACCT INT(3),
DESC CHAR(29),
DTE DATE)
This query fails when MySQL encouters DESC. Changing DESC to DESCRIP
causes the query to work. I'm wondering if filtering for the
reserved word DESCRIBE causes DESC not
CREATE TABLE MSJOURNL (ACCT INT(3),
DESC CHAR(29),
DTE DATE)
This query fails when MySQL encouters DESC. Changing DESC to DESCRIP
causes
the query to work. I'm wondering if filtering for the reserved word
DESCRIBE
causes DESC not to be legal for use in field names?
desc itself is a
36 matches
Mail list logo