#mysql
06 November 2007
Total 30 pages. You are browsing page 5/30.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
03:20 <****> ok thanks for input
03:21 <****> Led_Zeppelin: this 'benefits of innodb' is a little dated but good. http://forums.mysql.com/read.php?22,131985,131985
03:25 <****> sander_: If you come up with anything of interest, please let me know! :)
03:28 <****> Hello. I'm trying to create a view in MySQL 5 but I keep getting denied for that user. I granted all on that database to that user on localhost. Doesn't "grant all" include "create view"?
03:33 <****> cilkay: all on db.* should be fine
03:34 <****> cilkay: do you also has the priv on the table used in the view
03:34 <****> How does MySQL act if table_lock_wait_timeout is reached?
03:34 <****> kimseong: the user in question has been granted all on that db.
03:34 <****> Rather, how should it act?
03:35 <****> cilkay: confirm it with show grants for current_user();
03:36 <****> kimseong: it's not current_user I'm concerned with. It's a user I created specifically to "own" that database.
03:37 <****> cilkay: to make sure the user conencted correctly and to check the priv
03:37 <****> there is no ownership in mysql
03:37 <****> cilkay: he recommended you log onto the server as that user and run the show grants command.
03:37 <****> I see.
03:38 <****> cilkay: from the machine that has problem creating the view, if different client, might behaves differently
03:38 <****> I'm on localhost.
03:39 <****> I have a remote shell on that machine so I'm connecting to a mysql instance on that machine.
03:39 <****> cilkay: is the mysql user account in question going to be connecting to localhost?
03:39 <****> yes
03:39 <****> only localhost
03:39 <****> hi all, I have a usergroup called 'editor' I want to add some users in that usergroup but somehow its not happening.
03:39 <****> cilkay then test on localhost
03:39 <****> I am.
03:40 <****> shirish: what application is this? ask the author of the application
03:41 <****> kimseong: its just a database, here's the output when inserting users into it.
03:41 <****> kimseong: http://pastebin.ca/763045
03:42 <****> shirish: the error message is very clear, you already use the same value, no duplicates allowed
03:42 <****> 0 cannot be used again
03:42 <****> How should MySQL respond if the table_lock_wait_timeout is reached and exceeded?
03:43 <****> Jakiao: read the manual, I guess nothing much, this only affect cursors or something, not too sure how it works
03:43 <****> kimseong: ok, although I didn't use 0
03:43 <****> Mmk.
03:44 <****> shirish: check your insert statement carefully
03:44 <****> We have queries which have been getting stuck every now any then. THen all queries after them get stuck and wait. 50 seconds, 80 second, 120 second query time.
03:44 <****> Causing lots of issues.
03:45 <****> shirish: from your paste "...VALUES ('0', '')..."
03:45 <****> Jakiao, probably you want to fix the slow queries?
03:45 <****> ok cool, I actually found another way I could do things as well
03:46 <****> kimseong: thanx for your help though as well.
03:46 <****> Jakiao: i recall myisam will wait until the lock is obtained, no timeout
03:46 <****> They aren't slow queries. The queries getting stuck happen all the time with little issue. Just, it seems like at random they get stuck.
03:47 <****> One query that got stuck today was a simple SElECT field1, field2 FROM table WHERE id=int;
03:47 <****> hello.. need help on database design...
03:48 <****> what kind of help?
03:48 <****> I'm working on a way around deadlocks (since we have 6 slaves). Detect the deadlock and avoid the server. But I wish I could address the issue itself.
03:48 <****> hi all. i'm very close to recovering years of work in a journal. ver excited. just need help with one task.
03:48 <****> Jakiao, and I suppose you're sure that was the actual query that got stuck, and not some immediately preceding one.
03:49 <****> i need to create a query that picks through a db table and replaces all instances of "foo" with ""
03:49 <****> I've sometimes seen ludicrously slow simple queries, but only when held up by a lock for some other reason.
03:49 <****> but i am very new, and don't know how to write that query
03:49 <****> can anyone help? (this is via phpMyAdmin btw)
03:49 <****> Jakiao: start the slow query log and look for a pattern?
03:49 <****> I've been watching the slow query log as well as processing queries for the past two weeks.
03:49 <****> Patrabugen, i have 2 modules that have lots of similarities in a way (classifieds and products), and im confused if i need to put them on a separate table...
03:50 <****> Patabugen, i have 2 modules that have lots of similarities in a way (classifieds and products), and im confused if i need to put them on a separate table...
03:50 <****> MrSock: update table set col = replace(col, 'foo', '');
03:50 <****> I have a fairly good idea of which queries are causing this, and there seems to be no pattern.
03:50 <****> MrSock http://www.mediacollege.com/computer/database/mysql/find-replace.html
03:50 <****> thanks pat and ki77
03:51 <****> Ooh, that really depends on exatly what data you have for each and what you want to do with it
03:51 <****> ah- no, wait
03:51 <****> will that pick through a bunch of text in the column?
03:51 <****> Hi, all. I made a backup with mysqldump --all-databases, and now I just want to restore one database from that file (alldbs.sql). Is "mysql -o onedb < alldbs.sql" safe? Thanks.
03:52 <****> MrSock: yes
03:52 <****> cool
03:52 <****> thx again
03:52 <****> Patabugen, thanks. i am caught between making 2 separate tables or just 1 table for both and just put an identifier field....
03:52 <****> that will set the value of one column, to the return value of the replace
03:53 <****> fyi, im building a high traffic site so it will be a lot of request for the table...
03:53 <****> emaconline, what are the differences?
03:53 <****> no - i don't think that's what i want, is it?
03:53 <****> MrSock whatdo you want to achieve?
03:53 <****> Patabugen: that will replace all instances of 'foo' with '' within the column.
03:53 <****> there is a table with all of my blog entries
03:53 <****> they are multi-paragraph blocks of text
03:54 <****> within those blocks of text are path references to pictures
03:54 <****> i need to change the path
03:54 <****> in all inances
03:54 <****> from mydomain.com/wherever/
03:54 <****> yes that should do the trick
03:54 <****> to mydomain.com/
03:54 <****> yeah?
03:54 <****> what do you do when a block of text you are inserting into a row includes a single quote or something similar?
03:54 <****> make sure you keep a backup of the ofiginal data first =)
03:54 <****> is there a shortcut to do everything in the whole dbase?
03:54 <****> or do i have to go 1 table at a time?
03:54 <****> one table at a time afaik
03:54 <****> ok
03:55 <****> hi, im having a problem ... im running mysql 5.0.32, and when i try to create a view, it gives me an error that my user doesnt have create view privileges. how can I grant it to my user ?
03:55 <****> Patabugen, the difference: SETUP A (2 tables) - Visitors visiting the Classifieds section will only query the classifieds table.. SETUP B (1 table) - Everything will access the table with a WHERE statement...
03:55 <****> matthew_, you can escape it with a \
03:55 <****> emaconline Whats the difference between the sets of data?
03:56 <****> I'll brb in a little bit, gotta put some food on
03:56 <****> Patabugen, almost the same..
03:56 <****> emaconline , What are you asking?
03:58 <****> hm .. that's strange. i tried to submit the query through the "Query" page in phpMyAdmin, and it says "you have to choose at least one column to display", as though it's forcing me to use the form dropdowns and piece together the query that way.
03:58 <****> where can i enter a raw query string?
03:59 <****> MrSock: can you ssh into the mysql server?
03:59 <****> MrSock, the SQL tab
Total 30 pages. You are browsing page 5/30.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last