RE: localhost vs domain for connection string

-Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, November 23, 2010 6:19 AM To: Brent Clark Cc: mysql mailing list Subject: Re: localhost vs domain for connection string IIRC, localhost is seen by the client as a magic

RE: question about restoring...

I must have missed something way back in the beginning. I thought the original poster had a dump of his database. I have no idea if you can attach the innodb files to another database. I stand corrected. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: question about restoring...

Then I guess it's a matter of preference. I'd rather edit a text file than build a new instance of MySQL. On the other hand, if he has a development environment (as we all, of course, do) then he could futz around in there. Regards, Jerry Schwartz Global Information Incorporated 195

RE: numeric comparisons

upon the native precision of the machine, how the language chooses to cast the operands, and how (or if) the compiler chooses to reorder the operations. I would not rely on the result being the same if you changed software versions, let alone languages. Regards, Jerry Schwartz Global Information

RE: SQL book recommendation?

You might want to use an on-line introductory course, if you have time for the leisurely pace. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com

RE: Failover on master/slave replication

to identify and fix whatever the problem was. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Machiel Richards [mailto:machi

RE: How do I use and JOIN the mysql.time_zone% tables?

are the time zone tables updated? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Daevid Vincent [mailto:dae...@daevid.com

RE: SELECT WHERE IN help

in this case I need to change my design . [JS] You can accomplish your goal by using a sub-select to create a table that has 3 in it twice, and then JOIN it to the original table. As for why you would want to do this, that's another story. It sounds like you went down the wrong road. Regards, Jerry

RE: Update record count

-Original Message- From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] Sent: Thursday, September 16, 2010 9:51 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Update record count On 9/16/2010 5:12 PM, Jerry Schwartz wrote: I should be able to figure this out, but I'm

Update record count

. The numbers reported were way too high, and I don't understand it. I can supply more information, if necessary, but have I gone off the rails somehow? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je

RE: Unique ID's across multiple databases

that you don't have to worry about it. I can't speak to the speed. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com So, I'm thinking about a composite unique

RE: Unique ID's across multiple databases

, using FibreChannel over IP. I've been out of this market (sales/support side) for many years, so I don't know what the current technology costs, but if you can afford it that is the way to go. It will make your life much simpler. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Unique ID's across multiple databases

-Original Message- From: Kiss Dániel [mailto:n...@dinagon.com] Sent: Monday, September 13, 2010 11:49 AM To: Jerry Schwartz Cc: Johan De Meersman; Max Schubert; mysql@lists.mysql.com; replicat...@lists.mysql.com Subject: Re: Unique ID's across multiple databases Well, not exactly. I do

RE: Unique ID's across multiple databases

From: Kiss Dániel [mailto:n...@dinagon.com] Sent: Monday, September 13, 2010 3:17 PM To: Jerry Schwartz Cc: Johan De Meersman; Max Schubert; mysql@lists.mysql.com; replicat...@lists.mysql.com Subject: Re: Unique ID's across multiple databases Well, that would be the plan, yes. :-) Anyway, I'll

RE: Replaying the mysqld.log file from production onto QA???

If possible, use web server logging to get the timings. As I explained in my previous essay, this is not at all simple or easy. If you run a benchmark more than once, be sure to reboot the system between runs. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: newbie question database tables

Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Friday, September 10

RE: Best method to keep totals

-Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, September 02, 2010 1:52 PM To: mysql@lists.mysql.com Subject: RE: Best method to keep totals From: Jerry Schwartz je...@gii.co.jp IMNSHO, never store dynamic data in a field unless you absolutely have

RE: Database design help

, and took their sales history with them! That was a mess to unscramble. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Neil

RE: Best method to keep totals

IMNSHO, never store dynamic data in a field unless you absolutely have to. There are going to be exceptions, but unless a manager is going to participate in hundreds of thousands of fixtures I don't think this is one of them. Regards, Jerry Schwartz Global Information Incorporated 195

RE: How To Duplicate Number of Hits from Prod Sever to NEW QA server?

to eyeball exact numbers. - If you wind up sitting across the table from someone who brought colored pencils and a ruler, prepare for the death of 1000 cuts. Now you know why I got out of the performance consulting business. Good luck. Regards, Jerry Schwartz Global Information Incorporated 195

RE: Complicated SQL Query

be the only way to go. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

-Original Message- From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] Sent: Thursday, August 19, 2010 7:25 AM To: mysql@lists.mysql.com Cc: Jerry Schwartz; 'Lord_Devi' Subject: Re: OpenOffice, Go-OO, ODBC, Offline Data Entry Hi! Jerry Schwartz wrote: I deal with a somewhat similar

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

have non-overlapping customers, or whatever, then it won't be too bad. You'll have to judge for yourself. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com

RE: Slow query using string operator

-Original Message- From: Travis Ard [mailto:travis_...@hotmail.com] Sent: Tuesday, August 10, 2010 6:53 PM To: 'Jerry Schwartz'; mysql@lists.mysql.com Subject: RE: Slow query using string operator Can you create a second, indexed column in your feed_new temp table that includes the title

RE: Slow query using string operator

Extra: Using where; Using index == It look like the optimizer flipped the JOIN around so that it could use the key in feed_new. Thanks for your help, all. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

Slow query using string operator

as to how to speed this business up? I can't get away without some string manipulation, because I'm looking for near matches by ignoring the year at the end of the title. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: ORDER BY LIMIT issue

Because you are sorting the results, the LIMIT clause has to be applied after all of the eligible rows have been retrieved. There shouldn't be a big difference between 2 and 3, but there would be between 2 and 2. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave

RE: idle query

invented the sharp stick.] Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com You're doing ~75 I/O's per second, so it looks like you're running on slow SATA drives

RE: combined or single indexes?

than you can type, I should think. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com Cheers Neil On Thu, Jul 22, 2010 at 5:20 PM, Shawn Green (MySQL

RE: combined or single indexes?

From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Thursday, July 22, 2010 4:50 PM To: Jerry Schwartz Cc: Shawn Green (MySQL); mysql@lists.mysql.com Subject: Re: combined or single indexes? Thanks for the information Jerry. Just to confirm, you mentioned if you only need one

RE: How to become a DBA on MySQL

of hours for me to blow through it. This is especially true since actual documentation has become almost a lost art. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com

RE: query executes very slow in a table with 2m records

it can use an index, and it probably doesn't have a high enough cardinality to be used. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message

RE: How to become a DBA on MySQL

too many reference books are written on the principle of If you know exactly what you want to do, here's roughly how to do it. You can wander around for a long time not knowing what a feature is for. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: How to become a DBA on MySQL

to that. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Keith Clark [mailto:keithcl...@k-wbookworm.com] Sent: Tuesday, July 13, 2010 3

RE: MySQL For Huge Collections

it somewhat more complicated to detect line boundaries, but it would preserve the layout for eventual presentation. You’ve just complicated the whole process enormously. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX

RE: MySQL For Huge Collections

! This has bitten me more than once. This was fun, I hope my suggestions make sense. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL General Mailing List For list archives: http

RE: How can I see the query from a remote session against my server

file. Either the feature doesn't work, or I'm blind. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -Original Message- From: Anirudh Sundar [mailto:sundar.anir...@gmail.com] Sent

RE: Slow when using sub-query

Advanced Tuning course that addresses all this and more, as does Baron C° 's excellent MySQL book. [JS] No doubt. Our database is so small, and my duties are so diverse, that tuning only gets my attention when a problem interferes with other people's productivity. Thanks. Regards, Jerry

RE: Strange errors / messages on slave server

. In less technical terms, if the master goes faster than the slave, the slave will puke. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Machiel Richards -Original Message- From

RE: large table issue

Just a note from a kibitzer: if you include an EXPLAIN, why not use \G so that it is easier to read? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -Original Message- From

Slow when using sub-query

key_len: 48 ref: rows: 1544 Extra: Using where; Using temporary; Using filesort 3 rows in set (0.03 sec) = What a difference! I don't understand it, though. Does anyone want to take on the challenge of educating me? Regards, Jerry Schwartz Global Information

RE: Using RAND to get a unique ID that has not been used yet

order, random or anything else. Just select a random record from that table. Since you'll have the number of that record, you can delete it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com

RE: Using RAND to get a unique ID that has not been used yet

slower and slower as we ran out of unique keys. Eventually the whole application became unusable. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Thanks, Andre -- Andre Matos andrema

RE: mysqldump backup

using the cat (*nix) or copy (Windows) command to trash a little bit of it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- Raj Shekhar - If there's anything more important than my ego

RE: Slow query using string functions

-Original Message- From: Gavin Towey [mailto:gto...@ffn.com] Sent: Wednesday, May 26, 2010 7:39 PM To: je...@gii.co.jp; mysql@lists.mysql.com Subject: RE: Slow query using string functions Jerry, Are you sure this is really your explain plan for this query? That's not at all what I

RE: Slow query using string functions

I haven't had a chance to try that, and this might be totally useless information, but to create a clone of the bigger table (CREATE LIKE and INSERT INTO) takes about 12 seconds. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796

Slow query using string functions

that slow? I suspect it would be faster if I built separate tables that had just the shortened versions of the titles, but I wouldn't think that would be necessary. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: Security issues

Back when this was a day-to-day concern of mine, I used to check CERT's website (the section now known as their Vulnerability Notes Database, http://www.kb.cert.org/vuls). Unfortunately, I see that the last entry for MySQL is from years ago. Regards, Jerry Schwartz Global Information

RE: Security issues

a product. [JS] This is always a tough call for a software developer. On the one hand, announcing an unfixed problem alerts users; but at the same time, it also alerts abusers. Some companies go one way, some go the other. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington

RE: Replication : request DELETE is not executed on slave

. The DELETE... LIMIT 7500 would have to be translated into 7500 separate DELETEs, and there would have to be some unique way of identifying the individual records. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: better way to backup 50 Gig db?

-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Wednesday, April 21, 2010 2:12 AM Cc: mysql@lists.mysql.com Subject: Re: better way to backup 50 Gig db? [JS] snip [JS] Unless I've forgotten something from earlier in my career (what day is it, anyways?),

RE: Tokutek Acquires Oracle

Happy April Fool's Day. 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 -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent

RE: Trancate table from command line?

Am I missing something? Doesn't the -e parameter for the mysql CLI still work? I use it all the time in my scripts. mysql -ulogin -ppassword -e truncate sometable your_dbname Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: dash was converted o a wierd character

End If OutString = OutString # CodePoint ; End If Next I MyHTMLEncode = OutString End Function == I hope this helps somebody. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796

RE: Trancate table from command line?

-Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Wednesday, March 17, 2010 10:07 AM To: '??? '; 'John Oliver' Cc: mysql@lists.mysql.com Subject: RE: Trancate table from command line? Am I missing something? Doesn't the -e parameter

RE: Particular value or NULL

My query isn't slow enough to tell the difference, I'm only working with a few hundred records. This was intellectual curiosity. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the

Particular value or NULL

Is there a better construct for the WHERE clause in a LEFT JOIN than WHERE (x = 17 OR x IS NULL) ? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 http://www.the

RE: Particular value or NULL

to be evaluated over and over again from scratch. 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 Jerry Schwartz jschwa...@the-infoshop.com escreveu na mensagem news

RE: Full Text Searches

to discover this, but I think this is really neat. [JS] I never did it with a view, I just did it with a join. Works fine, lasts a long time. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: Partitioning

-Original Message- From: John Daisley [mailto:mg_s...@hotmail.com] Sent: Tuesday, February 23, 2010 6:07 AM To: jschwa...@the-infoshop.com ; mysql@lists.mysql.com Subject: RE: Partitioning Hi Jerry, I guess modification of the table is needed! What are you trying to achieve

RE: Partitioning

From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, February 23, 2010 5:52 AM To: Jerry Schwartz Cc: MY SQL Mailing list Subject: Re: Partitioning that's very much gonna depend on what your selects look like. For example, a low-cardinality

Partitioning

not qualified to judge my predecessor.) How could I partition this table in a useful way? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 http://www.the-infoshop.com www.the-infoshop.com

RE: how things get messed up

bigger databases running quite well. 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 From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Friday, February 19

RE: how things get messed up

From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Wednesday, February 17, 2010 11:41 PM To: Jerry Schwartz Cc: MY SQL Mailing list Subject: Re: how things get messed up Dear Jerry Schwartz We have applications for colleges in India. The same idea of having single table for manipulating

RE: how things get messed up

on optimizing any or all of the above - Management meddling A profiler that could integrate all of the above would be a nifty tool, wouldn't it? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: how things get messed up

to look. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: how things get messed up

engine read only parts of a file record? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: help me out for this scenario

for each occurrence for each user: Emp_id, login_number, login_time 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 -- MySQL General Mailing List For list archives: http

RE: how things get messed up

had the pleasure of writing perfect programs whose logic I was unable to understand a week later. 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 -- MySQL General Mailing

RE: how things get messed up

[JS] Storing BLOBs in a table must slow down the inner workings of the database engine. After all, the tables are really disk files under the covers. Can the database engine read only parts of a file record? Jerry Schwartz Well, there's where things go wrong -- first of all, a database

RE: dumping error

have installed the mysql. [JS] The normal installation process (using the .msi) on Windows will append the MySQL bin directory to the PATH variable. If you use the zipped version and install the files yourself, you have to modify the path yourself. Regards, Jerry Schwartz The Infoshop

RE: WAMP vs LAMP

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 From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com] Sent: Friday, January 29, 2010 5:49 PM To: Jerry

RE: WAMP vs LAMP

Thanks for the clarification. As I understand it, the syntax on the client end is to use . as the host name. I was using localhost on the LAMP configuration, and never bothered to change it. With 7 or so web-based users, there isn't much rush. Regards, Jerry Schwartz The Infoshop by Global

RE: WAMP vs LAMP

From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com] Sent: Thursday, January 28, 2010 2:03 PM To: Jerry Schwartz Subject: Re: WAMP vs LAMP [JS] The file paths were all the same, actually, and the address for MySQL is just “localhost”. [WB]Consider to use MySQL on Unix like environment

RE: Good source for sample data?

of security screening for a registration system. 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 -Original Message- From: Shawn McKenzie [mailto:nos...@mckenzies.net] Sent

RE: Good source for sample data?

That's brilliant. The only minor issue is that, at least for UK data, it won't validate for mapping purposes - the postcodes are syntactically correct, but non-existent. I don't know if it would have the same problem for US or Canadian data. [JS] Sorry, my suggestion won't work either: I didn't

RE: how to dump database or tables

the archive name. = C:\Program Files\7-Zip\7z.exe e zip file name | mysql [-hhost] -ppassword -uuser reload_log.txt = That should do you. 7-Zip is a free compression/decompression program for Windows. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave

RE: Good source for sample data?

-Original Message- From: Mark Goodge [mailto:m...@good-stuff.co.uk] Sent: Friday, January 29, 2010 10:32 AM To: mysql@lists.mysql.com Subject: Re: Good source for sample data? On 29/01/2010 15:20, Jerry Schwartz wrote: snip [JS] Sorry, my suggestion won't work either: I didn't notice

WAMP vs LAMP

From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, January 27, 2010 12:18 PM To: Jerry Schwartz Cc: shawn.gr...@sun.com; Daevid Vincent; Dan Nelson; mysql@lists.mysql.com Subject: Re: Event feature already working in Server 5.1.37 On Wed

RE: Event feature already working in Server 5.1.37

it probably isn't as physically robust as a server grade machine at twice the price; but if it dies, I can be up and running on a newer, bigger, cheaper machine in little more than the time it takes me to run to the nearest big-box store. Regards, Jerry Schwartz The Infoshop by Global Information

RE: Join Suddenly Failing

since it was last used in 2009. All of a sudden the following script started throwing an error. SELECT contactinfo.contactdata, contactinfo.ContactID FROM team, person, teamperson [JS] Try making those JOINs explicit, I do believe they are treated differently in recent versions. Regards, Jerry

RE: Record old passwords ?

As an auditor once told me, If you can do your job, then I'm not doing my job. 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 -- MySQL General Mailing List For list

RE: Regarding storing non-english chars in mysql

. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind to tell me which newer

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

Dear Jerry, OH 32 Bit php is good for working with 64 Bit MySQL ? [JS] Yes, it's fine. Remember, MySQL is a server - it doesn't care who is on the other end, so long as the queries are properly formed. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington

RE: Help with export and import into Oracle

when otherwise stumped. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: mysqld occupies 100$ cpu

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 -Original Message- From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com] Sent: Monday, January 11, 2010 2:51 AM To: mysql

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

Dear Jerry, Would you mind to tell me how to update ( what tool/editor ) all of your php source code for using with your new version of php and mysql ? [JS] If I had one, I would do it. I've been using an editor named Textpad for a very, very long time but despite its many features I wouldn't

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

-Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Sunday, January 03, 2010 2:13 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Dear Jerry, Sorry... I just visit www.php.net... BUT I don't quite understanding the online manual: http://www.php.net/manual/en

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Monday, December 28, 2009 9:25 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: -Original Message- From: Edward S.P

RE: help design the table

-Original Message- From: Mikhail Berman [mailto:mikhail...@gmail.com] Sent: Wednesday, December 23, 2009 9:16 AM To: Eva Cc: mysql@lists.mysql.com Subject: Re: help design the table Hi Eva, It seems to me that you might want to have two tables that will describe data in your database *

RE: Innodb buffer pool size filling up

purpose, which is to avoid having to do a physical disk I/O operation. If a buffer pool never fills up, it is too big. 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

RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance

to. 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 Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Count records in join

`.`id_prod` WHERE `r`.`id_prod` IS NOT NULL GROUP BY `p`.`id_prod`; = do what you want? That should find only those rows in `programmas` that match rows in `events`, and give you the number of events for each one. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195

RE: Innodb buffer pool size filling up

triggered until the buffer pool is full; but that is simply a guess, I really have no idea. 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 Regards Machiel From

RE: Best way to purge a table

-Original Message- From: Jones, Keven [mailto:keven.jo...@ncr.com] Sent: Monday, November 09, 2009 11:21 AM To: mysql@lists.mysql.com Subject: Best way to purge a table Hi, I need to get rid of all data in one table of my database. The table just has old Data that I no longer need. What

RE: insert warning - how to look at

-Original Message- From: Sydney Puente [mailto:sydneypue...@yahoo.com] Sent: Friday, October 30, 2009 10:36 AM To: mysql@lists.mysql.com Subject: Re: insert warning - how to look at Thanks johan, Very useful - it seems so obvious now! There is an associated problem with transferring data

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

-Original Message- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Monday, October 26, 2009 5:29 AM To: Jerry Schwartz Cc: [MySQL] Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 Thanks for the response Jerry. I suppose my main question

<    1   2   3   4   5   6   7   8   9   >