Re: Spatial extensions
Rene:
We've easily integrated GIS with MySQL into our
sites:
http://tenant.com/map-search.php
http://yearlyrentals.com
http://acnj.com/map.php
...
Thanks!
Jim Ginn
Visit My Work
(888)
546-4466 office
(609) 226-5709 cell
Awesome, this is what I was trying to find, as you
succinctly wrote it. I
*really* appreciate getting pointed in
the right direction, since I
haven't found a lot of MySQL's GIS
tutorials directed at what I'm trying
to do.
Still, a couple questions, the Distance() function you included,
that must
require 5.1 or higher right? 5.0.88 on my box throws
an error:
Function places.Distance does not
exist
Also, where does line_segment come from
in the below query?
Thanks.
...Rene
On 2009-12-17, at 8:45 AM, Gavin Towey wrote:
Yes, spatial indexes are very fast:
Query would be something like:
SET
@center = GeomFromText('POINT(37.372241 -122.021671)');
SET @radius = 0.005;
SET @bbox =
GeomFromText(CONCAT('POLYGON((',
X(@center) - @radius, ' ',
Y(@center) - @radius, ',',
X(@center) + @radius, ' ',
Y(@center) - @radius, ',',
X(@center) + @radius, ' ',
Y(@center) + @radius, ',',
X(@center) - @radius, ' ',
Y(@center) + @radius, ',',
X(@center) - @radius, ' ',
Y(@center) - @radius, '))')
);
select id, astext(coordinates), Distance(@center,line_segment) as dist
FROM places where MBRContains(@bbox, line_segment) order by
dist limit
10;
Regards,
Gavin Towey
-Original Message-
From: René Fournier
[mailto:m...@renefournier.com]
Sent: Wednesday, December 16,
2009 4:32 PM
To: mysql
Subject: Spatial
extensions
I have table with 2 million rows of
geographic points (latitude,
longitude).
Given
a location -- say, 52º, -113.9º -- what's the fastest way to query
the 10 closest points (records) from that table? Currently, I'm
using a
simple two-column index to speed up queries:
CREATE TABLE `places` (
`id`
mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`latitude`
decimal(10,8) NOT NULL,
`longitude` decimal(12,8) NOT
NULL
PRIMARY KEY (`id`),
KEY `latlng`
(`latitude`,`longitude`)
) ENGINE=MyISAM AUTO_INCREMENT=50
DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci;
My current query is fairly quick:
SELECT SQL_NO_CACHE * FROM places WHERE latitude
BETWEEN 51.98228037384
AND 52.033153677 AND longitude
BETWEEN -113.94770681881 AND
-113.86685484296;
But I wonder a couple things:
1. Would MySQL's [seemingly anemic] spatial extensions would
speed
things up if I added a column of type POINT (and a
corresponding spatial
INDEX)?
CREATE TABLE `places` (
`id` mediumint(8) unsigned NOT NULL
AUTO_INCREMENT,
`latitude` decimal(10,8) NOT NULL,
`longitude` decimal(12,8) NOT NULL,
`coordinates`
point NOT NULL,
PRIMARY KEY (`id`),
KEY
`latlng` (`latitude`,`longitude`),
KEY `coord`
(`coordinates`(25))
) ENGINE=MyISAM AUTO_INCREMENT=50
DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci;
2. How would I write the query?
...Rene
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=gto...@ffn.com
This message contains confidential information
and is intended only for
the individual named. If you are
not the named addressee, you are
notified that reviewing,
disseminating, disclosing, copying or
distributing this
e-mail is strictly prohibited. Please notify the
sender
immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system. E-mail transmission
cannot be
guaranteed to be secure or error-free as
information could be
intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or
contain viruses.
The sender therefore does not accept liability for any
loss
or damage caused by viruses or errors or omissions in the contents
of this message, which arise as a result of e-mail
transmission.
[FriendFinder Networks, Inc., 220 Humbolt
court, Sunnyvale, CA 94089,
USA, FriendFinder.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub...@renefournier.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
unsubscribe:http://lists.mysql.com/mysql?unsub=...@oats.com
Re: MySQL versus PostgreSQL for GPS Data
Juan: Still seems excessive but in that case, ignore inserts that have no change in lat / lon ... Jim Jim Ginn wrote: Not sure why you you need the trucks location 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year per truck? Maybe better at 60 seconds? OpenGGD is also designed to deliver GPS data in real time; we have customers that sometimes want to track their trucks in real time, that's why we think the worst scenario could be one position per second. Juan Karlos 2009/3/18 Jim Ginn j...@oats.com Juan: We've had success with spatial indexes and mysql on our sites however our numbers are smaller: http://brokersnetwork.com (200,000+ records) http://yearlyrentals.com (200,000+ records) http://avalonrealestate.com/map.php (4,400+ records) ... Not sure why you you need the trucks location 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year per truck? Maybe better at 60 seconds? Jim Juan, On Wed, Mar 18, 2009 at 11:14 AM, Juan Pereira juankarlos.open...@gmail.com wrote: Hello, I'm currently developing a program for centralizing the vehicle fleet GPS information -http://openggd.sourceforge.net-, written in C++. The database should have these requirements: - The schema for this kind of data consists of several arguments -latitude, longitude, time, speed. etc-, none of them is a text field. - The database also should create a table for every truck -around 100 trucks-. - There won't be more than 86400 * 365 rows per table -one GPS position every second along one year-. - There won't be more than 10 simultaneously read-only queries. The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? I think it depends on exactly what you want to do with the data. MySQL has fairly poor support for spatial types but you can achieve a lot just manipulating normal data types. Postgres (which i know nothing about) appears to have better spatial support via postgis http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html http://postgis.refractions.net/documentation/manual-1.3/ In terms of data size you should not have a problem, I think you need to look at how you are going to query the tables. Cheers, Ewen Thanks in advance Juan Karlos. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=...@oats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL versus PostgreSQL for GPS Data
Juan: We've had success with spatial indexes and mysql on our sites however our numbers are smaller: http://brokersnetwork.com (200,000+ records) http://yearlyrentals.com (200,000+ records) http://avalonrealestate.com/map.php (4,400+ records) ... Not sure why you you need the trucks location 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year per truck? Maybe better at 60 seconds? Jim Juan, On Wed, Mar 18, 2009 at 11:14 AM, Juan Pereira juankarlos.open...@gmail.com wrote: Hello, I'm currently developing a program for centralizing the vehicle fleet GPS information -http://openggd.sourceforge.net-, written in C++. The database should have these requirements: - The schema for this kind of data consists of several arguments -latitude, longitude, time, speed. etc-, none of them is a text field. - The database also should create a table for every truck -around 100 trucks-. - There won't be more than 86400 * 365 rows per table -one GPS position every second along one year-. - There won't be more than 10 simultaneously read-only queries. The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? I think it depends on exactly what you want to do with the data. MySQL has fairly poor support for spatial types but you can achieve a lot just manipulating normal data types. Postgres (which i know nothing about) appears to have better spatial support via postgis http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html http://postgis.refractions.net/documentation/manual-1.3/ In terms of data size you should not have a problem, I think you need to look at how you are going to query the tables. Cheers, Ewen Thanks in advance Juan Karlos. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=...@oats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: long login times?
Jed: Are you using an in-network IP to access the database ie: 127.0.0.1 192.168.98.## or are you using a public IP or full domain name ie: DB001.MY-DOMAIN.COM ... Jim I've started logging how long my php application takes to login to mysql, and often it's well below 1 millisecond. However, I'll sometimes get a wave of long login attempts that take 3 to 6 seconds. I've enabled skip-name-resolv, and I think that helps. There are no long running queries on the system. There are only a dozen accounts on the system. The system is not running under stress, it's about load 0.9, four cores, 2Gz, 4GB ram, no swapping. (CentOS 5, Mysql 5.0.45). I'd hate to set the connect timeout to 1 second, fail and retry in under a second just to try to get a connection as fast as possible. Any thots on how I might keep login times consistently low? Thanks Jed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=...@oats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Calendar creation
Craig: Not sure but we use: http://www.cascade.org.uk/software/php/calendar/ (ie. php) at: http://downtownoceancity.com/events Jim On Thu, Jul 17, 2008 at 8:50 AM, Weston, Craig (OFT) [EMAIL PROTECTED] wrote: Hi there, Is there any simple way to create a calendar table? For example I want to create a reference calendar containing all the dates of several years so I can accurately represent even days where I have no data in my data set. Any ideas? This should give you some ideas. http://lists.mysql.com/mysql/212453 -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL only listens on localhost
Franz: Did you setup user access permissions outside of 127.0.0.1 and is port 3306 open on your firewall/router? Jim Ginn http://www.Tenant.com Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the physical interface is reset. What can I do? Regards Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL admin GUI
Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com Does anyone know how to add a field anyplace but at the bottom? I haven't found any insert here functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com http://www.the-infoshop.com/ www.giiexpress.com http://www.giiexpress.com/ www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help With a Week ( date ) query
Jerry: We do this exactly at: http://www.WeeklyRentals.com Jim I'm not sure if this gets you all the way, or not. There is a WEEK() function that converts a date into its week of the year. There isn't any obvious way to turn it back into a date, but it doesn't sound like you need it for your particular application. SELECT * FROM specials WHERE WEEK(NOW(), 7) = WEEK(specials.start_date, 7) AND DATEDIFF(specials.start_date,DATE(NOW)) 7; Since you have the start date for your special, then you will be getting it back from your query anyways so you don't need to convert back. You can make your queries more efficient if you store the week the special starts as well as its date, saving one function call in your query and allowing you to index on that week field. The second part of the WHERE clause should keep you within the right year, if I did it correctly. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Joey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 9:46 AM To: MySQL DB Subject: Help With a Week ( date ) query Hi Guys, I'm kind of at a standstill in coming up with how to get a query I need to write. I'm trying to find a record which matches the week we are in. Example today is Thursday the 29th, it is within the week which has the 26th through the 1st, and if the day is within this week display the record that has the date 3/26/2007. Basically we are returning a special which is dated each Monday, any day within that week should show the Monday value. I appreciate your help! Joey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching for Dates
Dan:
I've used the TO_DAYS on a SELECT statement ie:
SELECT * FROM properties WHERE
(TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC
however it didn't seem to take advantage or use the index on that field
(ie. CreationDate) ...
Jim
In the last episode (Mar 16), Bob Cooper said:
I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new to
both SQL and MySQL. I have been able to query out most of the data I
need from my tables without any issues but his one has stumped me.
I am trying to query data associated with specific dates. The dates
are not sequential but somewhat sporadic. I would like to query out
data/dates that are every 4 days from a starting date.
2006-4-17, 2006-4-21, etc.
I have tried ADDDATE('2006-4-14',interval 4 day)=Date_col
but it give me only the next date 2006-4-21.
You could do it by converting to a daynumber (the number of days since
year 0) and doing modulo arithmetic:
WHERE TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')%4
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_to-days
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Searching for Dates
Dan:
Thanks!
Jim
In the last episode (Mar 18), Jim Ginn said:
In the last episode (Mar 16), Bob Cooper said:
I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new
to both SQL and MySQL. I have been able to query out most of the
data I need from my tables without any issues but his one has
stumped me.
I am trying to query data associated with specific dates. The
dates are not sequential but somewhat sporadic. I would like to
query out data/dates that are every 4 days from a starting date.
2006-4-17, 2006-4-21, etc.
I have tried ADDDATE('2006-4-14',interval 4 day)=Date_col but it
give me only the next date 2006-4-21.
You could do it b
y converting to a daynumber (the number of days
since year 0) and doing modulo arithmetic:
WHERE TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')%4
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_to-days
I've used the TO_DAYS on a SELECT statement ie:
SELECT * FROM properties WHERE
(TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC
however it didn't seem to take advantage or use the index on that field
(ie. CreationDate) ...
Right; mysql needs CreationDate all by itself on one side of a
comparison operator to be able to use an index. In your case, try
WHERE CreationDate = CURDATE() - INTERVAL 1 DAY
, assuming CreationDate is a 'date' field type. If it's a datetime,
you'll need to use a BETWEEN operator and cover the time range from
midnight to midnight on your target day.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lynn Gerber: First - Thanks again for your help. Second - Installed SCO release supplements, Apache 1.3.31, PHP Version 4.3.6 (--with-mysql=shared), and MySQL 4.1.3-beta. MySQL is running fine. PHP is recognized Apache. But PHP is not able to find the the MySQL shared libraries. Simple PHP MySQL function request are not found ? Have you had any luck in interfacing PHP and MySQL on SCO Openserver? Thanks Again, Jim Our Configure Command './configure' '--with-apxs=/usr/lib/apache/bin/apxs' '--prefix=/usr' '--with-exec-dir=/usr/lib/php/bin' '--with-config-file-path=/usr/lib/php' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib-dir=/usr' '--with-jpeg-dir=/usr' '--with-tiff-dir=/usr' '--with-freetype-dir=/usr' '--with-expat-dir=/usr' '--with-xslt-sablot=/usr' '--with-sablot-js=/usr' '--with-openssl=shared,/usr' '--with-zlib=shared,/usr' '--with-bz2=shared,/usr' '--with-curl=shared,/usr' '--with-gdbm=shared' '--with-ndbm=shared' '--with-db4=shared,/usr' '--with-flatfile=shared' '--with-dom=shared,/usr' '--with-dom-xslt=shared,/usr' '--with-dom-exslt=shared,/usr' '--with-iconv=shared' '--with-gettext=shared,/usr' '--with-gd=shared,/usr' '--with-ttf-dir=/usr' '--with-freetype=shared,/usr' '--with-ldap=shared,/usr' '--with-regex=php' '--with-pcre-regex=/usr' '--with-mm=/usr' '--with-ttf=shared' '--with-zlib=shared' '--with-dbm=shared' '--with-readline=shared,/usr' '--with-mysql=shared' '--with-pgsql=shared,/usr' '--with-expat-dir=/usr' '--enable-calendar=shared' '--enable-dba=shared' '--enable-dbase=shared' '--enable-dbx=shared' '--enable-dio=shared' '--enable-exif=shared' '--enable-filepro=shared' '--enable-ftp=shared' '--enable-gd-native-ttf' '--enable-trans-id' '--enable-shmop=shared' '--enable-sockets=shared' '--enable-sysvmsg=shared' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-wddx=shared' '--enable-mbstring=shared' '--enable-tokenizer=shared' '--enable-expat=shared' '--enable-xslt=shared' '--enable-magic-quotes' '--enable-inline-optimization' '--enable-sigchild' '-- On Tue, 13 Jul 2004, Jim Ginn wrote: Much better but it complains about max_allowed_packet? It is set to the default 1M ... I have my stune set as follows. NODEosr507 EVDEVS 96 EVQUEUES88 NSPTTYS 64 NUMSP 256 NSTREAM 4352 NHINODE 1024 GPGSLO 1000 GPGSHI 3000 NSTRPAGES 4000 NAIOPROC50 NAIOREQ 400 NAIOBUF 400 NAIOHBUF100 NAIOREQPP 400 NAIOLOCKTBL 50 MAX_PROC1 MAXUMEM 1048576 NCALL 256 NCLIST 512 NSTREVENT 14848 NUMTIM 1888 NUMTRW 1888 SDSKOUT 64 SEMMAP 8192 SEMMNI 8192 SEMMNS 8192 SEMMSL 150 SEMMNU 150 SHMMAX 2147483647 TTHOG 4096 SECLUID 0 SECSTOPIO 1 SECCLEARID 1 MAXUP 4096 NOFILES 4096 SHMMNI 200 Installing all prepared tables Fill help tables ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes 040713 17:43:07 Aborting 040713 17:43:07 ./bin/mysqld: Shutdown complete On Tue, 13 Jul 2004, Jim Ginn wrote: Updated to (your) 4.1.3-beta and now get: ./bin/mysqld --skip-grant dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m Check in /usr/lib and see: l /usr/lib/libssl* -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0.9.6@ -r--r--r-- 1 bin bin38044 Sep 20 2003 /usr/lib/libsso.a@ I am currently using openssl-0.9.6m. You will find a complete static and binary of what I am using in openssl-0.9.6m-osr5.tar.gz ftp://ftp.zenez.com/pub/zenez/prgms/openssl-0.9.6m-osr5.tar.gz I usually install it in /usr/local/ssl. Most people install it in /usr/lib. You can also put links from /usr/local/ssl/lib to /usr/lib/ On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed ... I made a special version of FSU-threads for this but then worked with MySQL on a better solution as the creator of FSU-threads did not want to make changes and release a new version. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lyn Gerber: Not sure why we can get PHP-MySQL functions working? We're using PHP: php4/4.3.6a (SCO build) Are you using same build of PHP? Thanks! Jim On Sun, 18 Jul 2004, Jim Ginn wrote: First - Thanks again for your help. Your welcome. Second - Installed SCO release supplements, Apache 1.3.31, PHP Version 4.3.6 (--with-mysql=shared), and MySQL 4.1.3-beta. MySQL is running fine. PHP is recognized Apache. But PHP is not able to find the the MySQL shared libraries. Simple PHP MySQL function request are not found ? Have you had any luck in interfacing PHP and MySQL on SCO Openserver? I do not have any problems... I do have the following VirtualHost hostname SetEnv PATH /bin:/usr/bin:/usr/local/bin:/usr/local/mysql/bin: SetEnv LD_LIBRARY_PATH /usr/lib:/lib:/usr/local/lib:/usr/local/mysql/lib/mysql:/usr/local/bdb:/usr/local/ssl/lib: PassEnv PATH LD_LIBRARY_PATH ... #options I want for this virtual host /VirtualHost Thanks Again, Jim Our Configure Command './configure' '--with-apxs=/usr/lib/apache/bin/apxs' '--prefix=/usr' '--with-exec-dir=/usr/lib/php/bin' '--with-config-file-path=/usr/lib/php' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib-dir=/usr' '--with-jpeg-dir=/usr' '--with-tiff-dir=/usr' '--with-freetype-dir=/usr' '--with-expat-dir=/usr' '--with-xslt-sablot=/usr' '--with-sablot-js=/usr' '--with-openssl=shared,/usr' '--with-zlib=shared,/usr' '--with-bz2=shared,/usr' '--with-curl=shared,/usr' '--with-gdbm=shared' '--with-ndbm=shared' '--with-db4=shared,/usr' '--with-flatfile=shared' '--with-dom=shared,/usr' '--with-dom-xslt=shared,/usr' '--with-dom-exslt=shared,/usr' '--with-iconv=shared' '--with-gettext=shared,/usr' '--with-gd=shared,/usr' '--with-ttf-dir=/usr' '--with-freetype=shared,/usr' '--with-ldap=shared,/usr' '--with-regex=php' '--with-pcre-regex=/usr' '--with-mm=/usr' '--with-ttf=shared' '--with-zlib=shared' '--with-dbm=shared' '--with-readline=shared,/usr' '--with-mysql=shared' '--with-pgsql=shared,/usr' '--with-expat-dir=/usr' '--enable-calendar=shared' '--enable-dba=shared' '--enable-dbase=shared' '--enable-dbx=shared' '--enable-dio=shared' '--enable-exif=shared' '--enable-filepro=shared' '--enable-ftp=shared' '--enable-gd-native-ttf' '--enable-trans-id' '--enable-shmop=shared' '--enable-sockets=shared' '--enable-sysvmsg=shared' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-wddx=shared' '--enable-mbstring=shared' '--enable-tokenizer=shared' '--enable-expat=shared' '--enable-xslt=shared' '--enable-magic-quotes' '--enable-inline-optimization' '--enable-sigchild' '-- On Tue, 13 Jul 2004, Jim Ginn wrote: Much better but it complains about max_allowed_packet? It is set to the default 1M ... I have my stune set as follows. NODEosr507 EVDEVS 96 EVQUEUES88 NSPTTYS 64 NUMSP 256 NSTREAM 4352 NHINODE 1024 GPGSLO 1000 GPGSHI 3000 NSTRPAGES 4000 NAIOPROC50 NAIOREQ 400 NAIOBUF 400 NAIOHBUF100 NAIOREQPP 400 NAIOLOCKTBL 50 MAX_PROC1 MAXUMEM 1048576 NCALL 256 NCLIST 512 NSTREVENT 14848 NUMTIM 1888 NUMTRW 1888 SDSKOUT 64 SEMMAP 8192 SEMMNI 8192 SEMMNS 8192 SEMMSL 150 SEMMNU 150 SHMMAX 2147483647 TTHOG 4096 SECLUID 0 SECSTOPIO 1 SECCLEARID 1 MAXUP 4096 NOFILES 4096 SHMMNI 200 Installing all prepared tables Fill help tables ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes 040713 17:43:07 Aborting 040713 17:43:07 ./bin/mysqld: Shutdown complete On Tue, 13 Jul 2004, Jim Ginn wrote: Updated to (your) 4.1.3-beta and now get: ./bin/mysqld --skip-grant dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m Check in /usr/lib and see: l /usr/lib/libssl* -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0.9.6@ -r--r--r-- 1 bin bin38044 Sep 20 2003 /usr/lib/libsso.a@ I am currently using openssl-0.9.6m. You will find a complete static and binary of what I am using in openssl-0.9.6m-osr5.tar.gz ftp://ftp.zenez.com/pub/zenez/prgms/openssl-0.9.6m-osr5.tar.gz I usually install it in /usr/local/ssl. Most people install it in /usr/lib. You can also put links from /usr/local/ssl/lib to /usr/lib/ On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed
SCO Openserver Install
Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld And I have FSU threads installed ... Any help would be appreciated Thanks! Jim Ginn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lynn Gerber: I'll give the newer version a try as I was using: /usr/local/mysql-4.0.18-pc-sco3.2v5.0.7-i386 build from your site ... Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed ... I made a special version of FSU-threads for this but then worked with MySQL on a better solution as the creator of FSU-threads did not want to make changes and release a new version. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lynn Gerber: Updated to (your) 4.1.3-beta and now get: ./bin/mysqld --skip-grant dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m Check in /usr/lib and see: l /usr/lib/libssl* -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0.9.6@ -r--r--r-- 1 bin bin38044 Sep 20 2003 /usr/lib/libsso.a@ Is there a 'trick' (ie. symbolic links) or some other library I'm looking for with 'm' suffix? Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed ... I made a special version of FSU-threads for this but then worked with MySQL on a better solution as the creator of FSU-threads did not want to make changes and release a new version. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lynn gerber: Much better but it complains about max_allowed_packet? It is set to the default 1M ... Thanks! Jim Installing all prepared tables Fill help tables ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes 040713 17:43:07 Aborting 040713 17:43:07 ./bin/mysqld: Shutdown complete On Tue, 13 Jul 2004, Jim Ginn wrote: Updated to (your) 4.1.3-beta and now get: ./bin/mysqld --skip-grant dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m Check in /usr/lib and see: l /usr/lib/libssl* -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0.9.6@ -r--r--r-- 1 bin bin38044 Sep 20 2003 /usr/lib/libsso.a@ I am currently using openssl-0.9.6m. You will find a complete static and binary of what I am using in openssl-0.9.6m-osr5.tar.gz ftp://ftp.zenez.com/pub/zenez/prgms/openssl-0.9.6m-osr5.tar.gz I usually install it in /usr/local/ssl. Most people install it in /usr/lib. You can also put links from /usr/local/ssl/lib to /usr/lib/ On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed ... I made a special version of FSU-threads for this but then worked with MySQL on a better solution as the creator of FSU-threads did not want to make changes and release a new version. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO Openserver Install
Boyd Lynn Gerber: I have (think) the MySQL dataserver running. You wouldn't know where I could find a compiled: mysql.so module for apache/php data access? Thanks! Jim On Tue, 13 Jul 2004, Jim Ginn wrote: Much better but it complains about max_allowed_packet? It is set to the default 1M ... I have my stune set as follows. NODEosr507 EVDEVS 96 EVQUEUES88 NSPTTYS 64 NUMSP 256 NSTREAM 4352 NHINODE 1024 GPGSLO 1000 GPGSHI 3000 NSTRPAGES 4000 NAIOPROC50 NAIOREQ 400 NAIOBUF 400 NAIOHBUF100 NAIOREQPP 400 NAIOLOCKTBL 50 MAX_PROC1 MAXUMEM 1048576 NCALL 256 NCLIST 512 NSTREVENT 14848 NUMTIM 1888 NUMTRW 1888 SDSKOUT 64 SEMMAP 8192 SEMMNI 8192 SEMMNS 8192 SEMMSL 150 SEMMNU 150 SHMMAX 2147483647 TTHOG 4096 SECLUID 0 SECSTOPIO 1 SECCLEARID 1 MAXUP 4096 NOFILES 4096 SHMMNI 200 Installing all prepared tables Fill help tables ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes 040713 17:43:07 Aborting 040713 17:43:07 ./bin/mysqld: Shutdown complete On Tue, 13 Jul 2004, Jim Ginn wrote: Updated to (your) 4.1.3-beta and now get: ./bin/mysqld --skip-grant dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m Check in /usr/lib and see: l /usr/lib/libssl* -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0@ -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so.0.9.6@ -r--r--r-- 1 bin bin38044 Sep 20 2003 /usr/lib/libsso.a@ I am currently using openssl-0.9.6m. You will find a complete static and binary of what I am using in openssl-0.9.6m-osr5.tar.gz ftp://ftp.zenez.com/pub/zenez/prgms/openssl-0.9.6m-osr5.tar.gz I usually install it in /usr/local/ssl. Most people install it in /usr/lib. You can also put links from /usr/local/ssl/lib to /usr/lib/ On Tue, 13 Jul 2004, Jim Ginn wrote: Trying to get MySQL running on SCO Openserver 5.0.7 and get this message: dynamic linker: ./bin/mysqld: binder error: symbol not found: pthread_key_delete; referenced from: ./bin/mysqld This was an error for some versions of MySQL. This is fixed in MySQL-4.0.19 forward. You will need FSU-threads-3.14 or new. And I have FSU threads installed ... I made a special version of FSU-threads for this but then worked with MySQL on a better solution as the creator of FSU-threads did not want to make changes and release a new version. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
16 Index Table Limit
Is there a way to define more than 16 btrees per table? Can this index limit be increased to 32 or more? It's a static database that is massively updated once or twice a year so update performance is not the issue, rather speed of queries. Please respond to [EMAIL PROTECTED] because I am not subscribed to the list. Thanks - 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
