| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Time: 1460
<0> State: rename result table
<0> Info: ALTER TABLE `acalog_custom_field_value` ADD INDEX(`item_oid`)
<1> Davey, I suspect something else is the problem
<0> sjrussel, its completely indispenable data - so eh.
<1> do you have any disk space left?
<1> and, is the machine thrashing?
<0> 146GB
<0> yes, load average is like 2.5-3
<0> but its mysql causing it all
<1> 'rename result table' sounds like it's done
<1> !m sjrussel show full processlist
<2> sjrussel: Nothing found
<1> !m sjrussel show syntax
<2> sjrussel: (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<0> I couldn't tell you, can't pull up that info.
<0> **** it
<1> ". Most of the other State values are useful only for finding bugs in the server. "
<1> this is one of the 'other State values'
<0> OK, I just restarted the server and CHECK TABLE comes back clean
<1> I think the thread must have been blocked out by another that was running
<1> if you build it again, do you see the same behaviour?
<3> darien: still there?
<4> is it bad to have too many tables in a db
<5> Narada: no
<5> nelius: yes
<4> but it is bad to have too many tables open in a db right?
<3> can i add a subquery in the ON() statement? i need somsting like ... ON (acl.acl_location IN (4,5,6))
<3> and the (4,5,6) needs to come out of a subquery
<4> heh i'm working with acl tables as well or at least will be soon
<6> has anyone experianced error 127 or error 134 from storage engine?
<3> but i cant write ... ON (acl.acl_location IN (Select ...))
<4> yeah you can have a subquery to fill the IN
<4> i'm sure i've done that before
<7> tenEighty: Sure, you need to repair the tables that caused the error.
<3> Narada: any idea how?
<6> mendel: is there a permanent fix is what i mean? the error continues to arise.
<8> Can I return multiple count values that relate to specific where clauses?
<7> tenEighty: MySQL doesn't crash tables by design. The permanent fix is to determine what's causing it on your system and stop that from happening.
<7> Have you already repaired the table?
<6> mendel: yeah
<6> mendel: when you say "determine what's causing it" do you mean that it could lie in my SQL code, or actually a problem with the server or both?
<4> nelius: http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html
<7> tenEighty: Crashing is a problem with the server or the machine on which it resides.
<6> mendel: alright thanks
<9> Hi everybody - I just installed Mysql 5.1.6 and I want to store some non-indexed attributes on disk
<9> Mikael wrote in his blog that this is possible
<9> how can I do this? with which mysql command?
<4> nelius: it clearly shows you can do selects in IN; dunno why you said that wasn't allowed
<3> i'll check this, maybe i made a typho...
<4> heh you mean typo
<3> yepp :-)
<0> Hrm, how can I see how long a query is taking from the command line?
<4> # time mysql -e ''
<4> fairly rough that one not accurate
<4> wait a second
<0> well, I need to make a 5minute query run in under 5 seconds :/
<4> when you run a query it tells you how long it took anyway
<4> just run it and it'll tell you how long it was
<4> inside the mysql prompt
<0> oh yeah, 2min 36.18 sec
<4> lol
<4> well there you go
<4> that's a very worrying time
<0> yeah
<4> i'd reconsider whether you really want to run that!
<4> are all fields indexed
<4> too many subqueries perhaps?
<4> are you doing left joins where you could be doing inner joins?
<0> nope, don't believe so
<4> are combined indices not being used in a way where their index can be utilised
<4> just some things that i normally look for
<4> also make sure you run EXPLAIN <QUERY>
<10> Is there a way to generate the unix timestamp date ?
<10> the numeric value....
<11> hi all
<10> If you know what I mean
<11> i have install a mysql server in my box, but i not have a root p***word... hoew i can set the root p***?
<1> yeah, UNIX_TIMESTAMP()
<1> !m Hor securing
<2> Hor: (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<11> sjrussel: tks
<10> sjrussel: too odvious.. thats
<10> thanks rather
<11> sjrussel: when i type the sql to chage the root p*** in mysql database the system returns:
<11> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
<11> mysql> SET P***WORD FOR ''@'localhost' = P***WORD('
<10> SET P***WORD FOR root@localhost =
<10> with the quotes of course
<1> I think htere's an anon account too
<1> but Hor - on unix, you need to login as root to do that
<1> mysql -u root
<11> sjrussel: i log in as root
<11> mysql> SET P***WORD FOR root@localhost = P***WORD('mysqldataba***xx');
<11> ERROR 1133 (42000): Can't find any matching row in the user table
<11> :)
<10> YOu need to add in the quotes appropriately
<10> SET P***WORD FOR 'root'@'localhost' = P***WORD('mysqldataba***xx');
<11> diilbertAtwork: ERROR 1133 (42000): Can't find any matching row in the user table
<11> i have this
<11> mysql> FLUSH PRIVILEGES;
<11> ERROR 1227 (42000): Access denied; you need the RELOAD privilege for this operation
<12> whats wrong in this ? UPDATE rating SET rverified='0', SET veridate='2006-02-16 02:42:53' WHERE rid=2
<12> getting 1064 error #
<13> no need for multiple SETs
<13> SET rverified=,veridate=,..
<12> thanks
<11> i canot set the root p***word!
<11> Set root p***word? [Y/n] y
<11> New p***word:
<11> Re-enter new p***word:
<11> ERROR 1142 (42000) at line 1: UPDATE command denied to user ''@'localhost' for table 'user'
<11> P***word update failed!
<11> [root@Saint:~]#
<14> that's cuz you're logged in with anonymous user
<14> ''@'localhost' will never have rights to reset root's p***word
<14> unless you grant it, which would be stupid
<11> shabbs: i execute this script
<11> [root@Saint:~]# /usr/pkg/bin/mysql_secure_installation
<14> I don't know what that script does
<11> shabbs: can you help-me?
<11> shabbs: check this
<11> [root@Saint:~]# /usr/pkg/bin/mysqladmin -u root -p p***word 'mysqldataba***XX'
<11> Enter p***word:
<11> /usr/pkg/bin/mysqladmin: unable to change p***word; error: 'Access denied for user ''@'localhost' to database 'mysql''
<14> -uroot no space
<14> or --user=root
<5> no, -u root works fine
<11> yes, i dont know where is the problem
<14> bah, then you help him Darien :D
<5> I'm busy writing a cover letter :p
<14> !m Hor reset root
<2> Hor: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<14> Hor: try those, see if it helps
<11> shabbs: i do that
<11> and the same error
<14> you do which?
<14> there are several methods on that page
<11> that erros and the perms for comand UPDATE
<11> shabbs: can you see this ? http://pastebin.com/556192
<14> Hor: what have you done so far? have you set an initial root p***word? or is that what you're trying to do?
<11> shabbs: see this, sory http://pastebin.com/556193
<11> shabbs: i not set the p***word
<11> i just install the mysqld and now i not have the p***word for root
<11> (sory for my bad english)
<14> Hor: sounds like your hostname is getting resolved as something other than localhost and it uses the anonymous account instead
<14> at least that's my guess
<11> shabbs: have some ideia to solve the problem?
<14> hmm, I'm wrong, cuz then it wouldn't be ''@'localhost'
<11> ...
<14> Hor: what OS?
Return to
#mysql
or
Go to some related
logs:
xorg.conf logitech g5
steam.exe cannot open blob
#math
mbrola ubuntu
declaring an ambiguous field in mysql
suse 10+amarock+engine
tugela debian
w3codecs vlc
#perl
#linux
|
|