Re: InnoDB interaction between secondary and primary keys.

Thank you Rick! -- Jeremy Chase http://twitter.com/jeremychase On Wed, Jan 30, 2013 at 4:24 PM, Rick James wrote: > The hint of a change is in here (search for "secondary"): > > http://jorgenloland.blogspot.co.uk/2012/12/favorite-mysql-56-features-optimizer.html > >

Re: Performance impact of large number of columns

, YMMV depending on your database engine, schema, indexing > efficiency, etc > > Howard Hart > Ooma > > Jeremy Jongsma wrote: > > I have a table in a stock analysis database that has 284 columns. All > > columns are int, double, or datetime, except the primary ke

Performance impact of large number of columns

I have a table in a stock analysis database that has 284 columns. All columns are int, double, or datetime, except the primary key (varchar(12)). By my calculation this makes each row 1779 bytes. CREATE TABLE technicals ( symbol varchar(12) primary key, last double, open double, high dou

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

old. Besides that, though, x86_64 is exactly the amd64 architecture. AMD came up with it, Linux called it amd64, and then when Intel copied it and called it EM64T, it was renamed in Linux to x86_64 to be more generic. The above message is the exact one you get when you try to boot an x86_64 k

Re: MySQL Customer Survey :: an exercise in frustration

r previous questions. Many of the questions asked were for things I had already said I didn't use... Regards, Jeremy Daevid Vincent wrote: I started to take this but gave up, here's a few suggestions: 1. you have questions that need a "none" option 2. NEVER make th

Re: MySQL Customer Survey :: an exercise in frustration

Hi, And, what's up with the vertical white lines on dark blue background as a section divider? My eyes actually hurt looking at the survey page. It makes it *very* difficult to read the questions. Regards, Jeremy Daevid Vincent wrote: I started to take this but gave up, here&#x

Re: Oracle is acquiring...............................

Hi, I wouldn't say the Sleepycat/BDB acquisition had anything to do with MySQL. BDB is much more useful *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, J

Re: Arabic text storing problem

Hi, Thanks for the link Is there standalone jar/zip Just for auto_ef Also see Perl module Encode::Guess. There are others out there as well. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: mysql eluding query debugging?

evel 3, which is rather fickle and will page things out when you may not expect it. Alternately, your system is busy enough that things still get paged out at level 2 above in which case the solution isn't necessarily as simple. Regards, Jeremy -- high performance mysql consulting

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

Control test (plain/text LIKE %..%):1.383749s Decrypt test (AES_DECRYPT() LIKE %..%): 1.441944s done <<<<< Nonetheless, I'd still argue that this entire concept is doomed to terrible performance anyway. Regards, Jeremy John Kraal wrote: I put it here: http://pro.dati

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

slow query log) quite frequently. I would think your data can be safer and your security more effective by setting some policies which are less intrusive into the actual workings of the data, such as encrypting backups and setting system-level policies. Regards, Jeremy John Kraal wrote:

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files

s chosen as a vendor in this case.) Do you mean a Serially-Attached SCSI aka SAS controller, I assume? No, it's SATA to SCSI. Interesting. I hadn't heard of such a thing until I just looked it up. But in any case that adds yet another variable (and a fairly unc

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on

Hi Maurice, Do you mean a Serially-Attached SCSI aka SAS controller, I assume? Is this a custom build machine or a vendor integrated one? Regards, Jeremy Maurice Volaski wrote: On Sep 17, 2007 13:31 -0400, Maurice Volaski wrote: In using drbd 8.0.5 recently, I have come across at least

Re: Could drbd randomly flip bits? Was: Database page corruption on disk occurring during mysqldump on a fresh database and Was: Spontaneous development of supremely large files on

data on e.g. the PCI bus is not protected by any sort of checksum. I've seen this cause corruption problems with PCI risers and RAID cards. Are you using a PCI riser card? Note that LSI does *not* certify their cards to be used on risers if you are custom building a machine. Regards,

Re: DIAGNOSTIC MYSQL

Hi Krishna, No, nothing like what you're asking for exists free or open source. Look into Groundwork and Nagios, though they will not do any really fancy monitoring directly out of the box, with a bit of configuration you can get most of what you want. Regards, Jeremy Krishna Ch

Re: excessive time spent in "statistics" status

rtant, since the join order is fixed when you use LEFT JOIN, you *must* list the joins in the correct order when writing the query, otherwise you will see very poor performance. MySQL's optimizer cannot reorder the joins because it has the potential to change the result of the query. Regard

Re: Is bad hardware confusing MySQL and InnoDB?

Hi Maurice, You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs? What is the disk configuration? It sounds to me like bad hardware/software, which, unfortunately MySQL and InnoDB cannot protect you from... Regards, Jeremy Maurice Volaski wrote: Some processes

Re: The current version is 5.0.48, no?

ential, but the community one is only released every so often. If you don't have a MySQL Enterprise login and you want to get the sources/binaries, you can get them from here (under the GPL): http://mirror.provenscaling.com/mysql/enterprise/ Regards, Jeremy Maurice Volaski wrote: Thank you f

Re: Conflicting server IDs on slaves

Hi David, This sounds strange, and should NOT occur because of a server_id conflict. Regards, Jeremy David Schneider-Joseph wrote: Thank you. We had a situation recently where two slaves had a conflicting server ID for several minutes, and shortly thereafter the master started reporting

Re: Really strange index/speed issues

ng off does not affect caching in this sense. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: bitwise logic

tring(packed, 4, 4))) -> ) AS unpacked -> FROM ip; +-+ | unpacked| +-+ | 11.22.33.44 | +-----+ 1 row in set (0.00 sec) Regards, Jeremy Baron Schwartz wrote: I think Gerald was suggesting you convert the IP's into integers and then do bitwise

Re: Integrity on large sites

o the developer. <<<<< We've been working on HiveDB precisely to avoid the large amount of (quite specialized) code in the application. Regards, Jeremy Naz Gassiep wrote: Wow. The problem with sharding I have is the large amount of code required in the app to make it work. IMH

Re: best filesystem for mysql

n and good understanding, rather than getting 1% better performance. That usually means ext3. Regards, Jeremy Jeff Pang wrote: hello list, I saw this article for the suitable filesystem for mysql. http://www.bullopensource.org/ext4/sqlbench/ From what I saw,the best filesystem for MyISAM is

Re: IS NULL Question

Hi John, Are you sure they are actually NULL and not "NULL" (i.e. the string "NULL")? Try this: SELECT first, last, ISNULL(suffix), LENGTH(suffix) FROM persons LIMIT 5; Regards, Jeremy John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL

Re: Why doesn't the InnoDB count() match table status?

l storage engine, there is no such thing as "not using transactions". Even if you don't use BEGIN/COMMIT there are still implicit transactions for each statement. That's the whole point. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- My

Re: Making a prefixed install / hard-wired global configuration files?

Hi Nick, This should do it: --sysconfdir=DIR read-only single-machine data [PREFIX/etc] Regards, Jeremy Nick Hill wrote: Is there an easy way to build MySQL client library, server and start-up script so that /etc/my.cnf is ignored? I need to build client and server so that it in

Want a Free Ride to MySQL Conference and Expo 2007?

winners will be announced shortly thereafter. You can enter by visiting: http://www.provenscaling.com/freeride/ Good luck, and we hope to see you at the conference! Regards, Jeremy Cole Owner / MySQL Geek Proven Scaling LLC -- high performance mysql consulting www.provenscaling.com -- MySQL Gener

MySQL Camp: Proven Scaling offering Free Ride

riday, October 20, 2006. That's only a couple of days away! Good luck! Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL service startup time

to loop and delay until MySQL responds to a simple ping like "SELECT 1". Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: enum query results strange.

ALTER TABLE video ADD INDEX (file_complete, undt); Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie - CREATE VIEW Question

.data SEPARATOR ",") AS all_data FROM table1 JOIN table2 ON table1.siteID=table2.site GROUP BY table1.siteID Regards, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: howto set mysql to readonly

Hi Jehan, OK so it seems to be a bad idea ... I was expecting that I missed a magic command like "set readonly on all databases" ... I think you did: SET GLOBAL read_only=1; This will keep all non-SUPER and non-replication users from writing to the database. Regards, Jerem

Re: Problems with: MySQL 5.0.21 - 64bit

f how poorly an application could be written, it should not be possible for it to freeze the machine. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Exclusion Query

I am working on an MLS Exclusion report. In on table1 I have all the information we collect for our files. Each day I download an update our mls table (table2). what I am trying to do is find all the records in table2 that are not in table1. This is the query that I am using. select * from tb

Re: Importing 3Gb File

if necessary in the mysql.server or mysqld_safe script (those both run as root, so can adjust ulimits upwards). Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: procedure analyse() returns bad type?

, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copy large amount of data from non-normalized to normalized table

art})+${col} as index, p${col} " \ "FROM old_event_data;" done done Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: procedure analyse() returns bad type?

; FLT_MAX) sprintf(buff, "FLOAT(%d,%d)", num_info.integers, num_info.decimals); else sprintf(buff, "DOUBLE(%d,%d)", num_info.integers, num_info.decimals); <<<<< It should likely use num_info.integers+num_info.decimals for the M. Regards, Je

Re: help with storing a large binary number as bigint

n little-endian format, you will need to do the byte-swapping before/after the bin2hex. (In pure PHP, it might be easier after.) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: question+comment : Re: set "DEC" as a column name : forbidden

reserved word in a place where it can't be used as such, they wouldn't need to be reserved words, would they? :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

ecides how many digits to show by default. You can influence that quite easily: mysql> select 1.0/666; +-+ | 1.0/666 | +-+ | 0.00150150150 | +-+ 1 row in set (0.00 sec) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc.

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

it should be capable of doing that calculation using its new precision math support. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: aha! replication breaking due to duplicate queries

a few times, generally). I have seen a case quite a few times where the slave "hiccups" and apparently runs the same query twice. Is it possible that this is what you're seeing? Is your system replicating a mix of large (images, maybe) and small (single-row) updates? Regard

Re: updates during database dump

te at all, to any tables being dumped, while the dump is running. In general, you want a consistent snapshot of all tables from the same point in time, and you will want to use one of the above options to get it. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 --

Re: Outfile syntax and out of memory

10021, 12, 20060412, 23, 95... 10022, 5, 20060412, , 75... But, I never get a complete file. I get a out of memory error after a hour or 2!! This is because the mysql client program is trying to read the entire result into its own memory. Try adding the '-q' option to mysql: my

Re: Streaming LOB Data

do to save some of the memory is to run it as: INSERT INTO tbl (id, image) VALUES (, LOAD_FILE()); This of course would require that you have the file available on the MySQL server to load in. LOAD_FILE() will return the contents of the file. Regards, Jeremy -- Jeremy Cole MySQL Geek, Y

Re: A different authentication question ...

he updated MYSQL authentication method. Hope this helpseven a little. Regards Jeremy www.bluejayspc.co.uk barney wrote: Folk, Just installed MySQL 4.1.14 on a new Windows XP Pro system - this is a development system, no domain. Also installed PHP 4.3.11 and Apache 2.0.55. so now I

Silicon Valley MySQL Meetup Group: Storage Engines in Depth

xt meeting dates, the topics, and RSVP at Meetup.com: http://mysql.meetup.com/101/ I hope to see you there! Regards, Jeremy Cole MySQL Meetup Organizer Silicon Valley -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: bind-address by name under 5.0.18

. Thank you for your assistance. Hmm, I guess you'd expect to at least get warnings for each of these that couldn't be bound to? This seems like a very strange way to configure a machine. To each, his own. :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: bind-address by name under 5.0.18

at this worked. Learn something new every day. Are you having a problem with it? Does it not work for you? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: bind-address by name under 5.0.18

airly trivial, with the caveat that it will have to use the first address returned by gethostbyname(), so if you have multiple IPs assigned to a hostname (for e.g. round-robin DNS) it will be "interesting". :) This is probably a 5-10 line patch, including error checking. Regards, Jeremy

Re: Byte Swapping

toring the data raw -- it seems very odd b. stop storing the data raw... do the swap before storing Can you give more details about what you're doing? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.

Silicon Valley MySQL Meetup: MySQL Optimization, Monday, Feb 13, 2006 @ 7:00pm in Santa Clara, CA

Hi All, Are you interested in MySQL? Do you live/work in Silicon Valley? Join a fun group of professionals for the monthly MySQL Meetup in Silicon Valley, held at Yahoo! in Santa Clara, California. The topic this month is: MySQL Optimization and the EXPLAIN command Speaker: Jeremy

Re: Help...I am desparate

7;s the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Server take 20s to connect

g the 'host' command to determine where the problem is. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL with InnoDB on a readonly filesystem.

gards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting no of different rows by group by clause

Hi Abishek, I want the output as: LHR 3 AKL 2 AWL 1 This should do it: SELECT name, COUNT(*) as num FROM tab_name GROUP BY name ORDER BY num DESC Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http

Re: A "key" question

ows) so it might not be a good idea to run while the market is open. :) If you could provide the exact query you were running, I could confirm that it would or would not help. :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list

Re: A "key" question

(49.76 sec) mysql> select count(*) from ontime_all; +--+ | count(*) | +--+ | 33395077 | +--+ 1 row in set (0.00 sec) Could be a lot faster, even, but these are MERGE tables so it's really 65 tables that are being checked... Regards, Jeremy -- Jeremy Cole MySQL G

Re: LIKE problem?

2304 59317 61621 o 0 60797 60797 p 3048 58573 61621 Sounds like a corrupt index. Try CHECK TABLE and REPAIR TABLE. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Delete all but the newest 100 records?

Hi Brian, Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 Yahoo employs MySQL geeks? Always wondered what db that big index runs on... :) Do note that Yahoo! is a lot more than a search engine. :) The "big index" is not running in MySQL, but a whole lot more is. A

Re: Delete all but the newest 100 records?

and LIMIT are a MySQL-extensions to DELETE, not part of the SQL standards. Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database equivalent to NorthWind for M$ SQL

s: http://dl.flightstats.us/ You can try out a front-end to the data: http://flightstats.us/ It's all public domain. Read about where it comes from: http://flightstats.us/about.php Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL

Re: could a Trigger execute a outside command?

receiving the SIGALRM, the Perl script will be woken up early and get to its work immediately. If something fails for any reason, you go back to the old behaviour of checking every 60 seconds. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQ

Re: zip code search within x miles

equirement usually excludes most BLOB/TEXT fields, so you wouldn't normally include a BLOB/TEXT in a covered index discussion. Covered indexes work fine with CHAR/VARCHAR and are quite common. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailin

Re: weird characters from mysqldump?

rèe becomes Entrèe What gives? Looks like an application of the GIGO (Garbage In, Garbage Out) principle to me. The above data wouldn't have happened to come from a Microsoft Office application, would it? Looks like "Smart Quotes" etc., strikes again, to me. Regards, Jeremy -- Jeremy

Re: Duplicated records

00 90575 1 56575334JulieAnt25 5 5 439584414 2004-10-03 00:00:00 2004-10-03 00:00:00 0 How do I issue a query that finds duplicated Batch number? SELECT Batch, COUNT(*) as Nr FROM QA GROUP BY Batch HAVING Nr > 1 Regards, Jer

Re: How to find missing record?

7; because 1694 divides evenly by 7, whereas 1693 doesn't. This should do it: SELECT Open.id, Open.day FROM Open LEFT JOIN Close ON Open.id=Close.id AND Open.day=Close.day WHERE Close.id IS NULL Regards, Jeremy -- Jeremy Cole (currently in Bangalore) Technical Yahoo - MySQL (Database) Geek De

Re: How to import data from Dbase3?

mygis/ You should be able to load a file, e.g. foo.dbf, by doing: tools/mysqlgisimport -S foo | mysql -u myuser -p mydb It will automatically create a table suitable for the dBase file and load the records in with the above command. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database)

Re: Help with LIKE

Hi Mevers, SELECT * FROM woorden WHERE LIKE % woord % It's not going to be efficient (at all) but you can do: SELECT * FROM woorden WHERE "foo" LIKE CONCAT('%', woord, '%') Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General M

Re: long PHP mysql_connect times [Resolved]

cript, disconnect once at the end. All the extraneous connect/disconnect puts extra, unnecessary load on the database server. I would have never though of / figured that one out. Nobody knows... the troubles I've seen... :) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Data

Re: long PHP mysql_connect times

g in mysql_connect(), run this: $ host foo.example.com Then, take the IP that gives you and do the same: $ host 1.2.3.4 Mainly you're looking for the delay in this second step. -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.

Re: replication errors

ery likely, broken in some way". Why are you using an ALPHA version and expecting it to work perfectly, and when it doesn't, "doubting" MySQL and replication? If you want it to be stable, use a STABLE version. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Dat

Re: Empty 'Relay_Master_Log_File'?

e in the CHANGE MASTER on the slave. Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select where multiple joined records match

;t provide your example table in SQL, and I am unwilling to re-format it into CREATE TABLE/INSERT statemnts to test things. The concepts are solid.) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Importing ArcView Shapefile into a Database

Hi, Sweet! Thank you Jeremy! FYI, make sure you grab the libmygis-0.3.tar.gz or later instead of any other version. I had some silly mistakes that made the DBF file required instead of optional. I've also ported to Mac OS X in 0.3. Regards, Jeremy -- Jeremy Cole Technical Yahoo -

Re: Importing ArcView Shapefile into a Database

it on Windows, as I don't have a Windows compiler suite handy. It would probably mostly compile on Windows. ;) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Importing ArcView Shapefile into a Database

rn it into SQL directly to be imported. You can grab the source code of libmygis at: http://jcole.us/software/libmygis/ If you have any questions or need help getting it to work (hey, it's new!) please feel free to drop me a line. Same goes for feature requests. :) Regards, Jeremy -- Jeremy Col

Re: Compound Order By

y way? ORDER BY city, name http://dev.mysql.com/doc/mysql/en/sorting-rows.html I hope you're wearing a flame-retardant suit, because the flames are about to fly. :) Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists

Re: Syntax diagram, where is it located in the doc?

27; expr %prec NEG | NOT expr %prec NEG | '!' expr %prec NEG | '(' expr ')' | '{' ident expr '}' | MATCH ident_list_arg AGAINST '(' expr ')' | MATCH ident_list_arg AGAINST '(' e

Password Security Suggestions?

ny or all of these? Backend LDAP? PAM? Thanks! -Jeremy

Re: Logging Data: Should I use MyIsam or InnoDB?

ould conceivably be "split" by the sudden change). Does that all make sense? Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Logging Data: Should I use MyIsam or InnoDB?

d data and leave it live (but read only) in case you ever need it. myisampack can help you with that. I hope that helps! Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Strange issue with fulltext searching (is "self" reserved)?

anging their last name to self1 or sel or anything else and then searching for the new term results in me locating the record. Upon changing the name back and rerunning the query I am unable to find them. Is "self" a reserved word? I looked and did not find it. FWIW I am running MySQ

Re: select @qty1=@qty+qty from goods2 , result 0 ?

Hi Shuming, > select qty, @[EMAIL PROTECTED] allqty from goods2 That should be @qty1:[EMAIL PROTECTED] You are doing a comparison using =, which is returning false (0). Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archi

Re: Select Binary Field when UTF8 and Collate

what you want? A binary comparison? To get a case-insensitive comparison use the following: SELECT searchss FROM t WHERE 'bbb' COLLATE utf8_unicode_ci BETWEEN key_low AND key_high; +--+ | searchss | +--+ | str1 | | str2 | +--+ 2 rows in set (0.00 sec) Or is there more tha

Re:RE: Indexing problem with UTF8 in 4.1.4?

characters right now). So using your count of 343 * 3 = 1029. The index prefix lengths, by the way, are in characters not bytes. best regards, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Different default collation in each connection

umn without using the column's default collation is to explicitly specify which collation to use in the comparison with a COLLATE clause like this "COLLATE utf8_polish_ci". It might be a little more work but you'll probably have to dynamically add a COLLATE clause to all your queries based on the language you want. best regards, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: table is full

> > I guess the table is too big. Is there any solution for this problem? > Thanks a million! You didn't search the web for the answer before posting, did you? :-) I'll take a stab in the dark here: http://jeremy.zawodny.com/blog/archives/000796.html Jeremy -- Jeremy D

Re: UTF8 columns and MySQL

> Hello, > > I have a table with the following column among others: > > text VARCHAR(120) CHARACTER SET utf8 > > The provider I am using however only offers MySQL version 3.23.58, > so I cannot use this statement. At first I thought I was not going > to be able to store UTF8. So I changed the c

Re: Different default collation in each connection

I forget which. Collation _can_ be set for individual columns and it sounds like that is what you need to do. This is also important because each column index is collation specific and you need your columns to be indexed for the right collation. best regards, Jeremy March -- MySQL General Mai

Re: Date BETWEEN Question

causing it to return the wrong thing. But in the end, I'm using the proper DATETIME formats for the criteria, which I should have been doing from square one: WHERE completed >= '2004-07-21 00:00:00' AND completed <= '2004-07-23 23:59:59' Thanks again for

Re: innodb - datafiles on an ipstore disk appliance

ts connecting to them (at least on the low end). There's a lot of redundancy because they're designed for just this sort of application. > As for the transaction logs, I haven't reallly thought of it, but to > my understanding management wants it all on the appliance. That&

Re: innodb - datafiles on an ipstore disk appliance

lead to lost transactions. Where do you plan on storing the transaction logs? Also on the appliance or locally? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highpe

Re: Date BETWEEN Question

re I get dates with 2004-07-21! I do have a standard INDEX on the "completed" field, would that have something to do with it? Again, "completed" is a DATETIME field. I have this same table duplicated on 3.23.58 and 4.0.17 with the same results. I'm probably just

Date BETWEEN Question

*and* after 2004-07-21, as desired. But with both operators, it does not work. I have tried this query on both 3.23.58 and 4.0.17. I searched the net over and could not find a definitive answer to this problem, so apologies if it's been answered before. TIA, Jeremy Brown -- MySQL Gene

Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

On Fri, Sep 17, 2004 at 04:01:53PM +0300, Egor Egorov wrote: > Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > >> I can verify that a quad opteron 2.2 runs about a million times > >> better than a quad xeon 3.06. The opteron can handle more than 3 > >> gigs

Re: Installing DBIx::DWIW on CPAN

l line 10. > make: *** [test_dynamic] Error 2 > > Any help will be highly appreciable. Install Time::HiRes from CPAN. The Makefile should have caught that but didn't. I'll fix that on my end. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! &

Re: Installing DBIx::DWIW on CPAN

/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz Works for me. How about you? I checked and the mirrors on both machines behind cpan.yahoo.com are up-to-date. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Pe

Re: Installing DBIx::DWIW on CPAN

dex that's out of sync with the actual data? I've seen that happen before (rsync isn't atomic in that way). And 0.41 is fairly new. I'd try another mirror. It's current on cpan.yahoo.com, for example. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazin

  1   2   3   4   5   6   7   8   9   10   >