#mysql
11 October 2007
Total 31 pages. You are browsing page 1/31.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Oct 11 00:00:07 2007
00:00 <****> all user to read and write to files that stay in the mysql server. You shouldn`t give this permission to someone you don`t trust. That`s a reason why you shouldn`t ever run mysql as root
00:00 <****> blobaugh|sp, so I`m concerned about being running mysql_safe as root
00:01 <****> blobaugh|sp, most of the times, from /etc/rc.d/rc.mysqld
00:03 <****> blobaugh|sp, miss spelled, all user are able to read ...
00:04 <****> hi
00:06 <****> Could anyone tell me how slow is CONCAT operation? Eg when it comes to updating 10k entries in a table with CONCAT( column, 'whatever') ?
00:06 <****> !tell vice-versa cheatsheet
00:08 <****> http://xkcd.com/
00:08 <****> freebird: dont worry about it. make sure the mysql files are owned by someone other than root, but you have to start mysql as root. then it uses the permissions of the user the owns it
00:09 <****> blobaugh|sp, I see, tks ....
00:09 <****> Joe7: i dont know, but you could try it with a test database
00:10 <****> i wouldnt think its terribly slow
00:10 <****>
00:13 <****> blobaugh|sp: 1.0504 sec to update 31058 rows
00:13 <****> it's ok. :P thanks
00:15 <****> yeah, not bad at all
00:15 <****> ive been pleasently suprised with speeds from mysql
00:16 <****> i did something with 100k records a few weeks back, and it took < 10 seconds
00:17 <****> Hi, I am using MySQL Connector/J via apache-commons-db but the debugger shows exceptions in the JdbcOdbcDriver class. Any idea why that might happen?
00:21 <****> Is there a way before doing an alter to test if a column on a table exists?
00:32 <****> you could select from information_Schema or describe table
00:32 <****> how would one go about grabbing the last row in a table?
00:33 <****> Define "last"
00:33 <****> the last row inserted
00:33 <****> There is no concept of "last" without an ORDER BY
00:33 <****> MySQL does not keep track of the last row inserted automatically. You need a column to define that.
00:33 <****> use order by to reverse it, then limit 1.
00:34 <****> if the pk is auto-increment, you can find it by doing SELECT max( pk_field ) from table
00:34 <****> it's not
00:34 <****> that's the problem
00:34 <****> my PK is a string between 1 and 255 characters in length, not sorted.
00:34 <****> blobaugh|sp: Are you ignoring chadmaynard?
00:34 <****> Annihilation: You will need a column to track it then.
00:35 <****> no, hes not in here right now
00:35 <****> or a separate table would be better
00:35 <****> seekwill: his connection timed out
00:35 <****> a column, meaning - an autoincrement column?
00:35 <****> That's a way
00:36 <****> my way would be tons of un needed overhead right?
00:36 <****> over the course of several hundred million inserts
00:36 <****> what do you think the performance difference will be inserting ("string","value") vs ("string","value","") for the autoincrement?
00:37 <****> Annihilation: i tried having a pk that was varchar 50. after hundred million rows, performance goes to shit anyway
00:37 <****> better off using an int as a pk
00:37 <****> Annihilation: you do not have to specify anything for the auto increment. it just does it
00:38 <****> Anyone know why a SQL query would execute in .05 sec when run in the query browser but the same statement runs in 34 secs as a function?
00:38 <****> How can i increase the speed of a query that uses order by rand() ?
00:39 <****> rand() order by id limit 1
00:39 <****>rand() ?
00:40 <****> iratik: you can do max(id) of the table first
00:40 <****> It looks like it might be evaluating rand() too often. Maybe you shoudl put the main query in a subselect and put rand() outside the subselect.
00:41 <****> when you use rand in an order by, causes full table scan, among other things
00:41 <****> SELECT * FROM (SELECT column FROM Table LIMIT 10) AS iHaveAnAlias ORDER BY rand(); -- is lickety split
00:43 <****> Anyone?
00:44 <****> nathacof: does the query contain code such as IF(in a function): SLEEP(34000) END
00:45 <****> DanielHolth: ... no
00:45 <****> nathacof your question is ridiculously vague.
00:45 <****> nathacof: would have to see the function
00:46 <****> My question is this: Is there any reason why a query would perform worse when run as a function? ... is that vague?
00:47 <****> hi, is this an english or german channel`?
00:47 <****> raenkie, english
00:47 <****> ty
00:47 <****> ive got a quest
00:48 <****> i want to install a cms
00:48 <****> nathacof: create a function that does: SELECT 1;
00:48 <****> and when im going to install
00:48 <****> nathacof: see if it takes 34 secs to run
00:49 <****> the broeser put out this message
00:49 <****> broeser = browser
00:49 <****>
00:49 <****> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'tecvision'@'localhost' (using password: YES) in /var/www/tecvision/install/step06.php on line 100
00:49 <****> ERROR: no connection to mysql
00:49 <****> what is the failure?
00:50 <****> i have a root server, and have no idea, why im not able to create a new sql database with browser...?
00:50 <****> anyone?
00:51 <****> ?
00:53 <****> raenkie, do you understand the error message?
00:53 <****> yes i think so
00:54 <****> i cannot connect to mysql
00:54 <****> but
00:54 <****> it runs
00:54 <****> there is another site on this server
00:54 <****> with a mysql database
00:54 <****> "access denied". rings a bell?
00:54 <****> ok
00:54 <****> hello..I have 2 tables A, B..
00:54 <****> hello, marinosi
00:54 <****> acvess denied
00:55 <****> but
00:55 <****> how i can acess
00:55 <****> how can I get A-B elements?
00:55 <****> stop vertical chatting, raenkie, willya
00:55 <****> tibyke: hi:D
00:55 <****> what do u mean?
00:55 <****> raenkie, you grant access. that'd be a good start. but read manuals first.
00:55 <****> wha
00:55 <****> ....
00:55 <****> ty
00:56 <****> marinosi, join
01:01 <****> can I loop on a result set from within the mysql client without creating a stored procedure?
Total 31 pages. You are browsing page 1/31.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last