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
VALUES(".$cgi->param('myintfield').",'".$cgi->param('mydatefield
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
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
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 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 f
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 sho
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 y
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 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 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 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
FO
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 be
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 hav
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 h
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 be
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 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 configuration
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 are
ess likely to
> run into errors, but if it would speed things up.. By all means I will take
> them out! yes?
>
> Cheers!
>
> Rick
>
> "When the solution is simple, God is answering." - Albert Einstein
>
> > From: Tod Harter <[EMAIL PROTECTED]>
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 EXPLAI
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 act
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 th
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 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 qu
On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote:
> IMHO, the interesting question is: how could the tables get out of
> sync, in a way that foreign keys would be able to prevent? I am not
> able to see a way in everyday work (explicitly filling in nonsense
> does not count).
>
> The only
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 a
On Friday 21 June 2002 08:31, Roger Baklund wrote:
> * Podhorski, Adam
use the perl "chomp()" function... It strips off any sort of "newlinish"
trash at the end of the line, then explicitly tack a '\n' onto the end before
you feed it to MySQL. Esp on windows machines this is a good idea, newlin
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 b
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 s
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 w
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 yo
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 scann
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 know
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 s
On Wednesday 03 April 2002 13:25, Russell E Glaue wrote:
> I am an avid PERL programmer, I also know java. I cannot completely agree
> with either of you.
> However, this debated subject is best discussed in another community.
> The focus here is what has the necessary abilities/functionality to c
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 ni
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 do
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
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 Infor
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-
> Fr
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
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 t
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 t
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
>
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 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 informa
On Tuesday 12 February 2002 09:16, Rich wrote:
> David yahoo wrote:
> > hi all,
> >
> > This question is a little like the suse update.
> > But perhaps I could find answer.
> >
> > I have a mandrake distrib with rpm support, u know that mandrake is
> > derive from redhat.
> >
> > Can I install a m
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,
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 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 qu
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 qu
On Thursday 07 February 2002 11:07, Tibor Radvanyi wrote:
> Hi Everyone,
>
> I'm newbie with MySQL with some programming experience.
> I'm about to implement an Internet shop. I would like to serve my
> customers at a high level with, amongst other features, making sure that
> every successful ord
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
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 data...
55 matches
Mail list logo