fool my package management system (RPM on RHEL) into
doing multiple installations?
Thanks,
Mike Spreitzer
I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?
Thanks,
Mike Spreitzer
bin/mysqld: ready for connections.
Version: '5.1.34-community-log' socket: '/var/lib/mysql/mysql.sock' port:
3306 MySQL Community Server (GPL)
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
Thanks,
Mike Spreitzer
l
restart, the best I could hope for would be to quickly delete the
partially loaded data and start loading it all over again, right? (Now I
see why it was suggested I break this data file up into smaller pieces.)
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/
g it. The
server continued working on that statement for a while. I then tried
`/usr/share/mysql/mysql.server stop`; that has been in progress for a
while now, has printed about 320 dots so far. What is the fastest way to
get this thing aborted?
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, L
ine (and I
am not using replication) if necessary; is there a faster way to do that
than uninstall and reinstall?
Thanks,
Mike Spreitzer
Mike Spreitzer/Watson/i...@ibmus
06/12/09 12:57 PM
To
Michael Dykman
cc
mysql@lists.mysql.com
Subject
Re: Mysterious progress after recovery in MySQL
times the size of T. There has to be
a better way!
Thanks,
Mike Spreitzer
Yes, for each (S, I) pair the goal is to efficiently find the next largest
integer associated with S in T. For the highest integer I associated with
S in T, there is no next larger.
Thanks,
Mike Spreitzer
Peter Brawley
06/20/09 08:56 AM
Please respond to
peter.braw...@earthlink.net
To
did NOT say a given integer I is
associated with only one string S):
SELECT a.s, a.i, MIN(b.i) AS j
FROM t AS a
JOIN t AS b ON b.i > a.i AND a.s = b.s
GROUP BY a.i
Thanks,
Mike Spreitzer
Peter Brawley
06/20/09 12:39 PM
Please respond to
peter.braw...@earthlink.net
To
Mike Spreit
be paired with several
strings.
Thanks,
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Peter Brawley
06/20/09 03:59 PM
Please respond to
peter.braw...@earthlink.net
To
Mike Spreit
(size of T) * (avg num
integers per string)^2 ) to O( (size of T) * (avg num integers per
string)^1 ). That's great. We have saved about a factor of 100 in my
real application (a given string is paired with something on the order of
100 different integers). But we could sa
nf, expanding key_buffer to 8G,
myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
disk.
Thanks,
Mike Spreitzer
Actually, my characterization of the current state is wrong. It appears
that one core is completely busy, I suppose MySQL does this indexing work
in a single thread. Is it reasonable for indexing to be CPU bound?
Thanks,
Mike Spreitzer
Mike Spreitzer/Watson/i...@ibmus
06/25/09 01:30 AM
_created | 4 |
| Threads_running | 2 |
| Uptime| 202522 |
| Uptime_since_flush_status | 202522 |
+---+----+
Thanks,
Mike Spreitzer
mos
06/25/09 01:05 PM
To
mysql@
Today's instance finished shortly after I sent the email below. BTW, here
are some specifics on the table (which uses MyISAM). Thursday's instance
has 11 GB of data and 0.78 GB of index. Today's instance has 26 GB of
data and 1.8 GB of index.
Thanks,
Mike Spreitzer
Mike S
Suppose I have a table of a few thousand people, with a FirstName field
and a LastName field. Sadly, my people are not so regular. Some names
have three parts (e.g., due to marriage) crammed into the two fields
("Hillary Rodham Clinton"). Some even have titles ("Dir, gastroent.
dept., Fubar
this going to fly, in terms of latency for the incremental lookups and
overall load at the hosting site?
Thanks
"Jerry Schwartz"
09/21/09 03:47 PM
To
"'Michael Dykman'" , Mike Spreitzer/Watson/i...@ibmus
cc
Subject
RE: incremental name search?
SoundEx doe
These are names&titles of Americans. This web app and database do not
exist now (the current procedure is done with more primitive tech), and so
I can make plausible adjustments to the plan.
Thanks
Mike Spreitzer/Watson/IBM
09/21/09 04:10 PM
To
"Jerry Schwartz"
cc
&q
I'm not sure whether the following will meet your needs. Have you
considered
SELECT title FROM Title WHERE NOT EXISTS (SELECT * FROM Keyword,
TitleKeyword WHERE Keyword.kw='A' AND Keyword.id=TitleKeyword.keyword_id
AND TitleKeyword.title_id=Title.id)
Regards,
Mike Spreit
Are there any publicly available data on how the size of some (or better
yet, many) particular "real" database(s) changed over time (for a longish
period of time)? How about data on how the throughput (in any interesting
terms) varied over time?
Thanks,
Mike Spreitzer
-1el6.x86_64
libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
libzip.so.1()(64bit) is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
python-paramiko is needed by
mysql-workbench-gpl-5.2.25-1el6.x86_64
Thanks,
Mike Spreitzer
this
query run about as fast as can be expected, right? It did not take
anywhere near 9 hours to make the fldrcv table ... so why is it taking so
long to do this join to make the fldpar table?
/etc/my.cnf is based on the distribution's my-huge.cnf, with only minor
customization.
Thanks,
Mike Spreitzer
suggestions.
Thanks!
Mike Spreitzer
Sure, `wc` is different from mysql --- but different enough to account for
a 16000:75 ratio?
Will iostat give a good utilization metric for GPFS?
If I want to try to actually hold a 2GB table in RAM, is there anything I
need to set in my.cnf to enable that?
Thanks,
Mike Spreitzer
SMTP: mspre
s.
Thanks,
Mike Spreitzer
oking into
better server&disk and rewriting my query along the lines you suggested.
Thanks!
Mike Spreitzer
SMTP: mspre...@us.ibm.com, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
t(*) |
+--+
|29036 |
+--+
Thanks,
Mike Spreitzer
-+
2 rows in set, 1 warning (0.00 sec)
mysql> explain extended select * from fldrcv straight join fldsndm on
(fldrcv.q=fldsndm.p AND fldrcv.qboot=fldsndm.pboot and
fldrcv.msgid=fldsndm.msgid);
ERROR 1054 (42S22): Unknown column 'fldrcv.q' in 'on clause'
mysql>
Thanks,
Mike Spreitzer
Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT
JOIN".
Thanks!
Mike Spreitzer
0.00
0.000.00 0.00 0.00
dm-1 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.000.00 0.00 0.00
Thanks,
Mike Spreitzer
From: Mike Spreitzer/Watson/i...@ibmus
To: Dan Nelson
Cc: MySql
Date: 08/11/2010 01:30 PM
Subject:Re: idle query
,
Mike Spreitzer
From: Jaime Crespo Rincón
To: Nunzio Daveri
Cc: Guifre Bosch Fabregas ,
mysql@lists.mysql.com
Date: 08/13/2010 04:07 AM
Subject:Re: RHEL Auto Start / stop mysql???
2010/8/12 Nunzio Daveri :
> Hi Guifre, thanks for answering. I already have mysql instal
I am new to MySQL, and wonder if I have done something terribly stupid. I
have an InnoDB table with 27 million rows. Without thinking very much, I
issued the following command through the GUI administration tool:
ALTER TABLE `wyky`.`externallinks` ADD COLUMN `el_p2` BLOB NOT NULL AFTER
`el_i
final data in the new column. So I infer there is no big motivation
to interrupt the operation I have going.
Thanks,
Mike
"Baron Schwartz" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/19/08 08:13 PM
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
and
use another instance of the GUI administration tool.
If I succeed in interrupting this operation, presumably the rollback will
take quite a while. How can I tell whether I have successfully
interrupted the operation and the rollback is what's nailing my machine?
Thanks,
Mike Spreitzer
I have a table with millions of rows. I am not sure exactly how many rows
it has, I get a different answer every time I ask! What's going on here?
This DB is used only by me, and only by explicit commands --- I have no
background or on-line tasks using the DB. This is the DB that took 2 days
Thanks to both Dans, that's it. This even discussed in the refman, at (
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html).
In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes.
Thanks,
Mike
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still get Errcode: 13. I
ca
19:11 red1_p2.sql
[EMAIL PROTECTED] /]#
Thanks,
Mike
Jed Reynolds <[EMAIL PROTECTED]>
02/22/08 07:04 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql list
Subject
Re: mysqldump: Got error: 1: Can't create/write to file
'dumpdir/ta
.00$ ls -l
total 16
-rw-r--r-- 1 mysql mysql 29 Feb 22 20:46 foo.bar
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
-bash-3.00$
Thanks,
Mike
Jed Reynolds <[EMAIL PROTECTED]>
02/22/08 07:24 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
I just got an email from the list robot asking me to confirm my request to
unsubscribe. The only problem is, I did not ask to unsubscribe! Is
anybody else getting this?
Thanks,
Mike
I had the same problem. I found the distribution contains some prototypes,
with slightly more elaborate names.
Regards,
Mike
kalin m <[EMAIL PROTECTED]>
03/18/08 01:06 PM
To
mysql@lists.mysql.com
cc
Subject
default my.cnf?
hi all...
i have a 5.0.33 build from source on a freebsd 4.10
15 01:30 /e5servers.txt
-rwxr-xr-x 1 mysql mysql 178746 Aug 15 01:30 /e5subscribers.txt
-rwxr-xr-x 1 mysql mysql 627939 Aug 15 01:30 /e5topics.txt
[EMAIL PROTECTED] mysql]# rpm -q -a | grep -i mysql
mysql-query-browser-5.0r12-1rhel4
mysql-gui-tools-5.0r12-1rhel4
MySQL-server-community-5.0.51a-0.rh
42 matches
Mail list logo
