-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 12:53
To: Sander Pilon
Cc: [EMAIL PROTECTED]
Subject: Re: MERGE FULLTEXT, two years later.
Hi!
On Jul 08, Sander Pilon wrote:
I searched the archives and in December 2000
I searched the archives and in December 2000 it did 'not yet' work.
( http://listarchive.nextrieve.com/mysql//200012/msg00539.html )
Will MERGE tables and FULLTEXT indexes work together in 4.x?
Two-and-a-half years later?
Regards,
-Sander
Is it possible to run replication on tables that are updated with user
vars?
Example:
SET @id = 1; does not show up in binlog!!
INSERT INTO table SET id = @id;
Now, on the master it works fine. The slave fails because the SET does
not seem to show up in the binlog, @id is not set, and the
-Original Message-
From: Daniel Koch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 13:11
To: Arul
Cc: MySQL
Subject: Re: MYSQL 4.0
Arul wrote:
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Also any sites
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1 int, id2 int,
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1, id2, articletext
-Original Message-
From: Ryan Fox [mailto:[EMAIL PROTECTED]]
Sent: 29 October 2001 00:55
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Data Normalization Paradox
Among other criteria, it mentions that in first order normalization
No
repeating groups of data are
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2001 13:46
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Memory allocators / STL
[EMAIL PROTECTED] writes:
Do you know if this is the case even with the GCC v3.0.1?
What is
I'm thinking of switching to InnoDB, however - my application does a few
COUNT(*) WHERE queries on large tables (somewhere between 50K
and 2M rows)
I've read up on InnoDB and its issues with COUNT(*) on entire tables,
but is there
a reason to assume that InnoDB is also slower when
MySQL - as I said at our meeting, we would not be comfortable
with this
as an enterprise strength solution. MySQL is unsupported freeware and
lacks enterprise management functionality.
True, if you ask me.
It has a small limited feature
set compared to ORACLE, DB/2
True. No
Lose (some of) the keys!? Keys, especially on small rows (where a key
introduces a lot of overhead), can take a significant percentage of
space.
Turn on key compression? (dunno if innodb supports that)
Other then that I wouldn't know. But live with the fact that keys
introduce overhead. It
On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
difficult to do (add the necessary code to MySQL),
provided that the
logging code is as straightforward as the binary logging code.
i figured something like that, though i don't know the
internals. it
seems it
So you're saying like this...?
Albums
--
ID,Artist,Title,Label
Tracks
--
Title,Length,TrackNumber,AlbumID
Where there is one album table and one track table, and each
track references back to the album that it is a member of?
I'm liking that... It doesn't make it easy
the same time, a NuSphere-controlled mysql.org doesn't strike me
as a disaster, provided they can do it with out shooting
themselves in the foot, as they are doing now.
Nah
There using it as a marketing ploy to dup the public.
The should have released their GPLed extentions
You must compile PHP with the mysql module enabled. See the PHP manual
for more information.
(Or search the excellent php mailinglist archives at
http://www.php.net/support.php)
-Original Message-
From: Rick Makla [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2001 17:02
To: [EMAIL
MySQL supports transactions if you are using either InnoDB or
Gemini table types.
Cal
Are we forgetting BDB tables? Yes.. yes.. I believe we are!
http://www.mysql.com/doc/B/D/BDB_characteristic.html
-
Before
Note that the new BLOB code is not well tested yet, though
I have not received any bug reports for it. It may be best to
experiment first with pieces of your table instead of doing
the whole, maybe several hours long, conversion at once.
Can you tell us a bit more about the BLOB code?
This is very interesting, this Open Source Legal Resolution ;-)
Indeed it is.
The thing I find most interesting, and a bit scary, is the way people
seem to pick sides.
For example - vermin, scum, obscure, are just a few of the words
recently used to describe the likes of NuSphere.
is of the trademark
application? Under way, finished, or in the mail as
suggested by the other post from Sander Pilon? (I don't know
about US legal aspects here, but I'ld assume in the mail is
rather different from finished...)
These are the two primary applications:
http://tarr.uspto.gov
Hi!
cut
Sander I do not deny their claim on the trademark OR domain,
but I am
Sander somewhat unpleasantly surprised by the means they try
to resolve
Sander this matter, and the fact that nobody in a what I
assume is an
Sander internet-aware company like MySQL even considered
Sander Pilon [EMAIL PROTECTED] writes:
I think all of us should send a letter to the people who
appropriated
the MySQL.org name. In my opinion, if MySQL AB wants this
domain they
should have the right to it. To me, it is a show of
disrespect to the
fine folks at MySQL
The answer to ALL your 'where can I get it' questions is -
1) Freshmeat. www.freshmeat.net (Search for 'cscope'.)
2) Google. www.google.com (Repeat search)
Seaarch 1 results in this url: http://freshmeat.net/projects/cscope/
-Sander
-Original Message-
From: [EMAIL PROTECTED]
You can *STORE* Unicode (UTF-8) in MySQL just fine. Just don't expect
text-search (LIKE, =, etc) to do anything useful with it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of md
Sent: 1 June 2001 15:22
To: [EMAIL PROTECTED]
Subject: Unicode
Freebsd does not have a libpthreads file.
Just compile with -pthread(s) and it'll work. Well, it does for me.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 16:18
To: Sinisa Milivojevic
Cc: [EMAIL PROTECTED]
Subject: Re: Help with FreeBSD
Compiled with -D_REENTRANT -D_PTHREADS -fPIC -DPIC -Wall
Linked with -pthread
but its not mysql. For mysql I just did ./configure; make; make install
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 17:11
To: Sander Pilon
Cc: 'Sinisa
No editing?!? Psch... louzy programmers.
( see http://www.jpsoft.com/index.htm for proof that consoles in NT/2K
consoled can edit just fine, etc.)
But... there are numerous mysql clients available, also for windows. I
bet you can find one with fine edit capabilities in the contrib section.
( I
2001 14:32
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Problems with MySQL++
Sander Pilon writes:
It is fine and complete will all chapters and in all formats.
This page used to have lots of cool documentation...
http://www.mysql.com
Howdy,
I posted this question over on the plusplus list, but so
far I've not received a response. This list seems more
active, so perhaps someone here can offer me a hand.
I'm trying to get the 1.7.8 distribution of MySQL++ to
build as directed in the README -- using automake.
We often get a message from MySQL that there are too many connections.
What can we do ?
Should we use connect rather than pconnect ?
We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Yes, you should.
That, or increade the amount of allowed connections, or decrease the
"Aborted" in a C++ program usually means an exception was thrown that
you didnt catch. In this case, the connection constructor could have
thrown something.
try
{
Connection MySQL(db, host, user, pass);
}
catch(...)
{
cout "Connection failed." endl;
}
Check the
UTF-8 is just another encoding scheme.
You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even
CHAR), however you cannot do much more with it beyond storing.
Comparisons aren't likely to work, character-length calculations will
not work, etc. So if all you wanna do is store and
Hi Sander!
On Thu, Mar 29, 2001 at 02:11:02PM +0200, Sander Pilon wrote:
I'm getting a whole lot of mysql++ link problems on freebsd :/
Used gcc 2.95.3, latest mysql++
The program links fine under linux win32.
Any idea's?
[...]
What version of FreeBSD are you currently
I'm getting a whole lot of mysql++ link problems on freebsd :/
Used gcc 2.95.3, latest mysql++
The program links fine under linux win32.
Any idea's?
g++-L/usr/local/lib/mysql -L/usr/local/lib -L/usr/lib -pthread -o bord
main.o BMain.o options.o ../actioninterface/libactioninterface.a
Web robots are not search engines (just the things that fill the engines),
as far as I understand.
As I mailed to J. earlier, most searchengine algorithms aren't directly
compatible with (my)sql.
(Meaning that, for the best performance *you* have to do the searching, and
not mysql - once you
-Original Message-
From: Simon Windsor [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2001 16:22
To: [EMAIL PROTECTED]
Subject: ReisserFS
Hi
Has anyone user MySql on a ReisserFS file system ?
Where any problems encountered ? and do you have any pearls of
wisdom that you are
Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
B) what happens when they ar full?
C) can it auto-create new files as demand grows?
D) can you safely add new files when there is data in them already?
Regards,
Sander
-Original
Right,
As far as *MySQL* goes I haven't noticed this in particular. That's because
most mysql reads are indexed and use keys/caches.
As far as general performance goes, I've definitely noticed it.
(Creation/Deletion of large and large number of files is much, MUCH faster
than ext2 - and
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote:
Making search engines is not a trivial thing, but this may be an
aproach...
I appreciate all the replies. In my original post I also asked about the
FULL TEXT index type. If I may ask again, has anyone had any
experience
Ren Tegel wrote:
This is a very good idea, and in fact the only workable way.
Your performance will not lower when retrieving the documents,
cause those
fields are indexed.
Your memory use will decrease as well, since the file cache does
not have to
cache a big table when
Could be just parania. Several time a second is not much. My guess
is that you'll be fine. If it gets slower upgrade your hardware or
reconfigure your OS or/and FS or/and MySQL. Anyway, my string
opinion is that you should split the table. As i said before that
we've
been doing for
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10q=fast+thread+creation+ps=20m=
and
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
Sent: 29 January 2001
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
-Original Message-
From: Nazeem Y [mailto:[EMAIL PROTECTED]]
Sent: 27 January 2001 19:19
To: [EMAIL PROTECTED]
Subject: RAW Device support
Does MySQl syupport RAW devices ?
Thanks
You mean devices that can Read And Write?
Sure.
If you perhaps mean that it can address
Okay, here's one for the guru's out there :)
I have a list of entries with unique id numbers X, and a set of sort methods
(S1 ... Sy).
Now, if I want to get an entry at position P (0...z) in the list of
entries ordered by method S1 then I'd
make the following query:
SELECT X FROM table WHERE
44 matches
Mail list logo