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: 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 > 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: 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 > >> 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 >> > 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: 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 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: 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: 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: 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: 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]
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. > > NODE"osr507" > 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 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. > > NODE"osr507" > 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.
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 > > > > 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 > > > > > >> 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. >> > >> > NODE"osr507" >> > 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
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
Re: 16 Index Table Limit
Thanks! Jim Dan Nelson wrote: > > In the last episode (Feb 05), Jim Ginn said: > > 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. > > The limit is already 32 in mysql-3.23.32: > >* Up to 32 indexes per table are allowed. Each index may consist of > 1 to 16 columns or parts of columns. The maximum index length is > 500 bytes (this may be changed when compiling *MySQL*). An index > may use a prefix of a `CHAR' or `VARCHAR' field. > > -- > Dan Nelson > [EMAIL PROTECTED] - 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
