Re: ENUM() vs TINYINT

I'm sure your enum is a fine option, but 0,1,2,3,4 would do the same thing. And you could add a comment to the table to describe it if desired. On Mon, Sep 21, 2015 at 8:03 AM, Richard Reina wrote: > I have a column name quarter which I need to have 5 possible inputs; 1,

Waiting for table metadata lock

InnoDB question So I have a rename table command that sometimes locks up with the waiting message. We have tried a few things, and nothing has worked well yet. So I was wondering is their a method in reducing the time this lock last for? Can I change any MySQL settings, increase space, get faster

Re: the best way compare String

For the best chance to have a efficient query you would need to loose the leading % if possible. If you could then the query can optimize using a index. On Sun, Dec 4, 2011 at 2:50 PM, Reindl Harald h.rei...@thelounge.netwrote: you THINK the engine is? WTF? fulltext if you need

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

Maybe this is the wrong place to ask, but why would you want to do this? Mysql has binaries for Windows, just use one of them? On Fri, Nov 18, 2011 at 4:16 PM, Franck Houssen f...@hotmail.com wrote: Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows

Re: Cleaning up old files

If you search on mysql-bin.01 you get a lot of good info. o They are mysql log files it contains all the queries u can view these files with the command mysqlbinlog just man it for more details o These are your binary log files.. you might not want to switch them off depending on your setup -

Re: How to select the id of 2+ records for given user?

For me given the sample data the following worked. The inner select says find all first messages, the outer says give me all messages that are thus not first messages. select * from table1 where messageID NOT IN ( select messageID from table1 group by userID ) Some times just playing with the

Re: Inefficient query is melting my server!!

Can you rotate that table daily, thus keeping it small? You can then move yesterdays data somewhere for post processing. try an insert if it fails generate the new table from the template, done. Thus no checking other then once a day when the insert fails. On Wed, Oct 19, 2011 at 2:54 PM, Johan

Re: [setting value when INSERT for auto increment]

since your listing the columns, you could just leave off `idlog` from the named columns and thus not also need to include the null in the inserted values. INSERT INTO `friendlyCMS`.`log` (`imepriimek`, `clock`, `action`, `onfile`, `filesize`) VALUES ($_COOKIE['user'], CURRENT_TIMESTAMP,

MySql - crashes daily

Any help greatly appreciated. Our mysql is restarting a LOT! Here is what is in the log, it doesn't seem to give much help. --start of log-- InnoDB: Warning: a long semaphore wait: 101203 15:12:40 - mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary

Re: Hard? query to with group order by group head's name

On Thu, Jul 16, 2009 at 1:20 AM, Elim PDTe...@pdtnetworks.net wrote: My table group_member looks like this: +---+---+-+ | member_id | name | head_id | +---+---+-+ | 1 | Elim | NULL | | 2 | Ann | 1 | | 3 | David | NULL | | 4 | John | 3 | | 5 | Jane | 3 |

using mysqld_multi - reboot only session 1 starts.

We are using mysqld_multi to start three instances, the command /usr/ bin/mysqld_multi --config-file=/etc/my.cnf start 1-3 works just fine. But when I tried to put that in rc.local only 3306 would start. Ok fine. So I created 3 scripts that I put in /etc/init.d called mysqld1, 2, and 3.