#mysql
29 September 2007
Total 14 pages. You are browsing page 4/14.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:33 <****> wrench--: phpmyadmin?
03:35 <****> sub_: because some of my systems can't hold as much ram as my databases use and its gets very expensive if i have 3 nodes and have to have 10gb of ram in each node
03:36 <****> you need 30GB of ram!?!!?!
03:37 <****> If you have tables that large then I don't think you want to NOT have anything in RAM, as it'd have to read it from the disk each time :|
03:37 <****> 640k should be all you need
03:38 <****> anyways, there are ALOT of different variables that tune the amount of "x" in memory
03:38 <****> I'll try to find a decent resource for you, one sec
03:39 <****> http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html
03:39 <****> You might be able to find what you are looking for there
03:42 <****> sub_: i have a database thats 7gb right now and it reads just fine on disk
03:45 <****> sub_: i found a table like that which had the default values and what the mins and maxs were of values that can be set for ndbd stuff but i'm having trouble finding it now... do you know where it is? o_0
04:12 <****> who use phpmyadmin????
04:24 <****> test
05:02 <****> if I need to replace certain characters in certain rows of a certain column, how do I do this?
05:12 <****> I recently installed mysql, and have been playing with it. Now I'm trying to gain access to it remotely. I don't see it in netstat -a, and the only thing I can find on Google says to comment out the skip-networking directive, which showed as not being commented when I looked.
05:12 <****> remote
05:12 <****> remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline
05:13 <****> Thanks. I didn't find anything about the bind-address part, though I did (on a whim) try setting that to the actual address.
05:16 <****> ToeBee: Any other standout reasons it would continue saying my username/password were incorrect, even though they work locally?
05:18 <****> mysql has its own user/host access control. Your user probably only has permissions to connect from localhost
05:18 <****> note the "and grant permissions to the external 'user'@'host'" in the_wench's reply
05:18 <****> I did the grant all on db.* to 'user'@'host'
05:20 <****> And netstat does briefly show a connection from that host.
05:21 <****> what did you put in as 'host'?
05:21 <****> fis-nb-xp-01
05:21 <****> The name of the laptop I'm trying to connect from.
05:22 <****> should probably use IP address. Using name would require reverse dns lookup to be correct
05:23 <****> Ok. I was just trying to avoid having to use both the wireless and wired addresses this laptop gets. I'll give it a shot.
05:24 <****> Same error.
05:25 <****> And it shows up in netstat again as TIME_WAIT
05:27 <****> ToeBee: Nevermind. It appears to be a problem with the laptop. I just tried from another Linux box, and it works fine.
05:27 <****> I hate Windows more every day.
05:27 <****> indeed
05:30 <****> sup
05:37 <****> is there a way to copy a user and the permissions from 1 box to another?
05:37 <****> for only a specific user?
05:56 <****> Assid: do a show "grants for 'user'@'host' " query and then execute those grants on server #2
05:57 <****> will that show me the usernames as well?
05:57 <****> i mean the password
06:04 <****> does anyone here know if there is an easy command line way to import a csv into mysql?
06:09 <****> !m Gumby load data
06:09 <****> Gumby see http://dev.mysql.com/doc/refman/5.0/en/load-data.html
06:10 <****> ToeBee, thanks, I will have a look
06:27 <****> hey guys, I have 3 columns I want to add to my many-to-many relationship ... is that ok? I have a user who provides several services in different states essentially. and I believe it's many-to-many, with 3 ids
07:04 <****> quiet here
07:07 <****> TOO quiet...
07:09 <****> how can i set "mysql" server so that i could accept connections remotely
07:15 <****> first of all your server should listen on 3306 port
07:15 <****> I think by default it open from outside
07:16 <****> !tell rrrobert about remote
07:16 <****> rrrobert remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline
07:17 <****> rrrobert: remove those lines from the config if they exist and restart the mysqld process
07:17 <****> ToeBee: what are you doing????
07:29 <****> should I be cautious of JOIN overhead...if I can avoid it (whilst modeling) should I?
07:29 <****> sandrot: should test to see what works best for you, likely
07:30 <****> what's the alternative to a join? denormalization? some subquery?
07:30 <****> test as in benchmark?
07:30 <****> denormalization
07:30 <****> denormalization of course has other drawbacks
07:30 <****> so there's definitely a tradeoff there that you should consider in the context of what you're doing
07:31 <****> great input, thanks
07:31 <****> there's sure as heck no universal answer to your question
07:31 <****> yeah especially as vague as it is
07:31 <****> vague?
07:31 <****> my question...
07:32 <****> actually just thinking of extending the User model that comes packaged in django. The 'best' way of extending it is actually creating a foreign key to a new table =(
07:32 <****> what's wrong with that?
07:33 <****> if I made my own user model I wouldn't need an extra JOIN for the few extra values I need to add
07:35 <****> if you are just adding details to the user why not alter the existing schema instead of adding to it
07:35 <****> hello...
07:35 <****> i´m just a beginner, i have two doubts:
07:35 <****> two doubts
07:35 <****> i have 2 tables:
07:35 <****> doubt #1.
07:36 <****> table_type
07:36 <****> id int(2) UNSIGNED NOT NULL,
07:36 <****> name varchar(15) NOT NULL
07:36 <****> PRIMARY KEY (id),
07:36 <****> UNIQUE KEY (name)
07:36 <****> (2) is really necesary ?? what for ??
07:36 <****> UNSIGNED is really necesary ?? what for ??
07:36 <****> genius551v: Use a pastebin.
07:36 <****> sorry, can you tell me wich one?
07:37 <****> genius551v: Pick one. rafb.net/paste is fine, if you can't find one.
07:38 <****> ok tnks
07:39 <****> seems like two questions easily answered by google
07:39 <****> i have 2 tables:
07:39 <****> http://rafb.net/p/bVp4uR32.html
07:40 <****> doubt #1. (table_type)
07:40 <****> (2) is really necesary ?? what for ??
07:40 <****> UNSIGNED is really necesary ?? what for ??
07:40 <****> genius551v: There's no need to repeat yourself.
07:41 <****> sorry again...:-(
07:41 <****> 0. The unsigned part tells MySQL this.
07:42 <****> genius551v: Both answers are no. These things are driven by your requirements only. If you want to use a signed type, even though you have no need for negative numbers, no one will argue with you.
07:42 <****> ok, my doubt is is really necesary especific in the code? or i can forget it?
07:43 <****> genius551v: I just answered you. The answer is no. It's not necessary, unless you require it.
07:43 <****> ok but in the yield ??
07:43 <****> hmmm
07:44 <****> genius551v: The who?
Total 14 pages. You are browsing page 4/14.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last