Hi all,
I use Gmane (http://gmane.org) to read/post to mailing lists as news
groups.
Is there any way of switching off delivery of mail from this list whilst
remaining subscribed? I've had a look around and there doesn't appear
to be...
Regards,
Sebastian
--
Emacs' AlsaPlayer - Music Without
Hi all,
I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
mysqld uses 14.3% of memory when idle.
Is this a known issue?
I'm aware that version 5.0 is not the latest version but it's the one
currently shipped by Debian Lenny (testing) so I'm loathe to 'manually'
install a later
Might be a bit late, but on the naming issue: why not rename the
tables on the old database before doing the dump? that would save you
from potentially messing with your data due to parsing problems.
Just a thought :)
Walter
OlinData: Professional services for MySQL
Support * Consulting *
Hey,
Thanks a lot! I didn't see this response until now.
I did not try it as I went with the column based solution. However
this looks like it will work.
I will implement and let you know.
Thanks again,
On 1/23/09, Peter Brawley peter.braw...@earthlink.net wrote:
Attila,
I would like to
You could bring it down, but the real question is if you really want
to do that? Making the buffers and caches smaller will reduce the
memory used, but it also reduces performance.
Could you tell us what you are hoping to use MySQL for and why you
wanna bring the memory usage down?
Walter
I'm considering MySQL certification, and I'm wondering which
certifications I should target. I've been developing using MySQL for
about 4-5 years, but am looking to get out of development and into a
DBA role. I've worked with various database engines for about 20
years, so it would seem
Walter Heck li...@olindata.com writes:
Might be a bit late,
Better late than never.
but on the naming issue: why not rename the tables on the old database
before doing the dump? that would save you from potentially messing
with your data due to parsing problems.
A good idea, but it
Hi Everyone,
I'm trying to run a very simple query on two joined tables but it's taking a
long time to run.
I have two tables, users and sites, both of which have an email address field
that I'm querying.
here's my query:
SELECT *
FROM sites
INNER JOIN users ON sites.userid = users.ID
Dan-
I would concentrate on SQL certification first
To know package foo does bar method for MySQL is a good extra tool to have in
your toolbelt
but more important for the bigger companies to be able to use your skillset for
MySQL AND DB2 AND Oracle
Martin
My guess is that the OR is searching the whole table for each element of the
other table. It compounds the select statement.
You may try a Union.Im new to Mysql so im not sure it will work, but you
might try it out.
SELECT *
FROM sites
INNER JOIN users ON sites.userid = users.ID
WHERE sites.email
then: dump, import locally, rename and dump again. Still feels a bit
safer then parsing though it might be a bit more work.
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 1, 2009 at 9:42 PM, Robert D. Crawford
Robert,
I know you have had other answers, but as to the database name, yes, you can
remove the CREATE DATABASE statement and change the USE statement to the
right database name.
N.B. In our environment the students have only one database each, and will
install blogs and wiki's etc. using that
UNION all does a cartesian join ..maxiumum number of results will be delivered
SELECT *
FROM sites
INNER JOIN sites.userid = users.ID;
-- INNER JOIN users ON sites.userid = users.ID
--ALSO put (hopefully UNIQUE indexes) on sites.userid and users.id
Martin
13 matches
Mail list logo