SCO issue

[Mirza]

pissed
I would like someone from MySQL AB to clarify issue with SCO asap. I 
wouldn't like to use technologies for my business that later could be 
used against me (in legal sense). Does MySQL AB understand that it helps 
funding their legal cases against us (GPL users) ? If someone feels OK 
with SCO partnership, good luck, but (being long time MySQL user and 
alpha bug reporter) I would switch to Embedded PostgreSQL myself and 
encourage other people to do the same. I use _tons_ of GPL software so 
should I help funding of my own annoyance (albeit poorly supported with 
facts) ?

/pissed

mirza

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MinGW and MySQL

[Mirza]

Pooly wrote:

Hello,

I'm using QT4.0 which works with MinGW. Now I want to use the MySQL
API, but it seems to be only working with MS VC++. Should I recompile
my own ? Is there any official MinGw libmysqlclient.dll ?



I have lot of trouble with it, It compiles and links OK but calling any 
funcion of MySQL API causing crash. I would highly recommend adding .a 
library for mingw to official win32 distribution of MySQL (if anybody 
from MySQL AB can hear me). I submitted bug already, it is verified 
but so far nothing happens.


Mirza

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spatial extensions and GIS

[Mirza]

In both cases you will have to write your own code. MySQL, so far, only 
can store Spatial data and do very simple (still, r-tree optimized) GIS 
queries (like: all objects inside rect).

mirza
Terry Pothecary wrote:
Hi.
This may be a daft question, so forgive me:
I am just starting out with the Spatial extensions and I am wondering 
how I can use it to determine the distances between any 2 landmarks that 
have been entered as POINTs in the database. The POINTs are entered with 
longitude and lattitude coordinates.

I have 2 problems:
1) The Distance nor the Buffer functions have not been implemented.
2) How can I use MySQL to help me convert from lat / long to distances 
in miles (or KM)?

Thanks.
Terry.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Speeding up Inserts

[Mirza]

Use:
ALTER TABLE DISABLE KEYS
... inserts here
ALTER TABLE ENABLE KEYS
mirza
[EMAIL PROTECTED] wrote:
Hi All,
Whats the fastest way to speed up inserts?
I have a table which I insert into once a week (about 20-30k Rows)
And select from all the time... 

Is the only way to speed up inserts to remove indexes?
And to speed up selectes, ...add the indexes again?
Regards,
Amit

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: many updates really slow

[mirza]

if it is part of app. use soap to communicate with server and adopt your 
application. Send all your commands as one string parameter to server, 
and execute it all  there. Such modification to is quite simple to write 
using gSoap library (if your application is C++ based) or Axis (Java).

mirza
William Wang wrote:
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this automatically. I don't want to write a
server-client application to just to handle file
transimission and do pass the update cmd to local
server. Any idea? Thanks.
William
--- Jack Coxen [EMAIL PROTECTED] wrote:
 

I'm guessing here but it sounds like you have the
cmd.sql file on your local
machine (in Europe).  If that's the case, compress
the file, ftp it to the
US server, uncompress it and do the load locally on
the US server.
If you're doing the update remotely, you're probably
being killed by
transmission time.  Transferring the file in toto to
the US server will be
quicker than having the communications lag of doing
sending a command from
Europe to the US, having the command execute and
then receiving the status
back in Europe...times 5000 records.
Hope this helps,
Jack
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:12 PM
To: [EMAIL PROTECTED]
Subject: many updates really slow
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes
about
0.3 seconds.
Now I want to do update db with 5000 updates. So I
put
all the UPDATES commands in a file cmd.sql and do:
mysql -hA  cmd.sql
and it takes 30 MINUTES which is reasonable: 0.3 *
5000 but unbearable.
Is there any better way to do this? Am I doing
something stupid? Thanks a lot.
	
		
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   

   

http://lists.mysql.com/[EMAIL PROTECTED]
 


	
		
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cygwin

[Mirza]

Does anyone knows where to find headers and libraries for mysql 
development on Cygwin platform? thanks.

Mirza Hadzic



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.2.?

[Mirza]

Hi,

Is there any info on when 4.1.2 is to be released?

Mirza



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Version 4.1.2. when?

[Mirza]

Is there any info on when 4.1.2. is scheduled for relase? I am stucked 
in 4.1.1. with fulltext problem (bug #2490).

Thanks for info,
mirza


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB loading: add keys before or after

[Mirza]

In theory it is fastest to add indexes first, then disable it (ALTER
TABLE x DISABLE KEYS), then add data and, on the end, re-enable keys
(ALTER TABLE x DISABLE KEYS).
mirza
Keith Thompson wrote:
Hello all,

I need to load a new InnoDB table with about 80 million rows.
With MyISAM I have often found that it is faster to create
the table without indexes, add all the data, then add the
indexes.  Is this true with InnoDB as well, or should I put
my indexes in before loading?
Similarly, I have another large table that is currently MyISAM
that I'd like to move to InnoDB.  What would be the fastest
steps towards accomplishing this (as far as indexes, etc.)?
Thanks -keith








--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Searching for matching zipcode in a list of (ranges of) zipcodes

[Mirza]

 Original Message 
Subject: Re: Searching for matching zipcode in a list of (ranges of) 
zipcodes
Date: Wed, 14 Jan 2004 14:14:19 +0100
From: Mirza [EMAIL PROTECTED]
To: Tom Hesp [EMAIL PROTECTED]
References: [EMAIL PROTECTED]

Hi,
If you rewrite ranges 3612-3621 to have all elements named (3612,
3613,... , 3621), you can use fulltext search to find matching
engineers. Users can still enter 3612-3621 to it's frontend application,
but you must write all numbers to database.
hope this helps,
mirza
Tom Hesp wrote:
Hi all,

I am looking for a simple solution to find a zipcode in lists of zipcodes.

I have a table with customer data including the customer's zipcode and a
table containing information about service engineers. The service engineers
can define a list of zipcode (ranges) of areas they want to (or are able to)
service. An example of such a list is: 3528,3529,3612-3621,3828. This list
is stored in one field in the service engineer table.
What I would like to do is by using the customer's zipcode select all
engineers that have that zipcode in their list. E.g. 3529  3615 would match
while 3530 would not in the above example. I can of course code this in
perl, for example, but that would mean that for every search I need to do I
would have to retrieve the entire service engineer table and go through it
to find a match. I was hoping MySQL would have function to this. I searched
the documentation but have not been able to find any.
Thanks for your time.

Kind regards,
Tom Hesp





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Embedded MySQL example with g++?

[Mirza]

Is there any example of makefile for g++ that links libmysqld? So far I 
can link libmysqld only with gcc-based programs, but g++ gives lots of 
unresolved symbols (like __pure_virtual etc.).

thanks,

Mirza Hadzic



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Embedded 4.1.1 - Linux

[Mirza]

Hi,

Is there any site with list of libs I need to link with libmysqld 
(linux)? I am currently using libmysqlclient and thisone needs 
libpthreads and libz to work fine. If I replace libmysqlclient with 
libmysqld, there is lot of symbols linker cannot find.

Thanks,

Mirza



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.1. - WITH QUERY EXPANSION

[Mirza]

Hi,

In 4.1.1. new features there is:

* Added `MATCH ... AGAINST( ... WITH QUERY EXPANSION)' and the
 `ft_query_expansion_limit' server variable.
What is WITH QUERY EXPANSION? I found no details in manual.

mirza



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

can't find FULLTEXT index

[Mirza]

Hi,

I have error 1191 can't find fulltext index matching the column list, 
but I am certain that all columns in the list are present in my Fulltext 
 index. Does anybody else had this problem? I am using 4.1.0.

thanks,
Mirza


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Index before or after inserts?

[Mirza]

I need to insert hundreds of milions of records to a table and make 
several indicies on it. Now, is it faster to make tables with indicies 
and then fill tables or fill tables first, then make indicies? Any 
experiancies?

regards,

mirza



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 crashes on geo select

[Mirza]

Hi,

Version 4.1.0. crashing on my Windows 2000 box after this query:

SELECT * FROM `streets` where MBROverlaps(GeomFromText('Polygon(16345750 
48185401, 16402348 48185401, 16402348 48156946, 16345750 48156946, 
16345750 48185401)'), GEOM);

GEOM is field of type geometry inside streets table. I have tested 
table and test shows that everything is OK.

Mirza Hadzic



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: INSERT INTO () SELECT...

[Mirza Muharemagic]

Hi Eric,

   thats oracle function INSERT INTO ... SELECT. it doesn't work in
   mysql.

   Mirza
   [EMAIL PROTECTED]

__
21.11.2002 22:13


 Hi,

 This should work, I think, but doesn't


 INSERT INTO holds (ord_num)
 SELECT orders.ord_num FROM orders
 LEFT JOIN holds ON orders.ord_num = holds.ord_num
 WHERE holds.ord_num IS NULL

 I have some order numbers that are not in holds that are in orders. I want 
 to make entries in holds to match those missing.

 The above SELECT gives me exactly what I want, but I get

 ERROR 1066: Not unique table/alias: 'holds'


 Thanks,

 Eric


 mysql,sql why because we love you!





 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql: multiple SELECTs with INSERT or UPDATE??

[Mirza]

Hi,

   i am inserting data in a mysql table like this:
   INSERT INTO mytable1
   (bu_main_id)
  SELECT main_id FROM mytable2
  WHERE username=\$username\

   that's ok.
   
   but now i would like to insert 2 values (bu_main_id and status), and i
   would like to know, is it possible to use 2 or more SELECTs
   together with an INSERT, for example:

   INSERT INTO mytable1
   (bu_main_id, status)
  SELECT main_id FROM mytable2
  WHERE username=$username,
  SELECT config_mode FROM mytable3
  WHERE config_value=status

   my 2nd question, is it possible to use UPDATE and (mulstiple)
   SELECTs together
   i.e.:

   UPDATE mytable
   SET xxx = (SELECT xxx from mytable2 WHERE config=yyy) ...
   
   thanx

   Mirza



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

synopsis of the problem (one line)

[Azrinsyah MIRZA-ASFIAN]

Description:
I can't run both the scripts mysql and mysqladmin to set up the 
root password for my database.
How-To-Repeat:
When I run this command;
./mysqladmin -u root password 'pegasus'
ld.so.1: ./mysqladmin: fatal: libmysqlclient.so.6: open failed: No such file 
or directory
Killed  
Fix:
I don't know how to fix this problem.
Submitter-Id:  submitter ID
Originator:Azrinsyah MIRZA-ASFIAN
Organization:
 
MySQL support: [none | licence | email support | extended email support ]
Synopsis:  
Severity:  
Priority:  
Category:  mysql
Class: 
Release:   mysql-3.22.25 (Source distribution)

Environment:

System: SunOS murang 5.8 Generic_108529-15 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc 
/usr/ucb/cc
GCC: Reading specs from /usr/local/bin/../lib/gcc-lib/i386-pc-solaris2.8/3.2/specs
Configured with: ../gcc-3.2/configure --prefix=/usr/local/apps/gcc-3.2 
--enable-version-specific-runtime-libs
Thread model: posix
gcc version 3.2
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure 
Perl: This is perl, version 5.005_03 built for i86pc-solaris

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php