> -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 wrot
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..
> >
>
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, articlete
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
MyIS
> -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 o
> -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?
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 ther
Dear List,
I need to store a set of flags in SQL, as in 20 true or false values.
The logical choice seems to be the SET type,
but does it use an index? The manual gives an examle where a set is
queried with LIKE '%flag%'. That scares me a bit,
because the table is going to contain hundredthous
>
> 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 will
>
> 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.
> 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
>
> > 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 G
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 PRO
> 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 post
>
> 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
k violation.
>
> Then, Marten, tell us what the status 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&quo
>
> 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 Nu
> Hi!
>
>
>
> 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
>
> "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 h
> 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 AB and I am disgusted that mysql.org has chosen
> to so
My vote goes to a my.cnf configuration file. (/etc/my.cnf - or one of
the other possible locations)
It is, after all, a configuration option.
[Raid]
directory1=/disk1/mysql
directory2=/disk2/mysql
directory3=/disk3/mysql
etc..
> -Original Message-
> From: Markwalder Philip [mailto:[EMA
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] [mailt
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: Unicod
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
&
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 Fr
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
Sent: 29 April 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.
> > >
>
> 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/documentation/mysql++/5_Class.html
-
Before posting, please check:
http://ww
> 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 auto
> OS: Red Hat Linux 6.0 / Intel
> 1GB RAM
>
> MySQL 3.23.36
> PHP4.0.4PL1
> Linux kernel 2.4.3
> Using the my.cnf for medium sized sites
>
> mySQL starts with safe_mysqld and there are three threads
> running. Queries come in and out and it's quite fast. Using
> mysqladmin proc status shows n
> 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 t
"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 e
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 retri
>
> 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 &
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: 29 March 2001 14:56
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: MySQL++ Compile / link problems on freebsd
>
>
> Sander Pilon writes:
>
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
..
If you want to make a LARGE (millions of documents, gigabytes of data)
searchengine, you'd better know something about searchengine algorithms :)
I'll give you one hint - A database is not a searchengine. A database is not
meant to be a searchengine. And, until some decent text-processing/searchi
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 have
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 reiserfs
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 Message
> -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 th
> 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
> expe
>
> > 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
>
> > 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
> > >
>
> > > [1 ]
> > > 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
> > > scripts relie
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10&q=fast+thread+creation+&ps=20&m=
and
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
> Sent: 29 Januar
> -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 ... S).
Now, if I want to get an entry at position P (0...) in the list of
entries ordered by method S1 then I'd
make the following query:
SELECT X FROM table WHERE
51 matches
Mail list logo
