| jazzrocker | MentalPower: ask #centos ? |
| MentalPower | fair enough, thanks |
| fatpelt | shimi: yeah. it would obviously be incorrect for your needs |
| shimi | fatpelt, it says that possible keys = dump, type = range, key = dump and extra = "using where" |
| fatpelt | shimi: ok, so we got rid of the filesort. the problem with the filesort is probably " The key used to fetch the rows is not the same as the one used in the ORDER BY" -- from http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html |
| jazzrocker | vak: doing specifically what you want to do, no there is no GUI geared towards that... there are however GUIs available |
| fatpelt | shimi: do you need the unixtime index? |
| jazzrocker | gui |
| the_wench | GUI tools can be found at http://dev.mysql.com/downloads/gui-tools/5.0.html phpMyAdmin at http://www.phpmyadmin.net/ and even navicat |
| jazzrocker | gui @ vak !man gui @ vak |
| the_wench | Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/gui @ vak |
| jazzrocker | hmm oh well vak: you get the idea |
| shimi | well, I am sorting by unixtime desc, and taking the upper result... so I figured I need an index for that to sort quickly, no? |
| fatpelt | shimi: can you try dropping it or would that break other stuff? |
| vak | jazzrocker, OK thank you a lot |
| jazzrocker | np |
| shimi | and since it's "genre", then "unixtime", I need a joined index by genre,unixtime, am I wrong? |
| archivist | !tell jazzrocker about gui |
| the_wench | jazzrocker GUI tools can be found at http://dev.mysql.com/downloads/gui-tools/5.0.html phpMyAdmin at http://www.phpmyadmin.net/ and even navicat |
| jazzrocker | vak: i really think you should do it by hand, with SQL |
| archivist | dats how |
| DedParet | I'm still confused here. I understand how to find all those records with an ID that *does* show up alongside a particular 'ngram' value, but not the other way around. |
| shimi | oh you mean the standalone "unixtime" index ? |
| jazzrocker | vak: GUI tools are really only useful for viewing large queries... mysql cli fucks up each row real bad if the row is longer than your screen is wide |
| fatpelt | shimi: well, for a test i'd like to see what happens if you drop the index titled unixtime (that only indexes the unixtime column). leave the dump index (indexing genre,unixtime) as is |
| Insolit | how can i insert a date into mysql? |
| fatpelt | shimi: yup |
| shimi | ok :) |
| archivist | !tell DedParet about a not in b |
| fatpelt | Insolit: you mean like 'yyyy-mm-dd' ? |
| the_wench | DedParet SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL; |
| vak | jazzrocker, customer will say good bye to this idea. the custmer believes the pretty blond should make the job, when programmer leaves the city. |
| jazzrocker | vak: though it's nice to have the gui admin panel... but as far as DB design, stay away from gui tools |
| shimi | ok, dropped the index or at least, gave the command, it seems to be processing alot now :) |
| Insolit | fatpelt: either that or a timestamp |
| fatpelt | shimi: and does the original sql still filesort ? |
| jazzrocker | vak: wtf is the customer doing DB design for? |