| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> shabbs, !!
<0> ~~
<0> that worked.....half
<1> Is it convention for every mysql table to have a primary key? There are some instances where I want to allow for duplicate rows using the identifying key...
<2> how should i use the mysql c library? create connection at start of the program and close on exit or create and close when it's needed?
<3> Then is it an identifying key ghostrunner?
<4> What do you guys use for benchmarking?
<5> ghostrunner: It is convention for every table to have a primary key, regardless of RDBMS.
<5> khaladan: There is slightly more overhead for text but there's not much difference ultimately
<1> therion: Thanks. I'll keep using primary keys on all my tables then.
<0> TobiasFar, i create at start , stop at end
<2> orogor_, okay...thx
<0> i way this i say nothing
<0> i can t even access my databases rightnow
<6> question: do others recommend that database applications with a "user" table, with a field "email" .. to have a requirement which says users records must have a unique email address?
<0> depends on you policy
<0> like what do you think a user is and so on
<6> orogor_, hmm, well originaly eache user was a different human w/ unique information ... now mgmt wants to allow for a 'manager' which can register lots of users ... and in thecase of email address being unique (currently) a war seems to be brewing :\
<7> does mysql not have "greater than or equal to" operator, ie >= ?
<8> morning
<7> ie... I do a select statement where I limit it to >= 2.8 on a field, and get no results
<6> i just think it's a bad idea (longterm, in my case) to allow multiple users with the same email addresses
<7> however if I do, say, >= 1.4, i get results that are 2.8
<0> might be
<9> ok i just changed my 4 million row table to use varchar(1024) instead of varchar(256) :(
<0> ~~
<9> mysqld is thinking about that
<6> lol
<7> however i tried to change it to (tech_hw.cpuspeed > 2.8 OR tech_hw.cpuspeed = 2.8) and I get no results as well, even though there are rows that have tech_hw.cpuspeed equal to 2.8
<0> humm if the user p***wordin the mysql table is empty, it means the paswordis blank?
<7> odd. okay, i see that mysql DOES support >=.
<9> yay mysqld decided that was OK!
<7> gragh. -_-
<4> Is there any way to tell how alrge InnoDB indexes are?
<4> Ballpark figures, even.
<9> high fives all around!
<7> khaladan: yay =3
<6> does anyone know of a link which justifies email addresses in db should be unique
<9> wut.
<10> kracker, It's up to you and your company.
<0> kracker, you wont find, it spersonal choice
<9> its a LAW of the UNIVERSE
<6> alright
<4> Is there any way to replicate queries from, say, one live server, to a second testing server?
<7> Hmm... why would a query that limits to, say, >= 2.8 for a given field, not return results from rows with that field equal to 2.8?
<4> This testing server should never return results - it would just use the queries so that I could test them.
<10> Huh?
<11> dan__t blackhole
<4> oooh
<4> but I want to run it against a copy of the live database
<4> I want to fsck with real values, etc etc.
<10> fsck? You shouldn't run filesystem utilities on MySQL files.
<4> *sigh*
<7> use a login that doesn't have write permissions?
<7> iono.
<4> Just wondering at this pioint how to get the queries to go to the live server and to the test server at the same time.
<10> pnookster, It probably does but your query is wrong.
<10> dan__t, Why?
<4> So I can test load under real-world circumstances on this testing machine.
<4> joo know?
<10> joo?
<4> (you)
<4> Have you no flavor, will?
<7> Will: can ya take a look at it? http://www2.waketech.edu/~its/lab_search.php
<10> Ask Therion. He's the only one I let lick me.
<4> :/
<10> pnookster, Why?
<4> So yeah guess I can't do this.
<4> Bummer.
<7> .... to help? Or, not. You know. Since I thought this was a general help channel for mysql.
<10> I don't visit weird web sites!
<7> Alright then, I'll post the queries to pastebin. Thought it would be more helpful to see them under real circumstances
<10> You are more than welcomed to explain your situation here. And use our pastebin to paste large amounts of text.
<12> Hello
<4> Time to hit the lists...
<12> I upgraded from mysql 4.0 to 5.0 and mysql is not creating multiple threads like it used to
<12> What might cause that?
<7> http://pastebin.com/735527 there ya go.
<7> (sorry, i never thought a college dev server would be considered a 'strange' site
<10> pnookster, Column type of cpuspeed?
<7> float.
<10> Don't use float.
<10> Use DECIMAL
<7> aahh.
<10> Or read how float works :)
<7> my php cl*** was incomplete then =o never explained to us the limitations of float. Thought it would work just like int
<13> hello people, anybody here can say me how can I see the date and hour of the last insertion in a mysql db?
<14> i know you can find the last update time
<14> you could easily find it if you have like an insertDate col or such
<13> Jy yes
<13> but I think in a general mode. something like, the last insertion in a mysql, independent of database
<15> hi, is there some way to make a update notification for a table in mysql .. like mssql ?
<7> Hmm. Changed it to DECIMAL and it still doesn't work. :/
<7> also, online documentation does not note that FLOAT does not work with greater than or equal to, or that it works any different than any other numerical data type.
<12> I upgraded from mysql 4.0 to 5.0 and mysql is not creating multiple threads like it used to
<12> What might cause that?
<16> it's creating multiple threads, your version of ps just isn'ts howing them all to you
<16> try ps -elF
<14> are you using mysql-max?
<10> ELF!
<16> yup.
<12> Jy: I compile from source.
<16> did you try my suggestion?
<12> ps -elF only shows one thread
<12> yep
<16> oh
<16> i lose
<16> :~(
<7> will[werk]: thanks for the help, btw - it had nothing to do with the data type. have a good day =D
<12> gleam: I wish you would of won
<16> what os is this braden?
<12> It would of made it so I wouldn't have to fix anything
<12> linux
<16> why'd you built it yourself? :)
<16> build, rather
<12> gleam_: I have no practical reason for it, I always just like building from source. I get a neurotic pleasure from seeing all the make stuff scroll across the screen.
<16> gotcha
<16> right, anyway, lunch
<16> good luck
<16> are you able to connect to the server btw?
<12> yep
<12> It is just slow when doing large queries
<16> then i think it's something related to ps output
<12> hmm
<12> I hope you are right
<17> anyone used a large mysql db in a raid environment? I'm wondering if there is a better configuration I could use. using 4 disk raid10 w/ ext3 now. About to rebuild and add 2 more disks for I/O.
<16> oh damit braden
<16> it's eLf
<16> not elF
<16> my mistake
<12> a ha!
<12> There they all are
<12> Excellent
<12> =)
<12> Thank you sir
<16> the threads are LWPs
<10> scooby2, That's what I would do, RAID10.
<16> and ps has a habit of hiding LWPs
<16> raid 10 for the win
<17> 6 drive raid10
<17> what file system?
<10> Make sure it's not RAID01
<10> I use reiserfs.
<16> you might want to tune xfs vs ext3 vs reiser vs jfs
<16> i like xfs
<17> i think it is actually raid0/1
<10> scooby2, That's different.
Return to
#mysql
or
Go to some related
logs:
#suse
css rounded box b1
realtek rtl8239 drivers
82573 debian
ferronica
system-font in gtkrc
#perl
#linux
unbuntu Default root password
kentaur porn
|
|