Joeffrey Betita wrote:
hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz,
httpd-2.0.54.tar.gz, php-5.0.4.tar.gz etc. on a Intel(R) Pentium(R) 4 CPU
2.40GHz with 1GB RAM this is just a temporary until we buy a new high end
server. my-large.cnf is the configuration in the
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 schema. However the
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
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!
-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:
Incorrect usage
-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,
Martijn Tonies
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 stored procedures..
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
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
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
-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_word_len
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 schema.
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.
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
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
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 parameter
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 MYSQL.
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.
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,
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
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
1Phys
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,
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.
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
1
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 the
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
1
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(
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]
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]
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
[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]
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
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
Arno Coetzee wrote:
Jason Chan wrote:
I have a student Table and a SubjectGrade table
snip
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
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
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 this:
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
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
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.Grade =
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
[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:
[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
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 outperform
[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]
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 so on,
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.
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
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
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 ON
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
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. Windows?
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
* 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 doesn't.
[/snip]
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 = 'Chem' AND
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
-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
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
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.
-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
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
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
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]
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
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
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
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
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
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
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
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
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
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 SUBclass)
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
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:
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]
75 matches
Mail list logo
