Problem description:
> > CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3
> > -unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql
> > --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static
> > --with-mysqld-ldflags
Matt and David, thanks for your help. Cheers from Argentina,
Rodrigo
Matt Chatterley wrote:
Yep. Theres no reason at all why this sort of thing won't work for MSSQL
too. Use SQL Enterprise Manager to generate a create script for all objects
in the database, and also tell it to script referential
Hi,
I wanna ask about InnoDB...
I've been trying InnoDB for sometimes and I found out one thing weird that is :
"When I make an InnoDB tables and filled it with some records ..it took about 2 Mb of
file's capacities..
but when I delete all the records... the file's capabilities just still 2 Mb
I have been trying for months to set up mysql on my Mac (Panther) with
no success. I can't run mysqladmin as root. I get an access denied
error message. If I try to use SHELL>mysqladmin -u root password
'password' I get access denied as either root or the regular user. I
can't run mysql as r
Hi Matt,
if Steve can accept the limitations, mysqlhotcopy might work for him:
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
If not, mysqldump with --add-locks could do it fairly easily, I should
think...
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Saturday, April 10, 2004, 5:08:43
Don't use rsync. Try rdiff-backup, its much more reliable and offers
rolling restoration.
On Sat, 2004-04-10 at 02:08, Matt W wrote:
> Hi Steve,
>
> You might want to look at FLUSH TABLES WITH READ LOCK. That's a query
> to run from mysql, but I'm sure you can get it to work in your shell
> sc
Hi,
I found some problematic queries which locks mysql server any further
processing. I'm using mysql-4.0.18
from FreeBSD ports collection. I'm using FreeBSD-5.2-CURRENT.
Some of the queries like :
select sum(total_amount) pbc from customers.payment where contract_id>=0
and contract_id<=4999 an
On Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following:
> Problem solved. ):
Well, it wasn't a problem with mysql per sey but a problem with how I was
entering the command.
The man page says
/usr/bin/mysqladmin -u user -p somepassword
is correct as is
/usr/bin/mysq
Steven,
In your case, you query doesn't even use an index. And you are using an
order by DESC. Now what I would recommend is something like this, change
your query just to test this out.
SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft
BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT 0,30
on 04/11/2004 03:00 PM, Mustafa Hakim at [EMAIL PROTECTED] wrote:
> I am trying to install MySql on MAC OS X. After the pkg is installed I am
> not able to start the MySql server due to the Socket error.
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
Problem solved. ):
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom." -- Joseph A. Nagy, Jr. January 2004
p
Okay, I've been googling for about half an hour, found several useful links
but I'm still having a problem with the password for the initial mysql db
that is created when you follow the install instructions.
Here is the problem I'm having:
joseph-a-nagy-jr root # /usr/bin/mysqladmin -u root -h
jo
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title` varchar(50
MySQLers:
When I started porting an app from MSSQL to MySQL, I
got a flurry of error messages complaining of "Illegal
mix of collations for operation ' IN '".
I want to set all encodings to utf8 and leave them
there.
I finally managed (despite "help" from
winmysqladmin.exe and the Services Contr
Hello all:
I understand that MySQL Replication can be configured
to replicate selected tables in a Database. Is there
anyway to further constrain the replicate, say based
on a query of these tables etc..?
Thank you
Gowtham.
__
Do you Yahoo!?
Yahoo! Tax Center -
I am trying to install MySql on MAC OS X. After the pkg is installed I am
not able to start the MySql server due to the Socket error.
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Now, when I check the /tmp folder I see that there is no file by that name
that worked - Thanks a bunch!
CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote:
I think your looking for the ROUND(N,D)
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.jus
On Sun, 11 Apr 2004, Saurabh Data wrote:
> Can anyone in your own words clarify the difference between "open source"
> and "free software".
Don't take our words for it, get it from the Gnu's mouth:
http://www.gnu.org/philosophy/free-software-for-freedom.html
-sam
--
MySQL General Mailing Li
Hi There:
I have a query where I get an average of weekly miles.
For example:
Average Weekly Miles:
3.4285714285714
How would I get this number into a more read format? Such as 3.42. I
have tried the truncate but I can't seem to get it to work. Does any
one have any suggestions?
"SELECT TURNCA
Walter Andreas wrote:
CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static --d
Hi there,
I am trying to compile mysql 4.x with intel compiler for maximum performance. On my
research I have found that following line will squese more performance out of mysql:
CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2
-ip -mp -no-gcc -restrict" ./c
Dear Peter
As you said that access to the source code for a free software may or may
not be give.
Looking at the FSF website and definition of free software, freedom 1 states
that access to the source code is given to study how the program works
So there is a small contradiction here . Please c
> Can anyone in your own words clarify the difference between "open source"
> and "free software".
Interesting question, though you missed one other label 'public domain'.
These are all interesting elements of who controls the source and to what
extent.
MySQL as I understand it, allows
>Cities (CityID, Name)
>People (PersonID, Name)
>Travel_Exp (ExpID, Date, PersonID, Per_Diem)
>Travel_Exp_Cities (CityID, ExpID)
Based on the descriptions I'd tend to go with a normalized table set
of this nature:
Cities (CityID, Name)
People (PersonID, Name)
Travel_Exp (ExpID, Date, PersonID, Ci
> Can anyone in your own words clarify the difference between "open source"
> and "free software".
Free Software:
You can make changes in the sourcecode for your own and you can redistribute
it again.
Open Source:
The sourcecode is "only" open...
Cheers
--
MySQL General Mailing List
For list
On Sunday 11 April 2004 10:58 am, Saurabh Data wrote:
> Dear Users
>
> Can anyone in your own words clarify the difference between "open source"
> and "free software".
>
> Many Thanks
>
> Saurabh Data
This is off topic for this list, but I'll provide a quick answer.
Free software is software that
Dear Users
Can anyone in your own words clarify the difference between "open source"
and "free software".
Many Thanks
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
one who seeketh , wi
Thanks Matt. But, what I am attempting to do with (oi.orderId IS
NULL) is to eliminate the orders that have at least one order item
with products of product parents not equal to 2. What you show finds
all orders that have orderitems that have a product parent greater
than 2, however, if that or
Hi folks.
I've just submitted the following as a 'bug' via the MySQL website, and was
wondering if anyone out there had experienced the same problem?
It only seems to cause a crash when a nested IF is put into a stored
procedure, so the work-around is obvious - don't nest 'em!
As posted to mysq
"David Carlos Brunstein" <[EMAIL PROTECTED]> wrote:
> Hi Egor.
>
> Thanks for your answer. I'm relatively new to MySQL.
>
> Isn't any way -like an environment variable or configuration file
> setting or something like that- to change the date format at the MySQL
> side, not at client side ?
>
N
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP;
Sun, 11 Apr 2004 12:47:20 +0200
Date: Sun, 11 Apr 2004 12:47:20 +0200
Message-Id: <[EMAIL PROTECTED]>
--- END HEADERS ---
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and
php4.x
My answer is probably not going to be very helpful!
It depends on a lot of factors. If the database is likely to be hit heavily,
you'll want to normalize the data strongly, and you might even create a glue
table such as travel_expenditures_cities to avoid row duplication in the
travel_expenditures
Hmm.
SELECT o.*
FROM orders o
INNER JOIN orderitems oi ON o.orderid = oi.orderid
INNER JOIN products p ON p.productid = oi.productid
AND p.productparentid > 2
WHERE o.orderstatus =2
Not sure why you are checking for a NULL ordered in orderitems? That would
suggest you get back only items
Yep. Theres no reason at all why this sort of thing won't work for MSSQL
too. Use SQL Enterprise Manager to generate a create script for all objects
in the database, and also tell it to script referential integrity (FKs,
etc).
Then add anything MySQL specific, such as Type=InnoDB (which you will n
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and
php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test it, I installed
the
Microsoft stress test tool whi
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with
apache 1.x and php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test
it, I installed the
Microsoft stress test tool whi
As I discovered recently, thanks to another user on this list, there is at
least one situation where you WILL need to also create a KEY index on a
PRIMARY KEY column -
If you have a composite primary key such as (col1, col2) and you wish to
place a foreign key on col2, you will ALSO have to add a
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with
apache 1.x and php4.x
The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application.
Now I am trying to configure the server for huge load. To stress test
it, I installed the
Microsoft stress test tool whi
From the MySQL documentation:
* A PRIMARY KEY is a unique KEY where all key columns must be defined
as NOT NULL.
KEY is a synonym for INDEX. So, specifying PRIMARY KEY implies UNIQUE and
INDEX.. You don't have to specify them yourself.
At 01:11 am 4/11/2004, you wrote:
I learned that there ar
40 matches
Mail list logo