#mysql
09 November 2007
Total 27 pages. You are browsing page 4/27.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:36 <****> 8 bits?
02:37 <****> if your OS has one byte=0-255, sure...
02:37 <****> my bytes are a little bigger, whether big- or little-endian
02:37 <****> 1 byte is always 8 bit
02:37 <****> 1 word can be different
02:38 <****> 1 char can also be different, depends to charset
02:38 <****> 1 word can be different, depends to architecture of the cpu
02:39 <****> uhhhh alphanumeric? =P
02:39 <****> LOL, also a matter of definition, see http://en.wikipedia.org/wiki/Byte
02:40 <****> personally I'll take my words consisting of 10 six-bit bytes, tonight
02:41 <****> kimseong, I think "byte" has historically been used for any data unit that's treated as atomic on a very low level.
02:41 <****> i thought that refers to word nowadays
02:41 <****> People just settled on 8 bits because 7 is the minimum to fit a single Latin character with room for numbers/punctuation, and 8 is preferred as a power of two to keep things neat.
02:42 <****> Words are bigger than bytes, generally. In Intel assembly a word is fixed to mean two bytes.
02:42 <****> But it can more generally be used to mean "the addressing size" or related.
02:42 <****> genenerally the minimum transfer unit definition seems popular, so that you see 64 bits referred to as a 'byte' in the IA54 docs,
02:43 <****> IA64
02:43 <****> since that's what is getting transferred at a time
02:43 <****> Really? Interesting.
02:43 <****> but it is purely conventional, so to speak
02:43 <****> Of course in IA64 you might not have data units smaller than 64 bits at all.
02:44 <****> That would be a bit strange, honestly.
02:44 <****> you do and you don't :), but you are going to pay at least that for everything unless you are very careful
02:45 <****> and gosh, I can't remember how to fold my loops for that architecture....
02:45 <****> Of course IA64 was a semi-flop, at least compared to expectations.
02:45 <****> /j #php
02:45 <****> x86 seems to have way too much momentum behind it to be unseated by little things like blatantly superior design principles.
02:46 <****> never hurts that Intel PAYS developers to write loops that perform faster on x*^
02:46 <****> x86, shifted that
02:47 <****> IA64 would have take over x86 if not for the introduction of amd64 and em64t
02:48 <****> IA64 was never meant to take over x86. It was meant for high-end computing.
02:48 <****> But if you mean, it would have taken over x86 if AMD didn't exist and Intel wanted it to, yeah, it would've. :P
02:54 <****> well, Intel sure would have liked it that way
02:57 <****> Thankfully we have the wonders of competition, and so Core 2 instead of IA64 and P4.
02:59 <****> I need a shell script to load data into mysql. I have one that works. Now I need to replace the infile name with a script variable. any helpers?? I have a line of code to send.
03:00 <****> hi
03:00 <****> how can i select fields that are NULL in a where ? ' WHERE id = null ' does not work =(
03:00 <****> WHERE id IS null
03:00 <****> Tommy3: $var ?
03:00 <****> null
03:01 <****> WHERE id IS null does work =)
03:01 <****> ty
03:01 <****> yes "is null" works
03:01 <****> you can't use = on null because null doesn't "equal" anything" :)
03:01 <****> null doesn't even equal null!
03:02 <****> kimseong: I have a script variable (linux script) named $FILE that id defined like this: FILE=`date +"/home/tom/Desktop/daily_stocks/S%m%d%y.CSV"`
03:02 <****> Tommy3: whats the problem?
03:03 <****> kimseong: I need that $FILE variable to replace a hard coded file name in my load in the script. The current load looks like this: load data low_priority infile '/home/tom/Desktop/daily/X110607.CSV' into table tsthist
03:04 <****> Tommy3: doesn't it work?
03:04 <****> Tommy3: you can try using mysqlimport
03:05 <****> Tommy3: where exactly is your load data infile? in the shell script or another sql script
03:05 <****> kimseong: (there is obviously more to the load. I just left it off to save space here. Yes, the load works as it is currently written, but what I want it to do is create the file name based on the date every nite. That is why I am trying to use the $FILE=
03:06 <****> Tommy3: how do you execute the load? with mysql -e or a separate sql script file
03:07 <****> Tommy3: shell script does not execute the load data since load data is sql statement
03:07 <****> kimseong: I have a batch file that I run that picks up the load. It looks like this: mysql < /home/tom/Desktop/load_mysql.scr
03:07 <****> !m Tommy3 mysqlimport
03:07 <****> Tommy3: (The mysqlimport Data Import Program) : http://dev.mysql.com/doc/mysql/en/mysqlimport.html
03:08 <****> Tommy3: so the filename is in the scr file, not in your shell script, the shell variables only valid in the shell script, not in the scr file
03:09 <****> Tommy3: if you file only has load data infile, try mysqlimport utility
03:10 <****> kimseong: well, I define the $FILE in the beginning of the batch file and was hoping that it would resolve in the load script but it didnt like it. I will go look at the website that someone sent and also go look at mysqlimport utility. Thanks
03:23 <****> Hi. Is there a way to search an entire table without doing an OR for each column?
03:24 <****> Like doing something like this: SELECT * FROM peeps WHERE EVERYCOLUMN = 'bob'
03:39 <****> ricosecada no
03:39 <****> Should a DB repolication replicate table changes?
03:40 <****> yes
03:40 <****> I;ve setup replication according to the manual, but changes dont appear to propogate.
03:40 <****> Predom[Ubiquitou, you mean like ALTER TABLE? I believe it's a config option. But I don't use replication, so I'm not personally familiar with this.
03:40 <****> I was wonderinf if someone could assist me.
03:40 <****> In debugging it... that is.
03:40 <****> Predom[Ubiquitou does show slave status show yes for i/o and sql threads?
03:41 <****> Errr.
03:41 <****> No.
03:42 <****> start slave;
03:42 <****> check again..
03:42 <****> .Now says Yes/
03:43 <****> check the error log
03:44 <****> checking
03:44 <****> hello for updating a timestamp you can use the trigger ON UPDATE CURRENT_TIMESTAMP which is perfect for a modified column, but is there one you can use for a created column kind of like ON INSERT CURRENT_TIMESTAMP that you can use ?
03:45 <****> Hmm
03:45 <****> How can I ensure slave starts on boot?
03:47 <****> Hi, what do I have to do to competely disable logging?
03:47 <****> or at least make so that only a few hundred megs of logs are kept
03:49 <****> phuzion: Configure a log rotation
03:50 <****> Ok, how is that done?
03:50 <****> phuzion: what logs are you talking about?
03:50 <****> /var/log/mysql
03:50 <****> if it is binary logs you can turn them off or tell them to automatically purge after x days
03:54 <****> http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
03:54 <****> when mysqld is running in the background, is it common for it to run your processor at full tilt?
03:55 <****> if you issue a query that requires a lot of computations...
03:55 <****> err
03:55 <****> A lot of cycles.
03:55 <****> YEah
03:56 <****> but he left :/
03:56 <****> Oh.
03:56 <****> Use the force.
03:56 <****> whoops, got disconnected
03:56 <****> Verizon for you...
03:56 <****> if you issue a query that requires a lot of computations...
03:56 <****> is it common for mysqld to kick processor usage up to 100%
Total 27 pages. You are browsing page 4/27.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last