I can't resist... neither Mac OS X! lol
Dan T
On Aug 12, 2005, at 8:46 AM, Brian Dunning wrote:
Same machine, any performance difference?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Scott,
Is there any database file similiar to M$'s Northwind that I can use to play
with? It would be nice if there is one inside MySQL by default for newbies
to start out with.
Microsoft's document often used Northwind as an example to teach functions.
How about FlightStats:
http://d
I just thought of a possible solution. Instead of
listing all the phyla, orders, classes, families,
genera and species in one big table, create separate
tables for each taxonomic level.
Each taxon would then have two parents. the genus Sus'
(pigs) parents would be both the subfamily Suinae and
fam
Suppose I want to create an animal kingdom database
that gives me the option of displaying the following
taxonomic hierarchies:
1) A bread crumbs navigation string, including ALL
taxons; e.g. Animalia (kingdom) > Chordata (phylum) >
Vertebrata (a SUBphylum) > Mammalia (class) > Eutheria
(a SUBclas
MySQL is written with UNIX-like operating systems in mind. MySQL for
Windows does not currently take advantage of many of the powerful
scalability features of Windows NT based operating systems (2000, XP, 2003),
as stated in the documentation. I happen to be one of the people working to
make
> mysql Ver 12.22 Distrib 4.0.20, for mandrake-linux-gnu (i586)
With 4.1, it might have been a little easier using some subqueries.
But with 4.0, I don't think we can get the results you're looking for
in a single query, without some really nasty setup. Part of the issue
is that we need to join
To the powers that be: Can we get a MySql GIS/spatial list?? This is
going to be a very popular area (actually it is already).
I am trying to use the Spatial extensions to MySql. To be honest
PostGIS has many more features, but MySql is my favorite, and on top of
that, the applications I
Thanks Devananda.. it helped.
- javabuddy.
People are conversing... without posting their email or filling up their mail
box. ~~1123878070408~~
roomity.com http://roomity.com/launch.jsp No sign
javabuddy wrote:
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
Are you sure you've thought your index through correctly and considered how
MySQL will use it? What sort of query would such an in
javabuddy wrote:
Thanks
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
- Gana.
People are con
Thanks
But still I can't get the part where my column size totals to 560, but MySql
complaining that I have exceeded 1024. Did I went anywhere wrong???
- Gana.
People are conversing... without
If you are on a version prior to 4.1.2 the max index size is 500 bytes
{not sure why the error mentions 1024}
>From section 14.1 of documention
The maximum key length is 1000 bytes (500 before MySQL 4.1.2). This can
be changed by recompiling. For the case of a key longer than 250 bytes,
a larger
Folks,
Go with what you know best. If you are a good Windows admin etc go with
windows. If you are a good Linux/Unix admin go with Linux. What little
performance gain from one or the other will be lost if you do not run a
tight ship all around. Performance and stability goes way beyond what
OS
lack of a primary key was the problem.
I am surprised the problem didnt show up in 3.23
but did in 4.12
Thanks for the suggestions!
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to create an index with multiple fields.
The sixe of each of the column is listed and thier sum is 560bytes. But when I
try to create an index with the colums, it complains on the size exceeded 1024
bytes. Below is the query and the size of each..
create index selectTechnologyClubs
Hi,
I've made it work with DUMPFILE but its a BIG workaround for my php
aplication:
To insert I have to read the file received from the browser $_FILES[tmp_name]
placed it in a directory for MySQL to read it, and them insert it into MySQL
table with LOAD_FILE
To extract I have to use DUMPFILE a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 5.0.11-beta, a new version of the popular Open Source Database Management
System, has been released. The Community Edition is now available in source and
binary form for a number of platforms from our download pages at
http://dev.mysql.com/d
Pat Adams wrote:
> Even though Linux more or less acts like its big UNIX cousins, the nitty
> gritty
> details of system administration, security, and patching are much difference.
Ah, not really. In the *nix world, I first encountered Linux, then HPUX, then
AIX, then
Linux again, then Solaris
The original sql query returned nothing. 0 rows.
The second (with a left join) returned a record for every date avaiable,
but a 0 in all others fields. (0 shipments, 0 undelivered, 0 returned, 0
open, etc)
Im not sure if we can solve this with a join, since each colum does have
a different set of
-Original Message-
From: James M. Gonzalez
Sent: 12 August 2005 16:58
To: 'Scott Noyes'
Subject: RE: Complex query. (It's killing me)
Sorry, I will explain myself more clearly:
Everyday, we ship packages, and we also receive some packages.
The one we receive, has been shipped by us s
Please note that this answer is not meant to support one OS or another,
but the information on that page is not useful. The information is
seriously out of date. The comparison is
on Windows NT not Server 2K3 or XP. The hardware is Pentium Pro 400 or
AMD K6II-350 with old versions of softw
Thanks Scott!
"Scott Noyes" <[EMAIL PROTECTED]> ???
news:[EMAIL PROTECTED] ???...
> SELECT s.StudentID, StudentName
> FROM Student s
> JOIN StudentGrade sg1 USING (StudentID)
> JOIN StudentGrade sg2 USING (StudentID)
> WHERE
> sg1.Subject = 'Maths' AND sg1.Grade = 'A'
> AND sg2.Subject = 'C
* Jay Blanchard <[EMAIL PROTECTED]> [050812 07:32]:
> [snip]
> On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote:
> > [snip]
> > Same machine, any performance difference?
> > [/snip]
> >
> > Yes. Linux will consistently outperform Windows in many areas.
>
> Except for those areas that it doe
The first thing I would do is to upgrade the Kernel, as per you r mail
u said u were running 2.4.20-8, get the latest one for RH9 that is
2.4.20-31.9 SMP, and you might see a huge difference, if it doesn't
work, then make sure you have properly indexed the colums, mytop is a
great tool for diagnos
On Fri, 2005-08-12 at 09:30 -0600, Duke, Brian wrote:
> Like crashing, auto-rebooting, memory leaking, program cost, etc...
>
> -Original Message-
> From: Pat Adams [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 12, 2005 9:21 AM
> To: mysql@lists.mysql.com
> Subject: RE: Linux vs. Win
Sorry - I think you need a LEFT JOIN or it won't count shipments which are
not returned.
Alec
[EMAIL PROTECTED]
12/08/2005 16:38
To
[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Complex query. (It's killing me)
Just in the spirit of refining my own skills, here is how I w
Just in the spirit of refining my own skills, here is how I would tackle
the problem. It parses, but I haven't populated the tables so I don't know
if it works:
SELECT s.dateshipped, COUNT(r.type="undelivered"), COUNT(r.type =
"customer"), COUNT(r.status="open")
FROM shipments s JOIN returns r
> Shipped Undelivered Returned Open
> 12/8/2005 143 3 3
Does this mean of the 14 shipped on 12/8/2005, 3 were returned at some
later date, or does it mean that you shipped 14 on 12/8/2005, and on
that same day 3 unrelated shipments came back, each of which co
Jason Chan wrote:
> I have a student Table and a SubjectGrade table
>
> Create Table Student(
> StudentID INT NOT NULL,
> StudentName VARCHAR(30)
> )
>
> Create Table SubjectGrade(
> StudentID INT NOT NULL,
> Subject VARCHAR(30) NOT NULL,
> Grade CHAR(1)
> )
>
> let's say have following record in
Like crashing, auto-rebooting, memory leaking, program cost, etc...
:)
Brian Duke
Level(3) Communication
==-=-=-=-=--==--==¬
-Original Message-
From: Pat Adams [mailto:[EMAIL PROTECTED]
Sent: Friday, August 12, 2005 9:21 AM
To: mysql@lists.mysql.com
Subject: RE: Linux vs. Windows
> SELECT s.StudentID, StudentName
> FROM Student s
> JOIN StudentGrade sg1 USING (StudentID)
> JOIN StudentGrade sg2 USING (StudentID)
> WHERE
> sg1.Subject = 'Maths' AND sg1.Grade = 'A'
> AND sg2.Subject = 'Chem' AND sg2.Grade = 'A'
> So i have to write 3 join if I have 3 conditions and s
[snip]
> "creakcreakcreak"
> - the sound of a rusty old can of worms being opened...;)
[/snip]
Except when it's already open.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/12/05, Jay Blanchard <[EMAIL PROTECTED]> wrote:
>
> [snip]
> I am willing to bet you I can write a more scalable higher performing
> socket
> server using NT I/O Completion Ports than you can write using Linux's
> epoll.
>
> It you're running a 32 cpu system, Windows will consistently outper
[snip]
I am willing to bet you I can write a more scalable higher performing
socket
server using NT I/O Completion Ports than you can write using Linux's
epoll.
It you're running a 32 cpu system, Windows will consistently outperform
Linux in many areas.
My point is, blanket statements like this
[snip]
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote:
> [snip]
> Same machine, any performance difference?
> [/snip]
>
> Yes. Linux will consistently outperform Windows in many areas.
Except for those areas that it doesn't.
[/snip]
True.
--
MySQL General Mailing List
For list archives:
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote:
> [snip]
> Same machine, any performance difference?
> [/snip]
>
> Yes. Linux will consistently outperform Windows in many areas.
Except for those areas that it doesn't.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
s
So i have to write 3 join if I have 3 conditions and so on, right?
"Scott Noyes" <[EMAIL PROTECTED]> ???
news:[EMAIL PROTECTED] ???...
> Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
> s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject =
'Chem'
> and sg.Gr
Hello list, I got a sql query that's is just beating me (5-0). Have have
read here and there, and MySQL Query Browser is just fed up with all the
tries I have made it do. It is just not working.
First, the tables (simplified version, if need more info just tell me):
[shipments]
ID int
DateShippe
I am willing to bet you I can write a more scalable higher performing socket
server using NT I/O Completion Ports than you can write using Linux's epoll.
It you're running a 32 cpu system, Windows will consistently outperform
Linux in many areas.
My point is, blanket statements like this aren
I havn't write my schema clearly , (StudentID, Subject) is the key of
SubjectGrade
"Philippe Poelvoorde" <[EMAIL PROTECTED]> ???
news:[EMAIL PROTECTED] ???...
> Alternatively, use an IN list for the subject, then use a HAVING clause
> to limit the results to students with 2 matching rows, like th
Il giorno 12/ago/05, alle ore 16:46, Brian Dunning ha scritto:
Same machine, any performance difference?
go to
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/information/
benchmark-results/result-mysql-platform-relative.html
anyway the difference isn't only in performance what
Arno Coetzee wrote:
Jason Chan wrote:
I have a student Table and a SubjectGrade table
I want to find out students who have got A in both Maths and Chem
How the SQL look like?
select s.StudentID , s.StudentName
from Student as s , SubjectGrade as sj
where s.studentID = sj.studentID and s
Jason Chan wrote:
>I have a student Table and a SubjectGrade table
>
>Create Table Student(
>StudentID INT NOT NULL,
>StudentName VARCHAR(30)
>)
>
>Create Table SubjectGrade(
>StudentID INT NOT NULL,
>Subject VARCHAR(30) NOT NULL,
>Grade CHAR(1)
>)
>
>let's say have following record in SubjectGrad
On Fri, 12 Aug 2005, Jay Blanchard wrote:
Yes. Linux will consistently outperform Windows in many areas.
Except Dilbert's boss's approval queue.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Py
[snip]
Same machine, any performance difference?
[/snip]
Yes. Linux will consistently outperform Windows in many areas.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Alternatively, use an IN list for the subject, then use a HAVING clause
to limit the results to students with 2 matching rows, like this:
SELECT StudentID, StudentName
FROM Student s
JOIN SubjectGrade sg ON s.StudentID = sg.StudentID
WHERE sg.Subject IN ('Maths', 'Chem')
AND sg.Gra
> Same machine, any performance difference?
"creakcreakcreak"
- the sound of a rusty old can of worms being opened...;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Same machine, any performance difference?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jason Chan wrote:
I am using mysql 4.0.25 with no subquery support : (
"Jason Chan" <[EMAIL PROTECTED]> ¦b¶l¥ó news:[EMAIL PROTECTED]
¤¤¼¶¼g...
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
St
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1Math
> Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
> s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem'
> and sg.Grade = 'A'
Take a close look at the WHERE clause: "sg.Subject = 'Maths' and
sg.Subject = 'Chem'" will never return a result - how could
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1Maths
Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem'
and sg.Grade = 'A'
The key here is using the aliases for the tables. The linking of the tables
comes in the s.StudentID = sg.StudentID statement.
I am using mysql 4.0.25 with no subquery support : (
"Jason Chan" <[EMAIL PROTECTED]> ¦b¶l¥ó news:[EMAIL PROTECTED]
¤¤¼¶¼g...
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1MathsA
1PhysB
I would like to install MySQL 5.0.x beta into two computers and test them.
They will run Windows XP Home Edition (of course with massive updates and
whatsnot) and Linux (SlackWare 10.0 vanilla). I am familiar with Registry
Editor and bash shell scripting for /etc start up directory in technical
Hello.
SERIALIZABLE is like REPEATABLE READ, but all plain SELECT statements are
implicitly converted to SELECT ... LOCK IN SHARE MODE. In REPEATABLE
READ statements like SELECT ... LOCK IN SHARE MODE that use a unique
index with a unique search condition lock only the index record found,
no
Hello.
EXECUTE is not operational until MySQL 5.0.3. Don't use in 4.1. See:
http://dev.mysql.com/doc/mysql/en/grant.html
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> For some reason, GRANT EXECUTE is possible on the global level,
> but not on the database level:
>
Hello.
Use SHOW PROCESSLIST and slow-query log to catch the query which locks
tables for a long time. Upgrade to 4.1.13. If you use MyISAM, think
about moving towards InnoDB.
Aaron <[EMAIL PROTECTED]> wrote:
> Hi all ,
>
> I have been experiencing intermittent locking issues with MY
Bendick Mahleko <[EMAIL PROTECTED]> wrote on 08/12/2005 07:48:27
AM:
> Hello Mark,
>
> I am indexing scientific data, where each word is potentially more than
> 255 in length. So the point is, there doesn't seem to be a way to change
> the maximum word length (via 'ft_max_word_len' - the para
I know it's bad form to reply to yourself but I just found a major mental
mistake in my response. See embedded:
[EMAIL PROTECTED] wrote on 08/12/2005 12:18:21 AM:
> Sebastian <[EMAIL PROTECTED]> wrote on 08/11/2005 01:19:30
PM:
>
> > well i managed to solve the problem myself, and im no sql ge
Bastian Balthazar Bux wrote:
We need to track the modification to the records too so the route has
been to keep them all in a different, specular databases.
If the "real" table look like this:
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`ts` timestamp NOT NULL
default
Hello Mark,
I am indexing scientific data, where each word is potentially more than
255 in length. So the point is, there doesn't seem to be a way to change
the maximum word length (via 'ft_max_word_len' - the parameter defining
the maximum length of any word as you pointed out) beyond 255. Wh
Saqib Ali wrote:
> Hello All,
>
> What are best practices for deleting records in a DB. We need the
> ability to restore the records.
>
> Two obvious choices are:
>
> 1) Flag them deleted or undeleted
> 2) Move the deleted records to seperate table for deleted records.
>
> We have a complex sc
> -Original Message-
> From: Bendick Mahleko [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 12:22
> To: mysql@lists.mysql.com
> Subject: how to change ft_max_word_len value beyond 254
>
> Hello,
> I want to index a table using a TEXT value, with length >
> 255. I tried changing ft_max_
Hello,
I want to index a table using a TEXT value, with length > 255. I tried
changing ft_max_word_len but each time I check the status of variables,
I notice the changes are not taken. It defaults to 254. I am able to
change this value to anything below 254. Is there any other way to
enforce
Hello,
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new database(yes its default
charset is Utf8) the default character set for the table is U
Hi!
Some days ago, there was a debate on this list about the visibility of
passwords using "ps" if they were given on the command line.
I have just come across this text. While it talks about the process
name, the info still applies to command line arguments as well:
| 1.13 How do I change
> > For some reason, GRANT EXECUTE is possible on the global
> > level, but not on the database level:
> > "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
> >
> > Has anyone got any idea what EXECUTE should do on a global
> > level in MySQL 4.1?
>
> Martin,
>
> EXECUTE is specifically for stor
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 10:43
> To: mysql@lists.mysql.com
> Subject: "mysql" database characterset
>
> Hi there,
>
> Is the "mysql" database always in UTF8 characterset for MySQL
> 4.1 and up?
>
> With regards,
>
> M
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 09:40
> To: mysql@lists.mysql.com
> Subject: GRANT EXECUTE in MySQL 4.1
>
> Hi there,
>
> For some reason, GRANT EXECUTE is possible on the global
> level, but not on the database level:
> "Inco
Hi there,
Is the "mysql" database always in UTF8 characterset for MySQL 4.1 and up?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www
Hi there,
For some reason, GRANT EXECUTE is possible on the global level,
but not on the database level:
"Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
Has anyone got any idea what EXECUTE should do on a global
level in MySQL 4.1?
With regards,
Martijn Tonies
Database Workbench - tool for
73 matches
Mail list logo
