| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> or maybe I'm just being a n00b here...
<0> I don't get what's wrong here...
<0> anyone?
<1> hmm.
<2> wickers reseting root will eset roots privileges
<0> ok I'll do it again, and see if it changes.
<0> though I just reset it earlier today
<0> but here it goes
<0> ok, so I just reset it again.
<0> and I'm logged in
<0> Anyone willing to hold my hand here?
<0> I now want to create a new user, and database.
<0> (thanks in advance, you guys rock)
<3> !tell wickers about tutorials
<4> Alrighty.
<5> what setting can limit max database size?
<0> litheum: thanks
<0> ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'drants'
<6> Hi.. is see mysqld has srtart a lot of processes (via ps aux)... does it need all thos threads? can I decrease them to decrease RAM?
<0> THat's the error I'm getting
<6> ?
<2> Skramx no
<7> Xgc: lsmith: I have it! ;)
<7> --> http://www.linux-stats.org (last forum posts)
<7> Xgc: with the old mysql version. *g*
<8> i get MySQL NOT started (1) \n * ERROR mysql failed to start ,when I try to start mysql,anyone seen this before?
<9> how can i duplicate a row in mysql into the same table
<9> except for primary auto_increment key
<3> insert into table1 select col1, col2, col3, col4 from table1 where ... ?
<9> no thanks
<3> lol
<3> ok...
<9> i want to reduce error by not typing all fields but 1
<7> okay... have a good night... ;)
<7> bye
<10> Hi,
<10> I don't speak much englesh but i get a error when a go to create database for drupal
<10> mysqladmin -u root -p create drupal
<10> Enter p***word:
<10> mysqladmin: connect to server at 'localhost' failed
<10> error: 'Access denied for user 'root'@'localhost' (using p***word: YES)'
<10> this is the error eith mysqladmin. In the INstall.txt of the drupal said that i need exec " mysqladmin -u root -p create drupal
<10> AlejandroG Enter p***word:" i put my p***word
<11> is it bad to have a table with only one column, which is a fk to another tables pk
<12> it is utterly pointless
<11> not really
<11> or it may be
<12> totally
<12> it's a duplicated bunch of data from another table for no reason at all
<11> i have a table of tags (tag_id {pk}, description {uk}). now i have a table of TagsThatAreAllowedToAccessFoo(tag_id {pk})
<3> Leithal: could be useful if it is a table that will hold a very small percentage of the values of a larger table
<3> i.e. if there is a table with 100 million rows and 100 of them will satisfy some criterion
<11> litheum: i agree
<13> Hey. Someone told me that it's possible to roll back, using innodb, to a timestamp. Is this true?
<3> it would be more effective to create a separate table to store those values than use the space of adding an extra column to the original table
<12> hmm if you were to use it as some form of lookup then yea fine
<3> uru: no
<3> Leithal: :-P
<3> neprak: what is "Foo" in your example above?
<3> are there many tables like this?
<12> I was thinking column a duplicated entirely between table1 and table2
<14> neprak: That's different and not complete duplication. It's a valid relationship.
<3> that would indeed be asinine
<13> Okay, so what about logging? Is it possible to look through the queries p***ed through a machine, and determine who sent them, etc'?
<11> litheum: I'm giving all of my employees tags. Foo is tags that are allowed to have access to client info
<3> that will be gloriously easy in 5.1
<12> most fantastically
<12> Finally
<3> neprak: you should probably just have one table of this form and give it 2 columns... one would be the id of the persona nd the other is the id of the thing to which they are being permitted access
<13> how about in 4.1? T_T
<11> so.. tags with "tech" "admin" "chef" are allowed to have client access
<12> can still do it in 4.1 uru
<12> !m uru query log
<4> uru: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<13> Thanks.
<3> neprak: this is a system that's soemtimes referred to as "roles"
<3> it's quite common
<11> yeah
<12> or see if you can catch it in "SHOW FULL PROCESSLIST", query log is more complete though
<3> you should have a table with a list of roles
<3> and another table with a list of users
<3> and a table "in the middle" that ***ociates users and roles
<11> i have that
<3> gloriuos
<11> i just couldn't figure out how to plugin the access
<3> the only one of thesee tables that has 1 column is the list of roles
<14> neprak: Don't make this table specific to foo, however. You'll want a little better design to handle various access criteria/types. You might want the table to hold pairs of [tag, 'type'].
<11> thanks
<11> i need to think about this more
<6> HOW can i reduce the ram MYSQL uses?
<11> so, have an Access table and have [tag, 'admin'], [tag, 'client access']
<12> SkramX: Decrease the various buffers, key_buffer_size, innodb_buffer_pool_size, query_cache_size, tmp_table_size, thread_cache etc.
<3> neprak: your table with users/roles should be INT,TINYINT probably
<11> you're thinking there's not going to be a lot of roles?
<11> is taht why
<12> well you can get up to 255 in a TINYINT
<11> i guess that's a lot of roles
<11> for employees
<6> Leithal: what are good sizes for the buffers/
<12> neprak: Yes, unless you are a government agency. ;)
<12> SkramX: That depends on too many things
<6> Okay.. its a LOW power mysql server;
<11> haha
<12> SkramX: Your vagueness only invokes vague answers
<12> you should set them between 10mb and 16gb
<6> okay
<6> for new my.cnf settings to take place, i just need to restart mysql?.
<12> yep, although some you can change online as well
<11> man.. my access table goes from {access roleid} -> {employeeroletypes roleid} -> {employeerole roleid} -> {employee employeeid} -> {person personid}
<11> that's a lot
<11> thanks for the help, guys
<14> neprak: You seem confused. You said you have tags that require access to types. You called on type 'foo'. Just provide a list of those pairs to describe which tags have access to which types. It's one table.
<14> s/on type/one type/
<11> heh, i probably am confused. let me read what you wrote... hold up
<11> yeah, it is one type... i was just showing all of my fk traversals
<11> from that tabel
<11> table
<14> neprak: I don't know what a tag represents in your system, but that's not important.
<14> neprak: There could be 1000's of access pairs. That's fine.
<15> can i use LIMIT if my ids are not numeric?
<14> If you have 2000 tags and 100 types, you could have as many as 200,000 pairs.
<11> is that bad?
<14> neprak: Not at all.
<11> good.. i shouldn't have about 15 tags and 10 types
<11> but about
<13> Okay, so if you have a corrupted database, and a backup from the night before, and both are using innodb
<14> neprak: This is driven by requirements. If the requirement calls for 200,000 pairs, that's what you have. The question you should ask is ... is this access model appropriate for your business.
<13> Is it possible to roll forward a few hours?
<13> Given some data from the corrupted database.
<14> neprak: That's a tiny amount of data. Don't even worry about it. But... do question your access model to be sure it covers all your requirements.
<11> I believe it does. thanks, Xgc
<14> You're welcome.
<11> i can see where there's a problem, but i don't think it's critical as long as I document. initially, the access table will be empty. i just have to make sure that the EmployeeAccess***ignor.php ***igns the correct access type literal that will be stored for type in Access table
<16> How do I do field||field2 in mysql ? (the pgsql method is | |)
<16> select field (concat with) field2
<11> if that made any sense at all
<11> other wise the fooaccesshandler.asp won't know what to check for
<11> otherwise
<11> CarlH: are you talking about join?
<11> http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.shtml
<16> also, how do you say 'select * from table where field like '%blah%';
<11> i don't know. i'm still learning
<11> like that, i thought
<14> CarlH: concat(f1,f2,f3,...)
<17> is there a way to cache queries involving a query such as: "us_enddate >= date_sub(current_date(), interval 1 day)"?
<17> oh yikes, can't use sql_cache for prepared statements either
<17> my load average is 80 on live db server right now, :)
<17> it's not slow though, I suppose because al those threads are waiting on same tables
<17> hrm, now it's slow, outta ram, :)
<17> 80 threads "copying to tmp table" and the same query(a big multitable join)
<17> and usnig a tmp table is listed as another erason you can't use sql_cache, sigh
Return to
#mysql
or
Go to some related
logs:
gigabyte rt2500 suse
#linuxhelp
donwload perl
ubuntu boot codes
mesa /bin/sh: line 0: cd: i830
msttcorefonts connection timed out ubuntu
#perl
#math
#fedora
ubuntu You do not have permissions to write to this folder
|
|