#mysql
06 November 2007
Total 30 pages. You are browsing page 1/30.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Tue Nov 06 00:00:19 2007
--- Day changed Tue Nov 06 2007
00:00 <****> haha well adaptr whilst i know it's pretty messy i'm wondering if i'm okay with about 30 fields (about half varchar and the rest integers) with about 5000 rows for my table
00:00 <****> dkr: you're right ;-)
00:00 <****> for a decided machine that's not going to have any noticeable problems dealing with it right adaptr ?
00:00 <****> anathematic wouldn't that depends purely on the intended use of the data ?
00:00 <****> who knows if it's too little or too much
00:01 <****> "depends" is always my favorite answer. :)
00:01 <****> adaptr: i'd be using it in a web interface over just a network
00:01 <****> haha yeah
00:01 <****> if you mean dedicated, of course not - 5000 rows is nothing
00:01 <****> mmm i had another way of spreading all the fields across multiple tables
00:01 <****> when you're up to 5 million rows, come again
00:01 <****> however it was getting too difficult to interface it all
00:01 <****> nod, that's a tiny db
00:01 <****> yeah i just needed someone to confirm that with me ;)
00:01 <****> once you reach 50 million, you'll need to start thinking about optimisation some
00:01 <****> i'll go back through when i've got the time allowance and do it all perfectly i guess
00:02 <****> ahh ty adaptr
00:02 <****> being self taught (ie. no idea what i'm doing) at this stuff means i don't really have a good idea of mysql's limits
00:02 <****> anyone recommend a textbook or something to read up about this sort of stuff? ;)
00:02 <****> well, these limits are really to do with disk i/o system ram
00:02 <****> database design?
00:02 <****> or mysql?
00:02 <****> the theoretical limits are well-known; the practical limits are obviously decided by your hardware
00:03 <****> mysql it's self
00:03 <****> is it harder to deal with a 5GB file or a 50KB file? :)
00:03 <****> anathematic but you usually design a data structure to fit your application
00:03 <****> dkr when I put it on a DVD, it's all the same to me
00:03 <****> heh
00:03 <****> haha my database will get up to about 25 mb?
00:03 <****> anathematic: 5000 rows * average row length
00:03 <****> with everything else that is
00:04 <****> thank you all for your help! bye!
00:04 <****> i like richard barker's case*method book
00:04 <****> anathematic the question indicates that you have no clue why you are structuring your data the way you are - which in itself is worrying
00:04 <****> the one on ERM
00:05 <****> adaptr: i know why i'm doing it the way i am
00:05 <****> and i know it's probably not the neatest way to go about it
00:05 <****> anathematic then why do you say that you don't know why you are doing it the way you are doing it ?
00:05 <****> it's called a "contradiction"
00:05 <****> adaptr: trying to cover myself in case i say something stupid
00:05 <****> oh, you will
00:06 <****> it's no use trying to backpedal
00:06 <****> <3
00:06 <****> least i'm only dealing with small amounts of data anyway
00:06 <****> "my datuhbazz design izz teh bad" is not an excuse for it actually being bad
00:06 <****> if it sucks, it sucks - it's that simple
00:07 <****> Hi, is there a command to clone a table with a different name?
00:08 <****> xuser: not a single command but you can do it in two queries!
00:08 <****> adaptr: i know but i was just wondering if i'm going to really suffer with his database deisgn with such small numbers
00:08 <****> xuser: create table new_table LIKE old_table; insert into new_table ( select * from old_table);
00:09 <****> anathematic you have yet to *show* any database design
00:09 <****> so who knows
00:09 <****> ToeBee: thank you!
00:10 <****> adaptr: haha na after someone pointing out it's not really a big deal unless it's 5 million + records
00:10 <****> i don't really think this applies to me at all now
00:10 <****> anathematic if you like
00:10 <****> so as a result i got too lazy to paste it
00:10 <****> I can easily make a 30-table structure that brings a dual Xeon box to its knees with 500 records
00:10 <****> it all depends
00:11 <****> by indexing like every column and making them all longtexts?
00:11 <****> is there a way to let CONCAT treat a NULL argument as an empty string instead of returning NULL?
00:11 <****> hi everyone btw ;)
00:12 <****> bitflesh: IFNULL(`col`, '')
00:13 <****> uh nice idea...
00:15 <****> alter table table1 change col1 col1 varchar(11);
00:15 <****> !perror 150
00:15 <****> MySQL error: 150 = Foreign key constraint is incorrectly formed
00:16 <****> adaptr: how do i bring up my table structure in mysql console??
00:16 <****> describe tablename;
00:17 <****> several ways... show create table (tablename) is one; describe tablename is another
00:17 <****> or show create table tablename;
00:17 <****> each has advantages
00:17 <****> well golly I think there's an echo in here!
00:17 <****> the advantage of show create is that it's exact
00:17 <****> the advantage of describe is that it's a bit more legible
00:18 <****> I belive I need to remove all foreign keys which is on the given table name I want to change type of
00:18 <****> Hm.
00:18 <****> How can I find the foreign key name?
00:19 <****> well that was easy
00:19 <****> now to paste somewhere
00:20 <****> well that pastie didn't work out too well but anyway: http://pastie.caboo.se/114391
00:20 <****> with http://pastebin.com/d65ec8e33 : I get Invalid use of group function. Using google I cant find any problems that relate to mine to try and solve this, can anybody assist me?
00:21 <****> actually pastebin is better than pastie for this: http://pastebin.com/m2e132190
00:21 <****> what does skip-host-cache do?
00:26 <****> squidly: there's this thing called google..."Never use host name cache for faster name-ip resolution, but query DNS server on every connect instead."
00:27 <****> ki77a77: google didnt help with that
00:28 <****> squidly: append 'mysql' to you google queries
00:28 <****> your*
00:28 <****> ki77a77: I did
00:28 <****> I use google a lot. I would not ask with out doing a google search first
00:29 <****> http://www.google.com/search?hl=en&q=mysql+skip-host-cache&btnG=Google+Search
00:30 <****> squidly: but, whatever. Life is short. ;^)
00:31 <****> ki77a77: heh.. google ftl.. I had mysql and skip-host-cache as well. that didnt get me that return..
00:31 <****> oh wait I had mysqld
00:40 <****> hello all
00:41 <****> does anyone know how to disable reverse dns on MySQL 5.0
00:42 <****> Hi, I have a funny one. I changed the my.cnf of MySQL 5.0.46 on a CentOS box. When I set innodb_log_file_size=768M, all my MyISAM tables disappear.
00:42 <****> I have innodb_buffer_pool_size=5G
Total 30 pages. You are browsing page 1/30.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last