On Friday 06 September 2002 05:39 pm, Ilyas Keser wrote:
What I also not understand is that one can also compile Mysql with
MIT-Pthreads. What is a MIT-Pthread? Where can I read more about this?
Thanks
ilyas
'PThreads' is short for POSIX Threads, which is the Posix API specification
for
On Friday 06 September 2002 05:50 pm, Marcelo Simon wrote:
Well, I'm not 100% certain since I don't know what environment you're working
in, but a typical example from perl might be something like
my $query = INSERT INTO foo
On Monday 02 September 2002 09:27 am, Derk van der Harst wrote:
Hello everyone,
how can I insert records with the Euro sign into the mysql database?
When i try to insert the euro sign i get the err message 'query is empty'.
Can somebody help?
thanks
Derk
What happens if you escape the
On Wednesday 21 August 2002 10:40 am, Egor Egorov wrote:
Well, loosely...
SET AUTOCOMMIT=0
does not START a transaction, what it does is signal the database that from
now on transactions will be explicit, not implicit. That means you NEED to
have a transaction to get anything to stick in the
On Tuesday 20 August 2002 08:00 am, Jim Bailey wrote:
http://www.mysql.com/doc/en/SEC447.html
RTFM, couldn't be more clear, the columns in both master and slave which are
constrained need to be indexed, and yes the FOREIGN KEY and REFERENCES
sections name the INDEXES, not the columns. Its
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote:
NFS locking is ALWAYS problematical. You might have no problems, you might
also be instantly in hell.
Its really hard actually to answer your question. NFS implementations vary
greatly in their quality. In addition it depends on the NICs
On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote:
The key quote from the manual is...
All used tables must be in the same database as the MERGE table itself.
which makes sense. Fundamentally a database is an independent unit of data
storage. You can't share data between two seperate
On Tuesday 20 August 2002 05:52 am, Nick Lazidis wrote:
Its relatively straightforward to do it with a perl script.
Just set up an ODBC data source to the Paradox database and install perl DBI
and the DBD::ODBC and DBD::MySQL drivers. Then you can simply read records
from Paradox via ODBC and
On Monday 19 August 2002 09:12 pm, Jocelyn Fournier wrote:
except, leave off the 'f.' on 'f.count(*)'. Remember there is only one count
of records, the count of returned rows from the join, there is no need to
qualify that with a table identifier... (and I think it would be a syntax
error if
On Tuesday 20 August 2002 01:06 pm, bin cai wrote:
check out www.owasp.org, there are some good links there for various tools,
mostly for correctness and security testing, but it should give you some good
starting points. Check out www.freshmeat.net as well, I am pretty sure some
stuff has
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote:
I am confused. (innodb table type)
I'm really not so sure about the 'lock in share mode' thing, but to the best
of my knowledge if you do a
SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE
and then start a transaction where you read data
On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote:
Hi all,
I'm testing using a HEAP table to maintain transient state in a high
volume TP environment. So far, it looks promising, and I want to ask
anyone about similar experiences and solicit some input.
Some background:
* I have one
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote:
Several things spring to mind here...
1st of all when you use JDBC, you're coding to the JDBC interface, not to any
proprietary interface (IE, your application could just as well call a
PostgreSQL JDBC driver and it would not need to
On Friday 16 August 2002 12:43 pm, Brian Moon wrote:
No, it should be and is scanning through the 500,000+ rows that meet the
key of (approved, datestamp). The table has 1M+ in it. My question is, how
can it be faster? Can it not be faster? Is MySQL on my size server just
not going to
On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote:
I disagree entirely
Persistent connections have little or nothing to do with increasing load!
Given that you mention you are using PHP I'll assume you have mod_php running
in Apache. Each Apache child process in this
On Wednesday 14 August 2002 07:03 am, Balaji Nallathambi wrote:
I think you're expectation is simply wrong.
In MySQL recent versions if you use InnoDB tables you can create a 'foreign
key' constraint. All this means is that you cannot create a record in a
dependent table where the same value
On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might
When the solution is simple, God is answering. - Albert Einstein
From: Tod Harter [EMAIL PROTECTED]
Organization: Giant Electronic Brain
Date: Wed, 31 Jul 2002 09:57:20 -0400
To: Richard Baskett [EMAIL PROTECTED], MySQL [EMAIL PROTECTED]
Subject: Re: Speed issues...
On Wednesday 31
On Friday 02 August 2002 12:47 pm, [EMAIL PROTECTED] wrote:
Lars: I think what you are trying to do is pound a square peg into a round
hole...
MySQL really wasn't designed for this sort of useage. Your selects are going
to be brute force searches on unidexed data, which is exactly why they
On Wednesday 31 July 2002 05:17 am, Richard Baskett wrote:
This is my first post here.. So be nice! ;)
OK, no flames ;o).
I'd want a bit more information in order to really diagnose this. The first
thing I would tell you to do is to EXPLAIN this query. To do that just tack
the keyword
On Wednesday 17 July 2002 09:09, Cal Evans wrote:
I can see where accessing the server from a handheld would be cool but I
question the concept of actually RUNNING the server on a handheld. Write a
cool lightweight client with the library and leave the server on beefier
HW.
There are
On Thursday 11 July 2002 04:20 am, Iago Sineiro wrote:
I vote for Reiserfs personally. I've been running it for a year, its totally
stable, and reasonably fast. ext3 is OK as well, but its slower and at least
in theory does not provide an absolutely guaranteed consistent file system
100% of
On Monday 01 July 2002 10:29, W. Enserink wrote:
Hi all,
You would just do something like
SELECT max(idcolumn)+1 as nextvalue FROM tablename
where idcolumn is the name of the column and tablename is the name of your
table, but remember that you may need to serialize this, since probably the
On Friday 21 June 2002 09:54, Keith C. Ivey wrote:
On 21 Jun 2002, at 15:43, Stefano Incontri wrote:
ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
LOAD is a reserved word in MySQL, so you need backticks
On Friday 21 June 2002 06:55, Arul wrote:
No, but last_insert_id() is only valid until you do another query on the same
database handle. The only explanation I can think of is that somehow you're
code is interjecting some other query between the insert and the call to
last_insert_id(). Maybe
On Thursday 20 June 2002 17:50, Cal Evans wrote:
What you want to do is wrap the update in a transaction with transaction
isolation level set to SERALIZABLE. This should insure that whichever client
is first to initiate the transaction will have effectively exclusive access
to the record in
openLDAP is capable of using various back end data stores, including an SQL
database.
You have to set up MySQL (obviously), and set up MyODBC (which probably means
you will need to install an odbc manager like iodbc or unixodbc), and create
a data source. Then you can reconfigure slapd so it
On Wednesday 22 May 2002 18:44, Dave Watkins wrote:
At 16:02 22/05/2002 +0800, Patrick Hsieh wrote:
Hello list,
I am expecting to have 30,000 http clients visting my website at the
same time. To meet the HA requirement, we use dual firewall, dual
Layer-4 switch and multiple web servers in
Watch out with using the Jet database engine this way. MS Access tries to
keep linked external table views in sync, which means that with large tables
and several PCs running Access linked to MySQL over ODBC driver it will bring
your network to its knees. The Jet engine will constantly be
I disagree. Joins can be expensive. Now PERHAPS Tom's suggestion is a good
one, but its hard to say. Remember, excess fields can always be left out of a
SELECT, so they don't neccessarily cause a performance problem. Some things
are true though, fixed length records are more efficient, so if
On Friday 05 April 2002 11:32, Steve Rapaport wrote:
I'm currently running MySQL for a big, fast app without
problems. BUT:
I'm in the middle of specifying a new application with a high
load, and I'm consideing looking for alternatives to MySQL
because without InnoDB, it gets really slow
On Friday 05 April 2002 02:25, David Williamson wrote:
Hi there,
I will shortly be installing a MySQL server at my place of work, the box I
will be installing it on currently has MS SQL server running as well. (I
believe its a wintel box).
Anyway, I am wondering if there are any known
Well, its tough to compare system configurations in a very general way. I've
run any number of different systems. I can tell you that Sun has some very
nice boxes. A 4 way SMP server with a couple gigs of ram and 1-2 internal 36
gig drives can be had in the 25k price range. They're perfectly
One thing to consider with Perl is that perl 5 and perl 6 are totally
different beasts.
Perl 6 is built on top of parrot, a general purpose register based virtual
machine which is optimized to execute perl and similar languages. There are
already a small test language running on top of parrot
That assumes you believe the myth that Java is really the language of choice
in the back rooms of large enterprise IT shops. It isn't. In the financial
industry perl is ubiquitous. Upper management will tell you Java is god, but
if you actually look at the deployed systems that are out there
On Tuesday 05 March 2002 10:05, Thomas Spahni wrote:
There are some good reasons for wanting to store data directly in the
database, sometimes.
For instance I built an application recently that used blobs. The reason is
simplicity and security. In a web application it is nice to just dump the
On Friday 22 February 2002 00:03, Colin Dewey wrote:
This is an example of a class of problem that crops up in a lot of
applications, like GIS systems all the time.
Unfortunately B-Tree type indexes, like RDBMS systems generally use are just
not well adapted to this type of query. I know
On Thursday 21 February 2002 03:06, Heikki Tuuri wrote:
Oh, Duh. The bigger Oops was mine. Doesn't help much to have a transaction if
you don't ask for a lock! ;o). Thx.
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From:
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a fairly new feature for
MySQL, but its a standard SQL thing. From the manual:
SELECT ...
UNION [ALL]
SELECT ...
[UNION
SELECT ...]
UNION is implemented in MySQL 4.0.0.
UNION is used
On Wednesday 20 February 2002 02:06, Anvar Hussain K.M. wrote:
Hello,
I don't feel the the table sizet will be a problem. But how would the
database function with such a huge number of queries per second.
If I read right, you will be taking a maximum (presently) of 42 channals
each taking
On Wednesday 20 February 2002 05:51, Sasa Babic wrote:
On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
sql,query
The above is for antispam filter.
I have a need for an interval data type. It would contain start and end
of a certain time event. Since it is not possible
On Tuesday 19 February 2002 10:07, Oliver Heinisch wrote:
What would you expect the database to return
You asked it to GROUP all the records with the same preis, that means it has
to choose a value for each column of the record that is the result of each
grouping, correct? So which of the
On Tuesday 19 February 2002 00:48, Todd Goldenbaum wrote:
hi,
I'm wondering if anyone knows if it's possible to do a double-outer join in
mysql. by that I mean outer-joining on two tables instead of one (both
from the same original table). in other words, whereas a normal outer join
might
On Monday 18 February 2002 13:05, Dan Nelson wrote:
In the last episode (Feb 18), Marcelo Iturbe said:
Hello,
Currently I have an aplication which stores the information in an MsSQL
database in a straight forward manner, insert into blah blah
However, I retrieve the information in XML
On Thursday 14 February 2002 09:54, Bryan McCloskey wrote:
Greetings,
How do I get the rows in a table to be in a different
order? I know I can sort a SELECT statement with an
ORDER BY clause, but how do I make this a permanent
adjustment to the table, so that all future SELECTs
will
On Thursday 14 February 2002 07:58, Carl Shelbourne wrote:
Hi
I am trying to write an auction script that uses mysql as its backend. Each
auction can have upto 25 sub auctions(cells) taking place.
I'm trying to query the DB to give me a list of all the successfull bids
for each cell, for
On Thursday 07 February 2002 14:53, Brian DeFeyter wrote:
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the
On Thursday 07 February 2002 14:53, Brian DeFeyter wrote:
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in it.
Now all of a sudden I have a client with a requirement for a database that we
estimate will be in the range of 1 to 4 TERABYTES of
On Tuesday 29 January 2002 12:40, Sinisa Milivojevic wrote:
Tod Harter writes:
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in
it.
Now all of a sudden I have a client
50 matches
Mail list logo