#mysql
02 November 2007
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:08 <****> hmmm ill have todo some research
02:08 <****> _k_, why not?
02:08 <****> Simetrical: InnoDB is constantly moving data from the logfile to the data file. A READ LOCK won't stop that.
02:10 <****> jbalint?
02:11 <****> deadroot: yo
02:11 <****> _k_, hmm, interesting. You have to shut down the server to stop that, or is there some other way?
02:12 <****> hi _k_
02:12 <****> pm?
02:12 <****> Simetrical: Filesystem snapshots will work without a downtime.
02:12 <****> Simetrical: And mysqldump --single-transaction will work without a downtime
02:13 <****> Simetrical: And InnoDB Hot Backup will work without a downtime, it's a commercial tool tho
02:13 <****> Simetrical: And using Replication will work without a downtime on the master.
02:13 <****> Simetrical: Enough choices? :)
02:14 <****> _k_, right, I knew all those. I was wondering about some cp-based method. I take it the answer in that case is "shut down the server".
02:14 <****> Simetrical: Yes, just locking the tables will not be enough.
02:14 <****> And it would block write queries anyway.
02:15 <****> _k_, but as for the filesystem snapshot, a consistent filesystem snapshot will end up being a consistent DB snapshot too with InnoDB, right? That is, it will be able to roll back or finish all pending queries and so on?
02:16 <****> (Blocking write queries is okay for me, the copy is fast enough that it's just 40-50 seconds downtime. That registers as a page takes a while to load if you happen to try at the exact minute of the backup, no big deal.)
02:16 <****> Simetrical: A filesystem snapshot will represent a crashed InnoDB file space. But InnoDB does crash recovery on restart. All committed transactions are saved.
02:16 <****> Right, that's what I thought, but you made it clear that my knowledge of InnoDB internals is lacking. :)
02:17 <****> Simetrical: It's like a journaled filesystem. The logfiles will capture completed transactions, the data files will be filled with them later
02:31 <****> Can someone tell me, when writing a program that uses threads and the main part of the program uses a MySQL connection as well as the threaded parts of the code using thier own MySQL connections, does the main part of the code (not the threaded code) need to be written using mutexes as you would the threaded part of the code? Follow what I am asking?
02:36 <****> How do I import stuff, ignoring duplicates?
02:38 <****> jsoftw, add a UNIQUE index and use IGNORE on the inserts?
03:06 <****> what would be the best way to get all items from a certain week ending
03:07 <****> select * from something where something_else = therightvalue
03:07 <****> a week ending is more complex then a simple select as you ahve to get a range
03:07 <****> orly?
03:07 <****>= something_a and something_else <= something_b;
03:08 <****> that wont work because its not a condition like
03:08 <****> its basically you select a date and get all items for that week
03:08 <****> Oh well blah.
03:09 <****> If its an epoc time it would work sweet.
03:16 <****> morning.
03:16 <****> where is mysql log normall store at?
03:17 <****> check my.cnf
03:17 <****> most logs tend to be in /var/log/ though
03:18 <****> i remenber the log is somewhere near the mysql directory
03:20 <****> ello guys
03:20 <****> I'm having a weird problem
03:20 <****> trying to create a full text index
03:20 <****> but it isn't working
03:20 <****> Column **** cannot be part of FULLTEXT index
03:20 <****> | **** | text | YES | | NULL | |
03:20 <****> shouldn't this be able to be in the index?
03:21 <****> is it a myisam or innodb table?
03:22 <****> myisam
03:23 <****> only thing I see is that you can't do fulltext on a ucs2 character set column...
03:24 <****> well
03:24 <****> I had created another full text index with it
03:24 <****> but I dropped it
03:24 <****> ERROR 1283 (HY000): Column.......
03:33 <****> how many columns can be in a full text index?
03:34 <****> I'm looking for a good interface for administering my mysql database on linux. I'm thinking along the lines of something like HeidiSQL, but for linux. what do you recommend?
03:36 <****> mysql -u foobar
03:36 <****> :D
03:36 <****> demio: lol true
03:37 <****> demio: but I like a gui which can display all the rows at once and let me edit them quickly, and that kind of thing
03:38 <****> argh
03:38 <****> wtf
03:38 <****> why can't I add more than 2 columns to a full text
03:40 <****> I'm having this problem exactly
03:40 <****> http://forums.mysql.com/read.php?107,70219,70219
03:42 <****> demio: according to a comment on http://dev.mysql.com/doc/refman/4.1/en/create-index.html 16 fields are allowed - but i guess that's not what you wanted to hear
03:43 <****> the column limit doesn't appear to be listed anywhere in the official documentation
03:58 <****> if i were to do something like this. is mysql smart enough to only perform the date_sub operation once? delete from views where date_viewed < date_sub(now(), interval 1 hour)
03:59 <****> WHERE date_viewed < NOW() - INTERVAL 1 HOUR
04:00 <****> chadmaynard, i'm assuming that's equivelant to my query...but does it only do it once?
04:00 <****> should be once since it is a constant value
04:01 <****> section31: are you referring to the NOW() part?
04:01 <****> yes
04:01 <****> the subtraction
04:01 <****> and then it can take advantage of the index if date_viewed is indexed
04:01 <****> right
04:14 <****> how do I update "tariff" to 1 for all of my records if update 'mya2billing' . 'cc_card' set 'tariff' = '1' where 'id' = '1' works
04:14 <****> in mysql
04:15 <****> shido6: Wouldn't removing the WHERE clause do it?
04:16 <****> hrmm
04:16 <****> ie. update 'mya2billing' . 'cc_card' set 'tariff' = '1'
04:17 <****> Or have I gone mad? :-)
04:17 <****> dacm: Not mad.
04:17 <****> dacm: But remove the single qutoes on the field name.
04:17 <****> dacm: and the table name.
04:17 <****> and the db name
04:17 <****> Xgc: Oh yes, sorry I didn't spot that.
04:18 <****> dacm: all those names. :)
04:18 <****> shido6: `mya2billing` . `cc_card` set `tariff` = '1'
04:18 <****> Anyway.
04:18 <****> s/`//g
04:19 <****> update `mya2billing` . `cc_card` set `tariff` = '1'; ?
04:19 <****> shido6: That'll work.
04:19 <****> no worky :(
04:20 <****> shido6: Error?
04:20 <****> guys, if i try remove a frm file in mysql and it complain about the file readonly.
04:20 <****> wat can be the cause? i try chmod and rm but still gettting the same problem
04:20 <****> wjat
04:21 <****> what?
04:21 <****> i check showprocesslist and the table are not being used
04:21 <****> why are you remove the frm file
04:21 <****> drop the table if you dont want it
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last