Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but when I try
to boot it I get various errors about "this CPU does not support long
(something) please use a 32-bit OS" - the 64 bit install CD says the same
message. So I assume these are not 64 bit CPUs.
They almost cer
I just finished it. There were 56 questions, not counting the final
"give us your name" stuff for the prize. Most of the questions were
mandatory.
This seems to be a "fill out the form" type of survey system rather than
a self-adjusting system based on the answers to your previous questions.
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's a few sug
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,
Jeremy
Sh
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/m
Hi Moritz,
Thus, my questions:
- what's wrong with that query? I know they are big tables, but
according to EXPLAIN, this should be fast enough, because mysql's seeing
the indexes just fine.
As others have said, likely nothing wrong with the query per se. It
just sounds like you're hitting
7;re in, you're in. But it's
a request and I'm happy to oblige. Even if it only stops them for 1
minute (which could be enough).
Regards,
John
--
/ Humanique
/ Webstrategie en ontwikkeling
/ http://www.humanique.com/
-
Humanique zoekt een ervaren Web-ontwikkelaar (PHP).
Bekijk
Hi John,
Your attachment for the php code got stripped somewhere. Can you post
it somewhere (http preferable)? In either case it's going to result in
a full table scan, so they are actually both a bad strategy long term,
but they should in theory perform as you would expect, with with
encry
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
I am hoping they are not related. The problems with MySQL surfaced
almost immediately after upgrading to 5.0.x.
It's possible that they are no
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 tw
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
There are absolutely many places where corruption could occur between
MySQL and the physical bits on disk. The corruption you're seeing does
n
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 Chandra Praja
Hi Shawn, Lucio,
SELECT STRAIGHT_JOIN
FROM ...
LEFT JOIN ...
WHERE ...
...
Just to correct a point here... if a query uses only LEFT JOIN or RIGHT
JOIN, the join order is fixed by the query's order itself, so using
STRAIGHT_JOIN should have no effect whatsoever. Equally important,
sin
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 on a s
Hi Maurice,
Yep, it's very very confusing these days. Unfortunately for all of us,
MySQL's sales organization seems happy with the situation. Blame them.
And, yes, you're correct, compared to MySQL Enterprise, 5.0.45 is indeed
out of date now. The releases are sequential, but the community
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
Hi Chris,
Chris Hemmings wrote:
Hello,
I have a table, currently holding 128,978 rows... In this table, I have a
section column (int) and a price column (int). Every row has a section of 1
currently, every row has a price, ranging from 1 to 10,000.
I have an index on both columns separate
Hi,
You can actually unpack them using some fairly cryptic stuff. I would
only use this to unpack them once to re-store them as INT. Here's an
example:
CREATE TABLE ip (packed CHAR(4));
INSERT INTO ip (packed) VALUES (0xB16212C);
mysql> SELECT * FROM ip;
++
| packed |
++
|
Hi Naz,
Just to throw out (plug) an ongoing project:
http://www.hivedb.org/
From the site:
>
HiveDB is an open source framework for horizontally partitioning MySQL
systems. Building scalable and high performance MySQL-backed systems
requires a good deal of expertise in designing the sy
Hi Jeff,
There isn't really a clear winner in any case, but the tests done in the
article linked to are highly suspect. It would be much more interesting
to see real tests done with real hardware...
Nonetheless, the usual answer I would have is to lean towards ease of
administration and goo
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 value is,
but I can't get N
Hi Daevid,
Ugh. How about not going berserk on the public mailing list?
We can understand that you're upset that you didn't read the manual
before starting a MyISAM to InnoDB conversion. You didn't do your
research and now you're being hit by a very simple (and not really all
that unexpecte
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 no
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
Hi All,
As you may know, MySQL Camp, a gathering of the best minds in MySQL, is
coming up soon, in just over three weeks. It will be held at Google HQ,
in Mountain View, California, November 10-12. You can find out more
information about the conference here:
http://mysqlcamp.org/
Proven S
Hi Rob,
I have an application self-installer program which also installs
MySQL and sets it up. This is all on Windows.
I have a problem in that when the installer runs 'net start MySQL',
it returns immediately but the MySQL daemon is not ready for
connections immediately. As the next step in th
Hi,
both queries would have the limit on them, so they would only return 10
rows. but yes, there are probably about 10x as many records with true than
with anything else.
If there are only six possible values, and one values occurs ten times
as often as the other five values, that means it oc
Hi,
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
site
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,
Jeremy
--
high pe
Hi Gabriel,
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause... if this
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
,
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]
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]
; 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
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
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]
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.
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]
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
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
--
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
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
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
. 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]
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]
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
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.
7;re interested in:
http://mysql.meetup.com/101/poll/
If you have any questions about the group or the event, please feel free
to contact me directly.
See you on Monday!
Regards,
Jeremy
--
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
--
MySQL General Mailing List
For list
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
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]
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]
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
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
(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
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
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
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]
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
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
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
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
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
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
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)
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
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
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.
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
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]
;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]
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 -
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
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
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
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
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]
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]
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
E table is an atomic operation and can be done
while the server is up and running full-speed without any problems.
Regards,
Jeremy
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jeremy Cole <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Training and Co
version of 3.23 that _wasn't_
compiled by MySQL AB (you didn't get it from mysql.com) installed before?
> Excellent work to the MySQL dev team =)
Thanks!
Regards,
Jeremy
--
To learn more about consulting, visit http://www.mysql.com/consulting/
__ ___ ___ __
/ |/ /_
know of work with this principle.
Regards,
Jeremy
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Jeremy Cole <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Clarksville, Tennessee, USA
<___/ Developer
-
81 matches
Mail list logo