Hi, all. I'm a long-time MySQL user who's only recently had to start
learning some administrative stuff, largely because I finally have a
decently-sized database. My database is about 100 GB; I'm using it -- via
dbmail (www.dbmail.org) -- as a mail server for my company. While dbmail
is well-and
wever, making the index might take a serious bit of time.
>
> Please let us all know how it does or does not work.
>
>
> Tim...
>
>
> -Original Message-
> From: Ken D'Ambrosio [mailto:k...@jots.org]
> Sent: Wednesday, June 24, 2009 11:07 AM
> To: mysql@li
Hey, all. I'm trying to "get" indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been RTFM'ing, but
haven't found anything that really laid it out in black and white;
usually, they'd g
Uhhh... wow. Unless I'm very, very, very mistaken, I think you're missing
something pretty obvious: I believe you can simply
a) shut down the database
b) mv the directory to a different directory name.
*DONE* Your database now has a different name. Boy, that 30 seconds of
hard labor was sure fa
eeded it, either.
Agreed.
Thanks much!
-Ken
> On Fri, Dec 11, 2009 at 7:04 AM, Ken D'Ambrosio wrote:
>
>
>> Uhhh... wow. Unless I'm very, very, very mistaken, I think you're
>> missing something pretty obvious: I believe you can simply a) shut down
>
Hey, all. I've been using databases clear back to xBase days; that being
said, I've never had a solid foundation for relational databases. While I
can muddle by in SQL, I really don't have a good understanding of exactly
how keys are set up, the underpinnings of indexing, and, oh, lots of
ground-
I've got a fairly large -- 100+ GB -- MySQL database. It isn't accessed
often -- it's acting more as an archive right now than anything else.
That being said, when it does get accessed, the indeces seem to take
forever to load. Being as I just bumped the RAM from 2 GB to 6 GB, what,
generically,
Can someone help explain something to me? When I use "mysql" to connect
to my server, it can take upwards of 15 seconds. When I use any of the
Ruby scripts I've written, it's so fast it's not even obvious it's
querying a remote host. Any idea what might cause this disparity? (My
initial sus
Basically, it says that MySQL is not responding to queries. So it likely has
died, or perhaps is mis-configured.
On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote:
>Hi,I am using Moodle which itself uses SQL for the database. Problem is
>that, when I run the email plugin and execute the command,