Hi,
I am a Computer Science student here at IIIT hybd and our team is
going to implement a speculative lock manager in MySql 4.0 or higher.
Can someone Plz tell if the mysql code shipped with FC2 has Two
Phase Locking? or does any other version has it? or if any other
commercial version has
I'm compiling my mysql server from source.
I have started noticing this as of 4.1.10 - in fact, I was running
4.1.12 and it's changed the LinuxThreads detection (since LT does not
exist on amd64) - and 4.1.12 kept locking up after only a few minutes
of uptime consistently.
Once I figured this ou
Gleb Paharenko wrote:
Hello.
Use skip-innodb, this should prevent MySQL from InnoDB initialization.
Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote:
Hello!
Do You know if myISAM-specific settings have any impact on database
performance,
if the only MyISAM database is mysql?
I know that ther
Mathias wrote:
sorry if i wasn't clear. i mean not select puchase_date, but max(purchase_date),
i.e. use having clause.
The join field is certainly customerId, or There is not sufficient info on
tables.
Hope that helps
:o)
Mathias
How would you do that with HAVING?
I believe the subque
[EMAIL PROTECTED] wrote:
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30 AM:
Hi,
is there anyway that I can have more than 20 digits for integer
(bigInt)? If not, what I can use for database index?
BIGINT UNSIGNED can range from 0 to 18446744073709551615
(http://dev.mysql.co
Selon Michael Stassen <[EMAIL PROTECTED]>:
> Kapoor, Nishikant wrote:
>
> > [Sorry for cross-posting.]
> >
> > This is in continuation with the above mentioned subject - I am trying to
> > find the 'display data order' for the returned resultset. The following
> > thread very well answers my
Selon Michael Stassen <[EMAIL PROTECTED]>:
> Mathias wrote:
>
> > Selon Russell Horn <[EMAIL PROTECTED]>:
> >
> >>This must have come up before, but I've not found it using a google
> >>search.
> >>
> >>I have two tables customer and purchases
> >>
> >>customer:
> >> customerID
> >> customerName
Michael Stassen wrote:
> Mysql reports the first thing it didn't understand, which isn't
> necessarily the first thing wrong. I note that it thought \' was a
> command, which implies it didn't see the preceding ' as the *start* of
> a string, which implies something went wrong earlier in the line
Daniel Kasak wrote:
Hi all.
I'm testing out mysql-5.0.7. I dumped a database from 5.0.4 with the
command:
mysqldump --opt DB_NAME > DB_NAME.sql -p
Now I'm importing with:
mysql DB_NAME < DB_NAME.sql -p
The data has a field which has some quotes in it. The field looks like
this ( all quotes in
Kapoor, Nishikant wrote:
> [Sorry for cross-posting.]
>
> This is in continuation with the above mentioned subject - I am trying to
> find the 'display data order' for the returned resultset. The following
> thread very well answers my question:
>
> http://lists.mysql.com/mysql/185626
>
> a) SET
Daniel Kasak wrote:
>The data has a field which has some quotes in it. The field looks like
>this ( all quotes included ):
>'' ''
>
>ie 2x single quotes, a space, and 2x single quotes.
>Don't ask me why. I didn't put it there. Anyway, mysqldump has packaged
>this field as follows:
>'\'\' \'\''
>
Hi all.
I'm testing out mysql-5.0.7. I dumped a database from 5.0.4 with the
command:
mysqldump --opt DB_NAME > DB_NAME.sql -p
Now I'm importing with:
mysql DB_NAME < DB_NAME.sql -p
The data has a field which has some quotes in it. The field looks like
this ( all quotes included ):
'' ''
ie 2x
Mathias wrote:
Selon Russell Horn <[EMAIL PROTECTED]>:
This must have come up before, but I've not found it using a google
search.
I have two tables customer and purchases
customer:
customerID
customerName
purchases:
purchaseID
customerID
purchaseDate
purchaseValue
Is it possible in
Jerry Swanson wrote:
How to make this work?
field like '%DATA_FORMAT(now(), '%m%d%y') %'
field LIKE CONCAT('%',DATE_FORMAT(now(), '%m%d%y'),'%');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to make this work?
field like '%DATA_FORMAT(now(), '%m%d%y') %'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Selon Russell Horn <[EMAIL PROTECTED]>:
> This must have come up before, but I've not found it using a google
> search.
>
> I have two tables customer and purchases
>
> customer:
> customerID
> customerName
>
> purchases:
> purchaseID
> customerID
> purchaseDate
> purchaseValue
>
> Is
This must have come up before, but I've not found it using a google
search.
I have two tables customer and purchases
customer:
customerID
customerName
purchases:
purchaseID
customerID
purchaseDate
purchaseValue
Is it possible in MySQL to join the tables so I only get the value of
t
Wow - so easy! What a dork. Thanks guys. :) :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 28/06/05, Brian Dunning <[EMAIL PROTECTED]> wrote:
> Hi all -
>
> I have an urgent need to update several million records. There is a
> URL stored in a MySQL 'text' field. Many of the records contain
> "1234" like this:
>
> http://www.domain.com?etc=etc&arg=1234&etc=etc
>
> Any occurence of "
Selon Brian Dunning <[EMAIL PROTECTED]>:
> Hi all -
>
> I have an urgent need to update several million records. There is a
> URL stored in a MySQL 'text' field. Many of the records contain
> "1234" like this:
>
> http://www.domain.com?etc=etc&arg=1234&etc=etc
>
> Any occurence of "1234" has to be
Hi all -
I have an urgent need to update several million records. There is a
URL stored in a MySQL 'text' field. Many of the records contain
"1234" like this:
http://www.domain.com?etc=etc&arg=1234&etc=etc
Any occurence of "1234" has to be changed to "5678" like this:
http://www.domain.co
The USPS has been de-emphasizing the usage of carrier-routes for several
years now. They will eventually phase them out completely in lieu of
other schemes, including enhanced line-of-travel (ELOT), etc. The pool
of eligible carrier-routes decreases every month (from the mailer's
perspective).
Dir
One compromise between the large 5 digit zips and the 9-digit zip+4's
is carrier route. There are about 600,000 carrier routes in the USA
each denoted by the 5-digit zip and the carrier route, for example
34685-R036. 600,000 is certainly more manageable than 70,000,000
zip+4's. Does anyone know
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
>
> > Selon [EMAIL PROTECTED]:
> >
>
> >
> > Thanks Shawn, but i'm not speaking about data consistency during
> > transaction and
> > isolation levels.
> > I spoke about what is seen in the data dictionary as
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
> Selon [EMAIL PROTECTED]:
>
>
> Thanks Shawn, but i'm not speaking about data consistency during
> transaction and
> isolation levels.
> I spoke about what is seen in the data dictionary as num_rows an why
> it can not
> be used ev
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
>
> > Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> >
> > > Mathias,
> > >
> > > Thanks a lot!
> > >
> > > > I will not explain the same thing for sqlserver, sybase ..., but
> when
> > > > your RDBMs
> > > >
Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>:
>
> > -Original Message-
> > > This is in continuation with the above mentioned subject -
> > I am trying to
> > > find the 'display data order' for the returned resultset.
> > The following
> > > thread very well answers my question:
> > >
>
Hello.
Use skip-innodb, this should prevent MySQL from InnoDB initialization.
Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote:
> Hello!
> Do You know if myISAM-specific settings have any impact on database
> performance,
> if the only MyISAM database is mysql?
> I know that there are som
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
> Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
>
> > Mathias,
> >
> > Thanks a lot!
> >
> > > I will not explain the same thing for sqlserver, sybase ..., but
when
> > > your RDBMs
> > > have a data dictionnary, you don't need to exec
Hello Mike,
On 27 Jun 05, mos wrote to mySQL list:
>> How can I prevent duplicate entries when I fill the data base with
>> "load data"? I tried ignore, but that has no effect.
m> Ignore/Replace will only work on Unique keys and I bet your key is
m> not unique. If you make it unique, then Ign
http://www.buyzips.com/platinum-expanded.htm
This one also says it's only updated every 6 months. Ouch!! Another
reason I recommend Zipwise instead. Cheaper and fresher data:
http://www.zipwise.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
A lot cheaper here:
http://www.zipwise.com/database-download-now.php
On Jun 28, 2005, at 5:30 AM, Mattias Håkansson wrote:
This one goes for $169, and you get longitudes and latitudes.
http://www.buyzips.com/platinum-expanded.htm
Regards,
Mattias Håkansson
- Original Message -
From
Just remember, there is a big difference in 5-digit ZIPs which cover a
large area (can be many miles in width and height) and 9-digit ZIP+4's
which usually cover a city block. Zip+4 lat/lngs provide greater
accuracy for accurate radius analysis of say a list of mailing
addresses for a mailing c
> -Original Message-
> > This is in continuation with the above mentioned subject -
> I am trying to
> > find the 'display data order' for the returned resultset.
> The following
> > thread very well answers my question:
> >
> > http://lists.mysql.com/mysql/185626
> >
> > a) SET @row=0;
Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>:
> [Sorry for cross-posting.]
>
> This is in continuation with the above mentioned subject - I am trying to
> find the 'display data order' for the returned resultset. The following
> thread very well answers my question:
>
> http://lists.mysql.com/my
On Tuesday 28 Jun 2005 15:19, [EMAIL PROTECTED]
wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
>
> http://lists.mysql.com/u/mysql/42c15c7a3623a14d/partners=
>symbulos.com
>
> This confirmation serve
[Sorry for cross-posting.]
This is in continuation with the above mentioned subject - I am trying to find
the 'display data order' for the returned resultset. The following thread very
well answers my question:
http://lists.mysql.com/mysql/185626
a) SET @row=0;
b) SELECT (@row:[EMAIL PROTECTE
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 28/06/2005 14:36:37:
> Hello,
> I am reading the docs, but I am slightly confused.
>
> I have a table with a varchar(50) column (not a primary column)
> where I do not want duplicates. It is a properties column, and I am
> getting duplicates inserted
>> From: Scott PurcellDate: June 28 2005 3:36pm
>> Subject: create unique index
>>
>> Hello,
>> I am reading the docs, but I am slightly confused.
>>
>> I have a table with a varchar(50) column (not a primary column) where I =
>> do not want duplicates. It is a properties column, and I am getting =
Hello,
I am reading the docs, but I am slightly confused.
I have a table with a varchar(50) column (not a primary column) where I do not
want duplicates. It is a properties column, and I am getting duplicates
inserted, which is causing problems in my display.
An Oracle DBA that works with me su
This one goes for $169, and you get longitudes and latitudes.
http://www.buyzips.com/platinum-expanded.htm
Regards,
Mattias Håkansson
- Original Message -
From: "Jack Lauman" <[EMAIL PROTECTED]>
To: "MySql"
Sent: Monday, June 27, 2005 2:29 AM
Subject: Calculate LONG/LAT from ZIP+4
>
Hello!
Do You know if myISAM-specific settings have any impact on database
performance,
if the only MyISAM database is mysql?
I know that there are some default settings and I wonder if for example
memory buffers are allocated even if they are not used? Is it necessary
to disable those setting
Hassan Schroeder wrote:
mm wrote:
There is a lot a pain here.
I downloaded the rpm packages
that's where the pain starts :-)
If you're trying to run multiple versions of MySQL for pre-migration
testing (or whatever), *don't use rpms* -- get the tar file of the
binary, and just untar it as
There are about 70 million ZIP+4's in the USA. Buying a data file that
you can import into your own database typically costs around $10,000
from the small handful of companies that actually compile the data!
However, there are data broker companies such as Melissa Data
(http://www.melissadata.c
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Mathias,
>
> Thanks a lot!
>
> > I will not explain the same thing for sqlserver, sybase ..., but when
> > your RDBMs
> > have a data dictionnary, you don't need to execute count(*) :o) WITH
> > Updated
> > statistics of course.
>
> I'm a little bit
Mathias,
Thanks a lot!
I will not explain the same thing for sqlserver, sybase ..., but when
your RDBMs
have a data dictionnary, you don't need to execute count(*) :o) WITH
Updated
statistics of course.
I'm a little bit confused here. Why the count(*) is not transformed to a
select from
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Hi all
>
> I was reading the High Performance MySQL book (by O'Reilly) and there
> was mentioned that executing a count(*) is slower on the InnoDB
> engine compared to the MyISAM engine, because InnoDB tables do not keep
> track of the number of the
Hello.
You could import data in the temporary table and then use a full
power of INSERT... SELECT statement. For example:
INSERT into t1 select col1,col2,curdate() from tmp_t1;
David Perron <[EMAIL PROTECTED]> wrote:
> Im trying to get dynamically insert the current date into
Hello.
Complete information about licensing policy you can receive
from [EMAIL PROTECTED]
"Behrang Saeedzadeh" <[EMAIL PROTECTED]> wrote:
> Hi
>
> We've developed a J2EE application for one of our customers. Currently,
> the system uses SQLServer as the backend database. The databse sy
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.5.1)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, man
Hi
We've developed a J2EE application for one of our customers. Currently,
the system uses SQLServer as the backend database. The databse system
is not embedded with the J2EE application and we can safely switch to
other RDBMSes.
I wanted to know that if we change the RDBMS from SQLServer to MyS
Hi all
I was reading the High Performance MySQL book (by O'Reilly) and there
was mentioned that executing a count(*) is slower on the InnoDB
engine compared to the MyISAM engine, because InnoDB tables do not keep
track of the number of the records. I just wanted to know that if
this performance d
52 matches
Mail list logo
