Indexing? (Warning: relative newbie.)

2009-06-24 Thread Ken D'Ambrosio
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

RE: Indexing? (Warning: relative newbie.)

2009-06-26 Thread Ken D'Ambrosio
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

Intro to indexing?

2009-07-27 Thread Ken D'Ambrosio
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

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-10 Thread Ken D'Ambrosio
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

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-11 Thread Ken D'Ambrosio
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 >

Database fundamentals: wanna learn.

2009-12-28 Thread Ken D'Ambrosio
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-

Help optimizing settings?

2010-02-05 Thread Ken D'Ambrosio
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,

Long time for client to connect; not for script.

2014-11-10 Thread Ken D'Ambrosio
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

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
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,