| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<Kemurii> arekm: remove the LIKE '%' already
<Kemurii> remove the HAVING, remove the GROUP BY :P
<Kemurii> what index is used?
<arekm> I did that already. SELECT COUNT(*) FROM beess_domains WHERE zajety = '0' AND locked = 0 AND time != 11 AND typ = 'FIRMOWA' GROUP BY nask_id HAVING COUNT(nask_id) BETWEEN 1 AND 5; now
<arekm> | 1 | SIMPLE | beess_domains | ref | time,locked,zajety | zajety | 5 | const,const | 19896 | Using where; Using temporary; Using filesort |
<Kemurii> looks good
<Kemurii> archangle25 why not HAVING ... <= 5?
<arekm> because the query can be BETWEEN 5 AND 20 too :) these values do change depending of what user selects in application
<Kemurii> kk
<arekm> now it takes 141650 rows in set (21.68 sec) ... it takes few times longer when server is actually used
<Darien> filesort, ew
<Kemurii> well, zajety field is not a good candiate for indexing imho.. 2 possible values
<arekm> why mysql isn't using key nask_id here?
<Kemurii> arekm: you're not using it
<firewire> having won't use an index
<arekm> hm, there has to be some way to make things faster here
<firewire> mabye an index across zajety, type, and nask_id?
<Kemurii> don't add more indexes to that table, rather remove some
<arekm> I'm dropping index ,,zajety''
<firewire> ok
<Darien> also, you might try adding count(nask_id) to the fields list in your SELECT and then use it in the WHERE clause instead
<litheum> Kemurii: do you know if there is some ndb api documentation somewhere? do you have any? or some example programs or something?
<Kemurii> litheum: example stuff in the bk tree, ndb/ndbapi-examples
<Kemurii> or something like that
<litheum> Kemurii: ah, cool, thanks
<Kemurii> litheum: I have docs :P
<Darien> anyone hiring MySQL DBAs in GTA?
<litheum> Kemurii: is it hard to get some simple programs up and running?
<Kemurii> litheum: nope, one second
<arekm> SELECT COUNT(nask_id) AS cnt FROM beess_domains WHERE zajety = '0' AND locked = 0 AND time != 11 AND typ = 'FIRMOWA' GROUP BY nask_id HAVING cnt BETWEEN 1 AND 3; - unfortunately explain gives the same results so I guess it won't befaster
<Kemurii> litheum: I should say yes, but a simple program for me now is just connecting :)
<litheum> :)
<Kemurii> litheum: not fully maintained, but well.. http://hartmut.homeip.net/ndb/
<litheum> oh yeah damn i forgot about that
<litheum> thanks
<Kemurii> litheum: got some stuff on ndbsup-1 :)
<Kemurii> litheum: you should be able to get that.. ~/cluster/<name>/ :)
<litheum> ok
<Kemurii> litheum: you got shift?
<litheum> yep
<CarlH> how can I dump the structure of a database, including users/permissions etc --- to import into another database? (no need to move the data)
<Kemurii> that would be cool! mysqldump --with-permissions dbname, which will dump related permisisons for dbname too :)
<Kemurii> CarlH: mysqldump the database, and also the mysql database, .. but you will get all grants for all users if you 'mysqldump mysql'
<CarlH> got it thanks
<rosenjon> can anyone help me on logging into sourceforce cvs
<rosenjon> or send me to a channel where they can help
<rosenjon> i realize this isnt exactly mysql territory
<epic> i get a java.io.EOFException in com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1865) .. this is a preparedstatement, this only happens when my code hasnt been "used"/run for a while, any idea how to fix this?
<Darien> epic: maybe you're losing the database connection?
<epic> ah
<epic> yeah
<epic> seems i need to up the max idle time or something?
<epic> it is 8H ?
<Darien> depends on your configuration
<Darien> or just tell your code to check the connection and reconnect if necessary
<A> hi
<jMCg> Hello. I'm back.
<jMCg> Looks like I can't get around MySQL after all (:
<jMCg> I'm trying to install Joomla! and I'm experiencing a bit of a trouble, whilst trying to create a database.
<A> hee
<A> #izmir
<jMCg> http://phpfi.com/106820
<A> /join #izmir
<jMCg> A, die.
<A> #izmir
<epic> Darien: but my code doesnt run in a loop :)
<Darien> hmm
<epic> its completely even driven
<epic> event even
<epic> ;)
<Darien> then check on events :p
<epic> yeah could do
<epic> but that kinda looses the point of using prepared statements?
<jMCg> Heh.. Useless log. Says the same.
<jMCg> 060312 1:07:38 5 Connect Access denied for user 'diver'@'localhost' (using p***word: YES)
<jMCg> Oh....
<jMCg> Hmm...
<jMCg> The user has to exist in the system?
<jMCg> I'm confused.
<Ralle> how do I enable ALL kinds of letters to come to my table?
<Darien> set the table to Unicode
<Darien> !m Ralle character set
<SQL> Ralle: (Character String Literal Character Set and Collation) : http://dev.mysql.com/doc/mysql/en/Charset-literal.html
<Darien> jMCg: not in the system, no
<jMCg> Darien, enlighten me.
<Darien> jMCg: mysql maintains its own user/p***word database independent of the operating system
<jMCg> How do I create a user?
<jMCg> Okay. That was a stupid question.
<jMCg> I'll RTFM.
<Darien> !m jMCg creating users
<SQL> jMCg: Nothing found
<Darien> ffs
<litheum> !tell jMCg about adding users
<SQL> Alrighty.
<litheum> !man adding users
<SQL> (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<jMCg> I tend not to like this: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<litheum> jMCg: is this a new install?
<litheum> !man reset roto
<SQL> Nothing found.
<litheum> !man reset root
<SQL> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<jMCg> MySQL is so.... different.
<mikere> different?
<zeeeeee> hi all, if i have a table of (time,pos,speed) with one row per second, is there a convenient way to write the following query? find any "timespan" of > 30 seconds, where the top speed during that span < 10, and return the min and max pos for that span
<sdhlki> what do you mean by the min and max position
<zeeeeee> sdhlki: disregard that, just the start/end time for that timespan
<Darien> jMCg: not really
<Darien> jMCg: using system users for the database is a terrible idea
<zeeeeee> sdhlki: (using a maximal-munch approach wrt time)
<Darien> jMCg: you need to use -p to specify a p***word
<jMCg> Darien, I haven't even thought about that.
<Darien> about using a p***word?
<jMCg> It's just.. that in PostgreSQL there are those neat little commands, that make my live so much easier (:
<sdhlki> anyone here proficient with sourceforge?
<jMCg> [createdb, dropdb, createuser, dropuser ;]
<sdhlki> i have a pretty simple problem -- i want to login to download some cvs files, but i can't get on
<jMCg> Darien, no hell.. I NEVER use p***words! [Please notice the sarcasm in my voice.]
<sdhlki> not sure whether it is me, or the server
<Darien> yeah, but postgres is also stupid in some ways
<Darien> e.g. you can't start the command-line client without specifying a database
<Darien> and you have to actually BE the system user (postgres) to start creating accounts
<Darien> also, postgres allows system users in by default, which just seems silly
<jMCg> I agree. PostgreSQL tends to be a bit hard when it comes to the config. But once you're thru it's.. so.. ***y.
<CarlFK> I am connected as 'root' (admin, su.. etc.) - how do I see what users have what access to table foo?
<FilipeGraciosa> hello, anyone can give me a help? i having problem with my forum PHPBB2 and the guys of phpbb channel, tould me that my problem is related to the mysql
<jMCg> ARGH ><
<jMCg> FilipeGraciosa, you just reminded me of some terrible fact.
<sdhlki> whats the problem filipe
<FilipeGraciosa> i installed the phpbb2 in a new server, and restore the backup, but all the portuguese caracters, apear chinese, but if i post a new Post, the portuguese caracter, remain.
<FilipeGraciosa> www.cavalonet.com/phpbb2
<FilipeGraciosa> any sugestion?
<FilipeGraciosa> jMCg
<sdhlki> sounds like you probably have to define the character set when you import
<jMCg> FilipeGraciosa, nope. I'm total MySQL n00b.
<mikere> you'd think the sqldump would specify character set
<sdhlki> did you dump the structure and the data, or just the data
<jMCg> meh
<jMCg> Not a single MySQL book.
<sdhlki> can someone help me out logging on to sourceforge?
<ijwyn> how do I increase the max size allowed for a text file containing data I want to import into a database?
<CarlFK> ijwyn: size of what?
<Darien> ijwyn: you're using a file with SQL statements?
<reZo> jMCg: Mind sharing your eBooks list?
<CarlFK> hmm, is there a limit on the size of the datafile?
<sdhlki> anybody -- a little help with sourceforge and cvs downloading?
Return to
#mysql
or
Go to some related
logs:
xset fp rehash xorg ubuntu
#python
gentoo find.duplicated files
#web
smp libata.atapi_enabled
#web
USB-Stuícks
mount windows partitions ubuntu generic error
apt-get no pdiff
#linux
|
|
