#mysql
01 November 2007
Total 22 pages. You are browsing page 2/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:41 <****> zeeg, the higher the number of rows in table a, the more help from the index on post_date
00:42 <****> lazyeye, thats what i was looking for thanks :)
00:49 <****> even with SQL_NO_CACHE the second time i query its 2x faster
00:49 <****> oh wow
00:50 <****> maybe thats because there're other caches beyond query cache?
00:50 <****> im querying in mysql directy
00:50 <****> maybe thats because there're other caches beyond query cache?
00:50 <****> ok?
00:50 <****> ok!
00:51 * domas enjoys the persuasive powers
00:52 <****> so I just did grant all on *.* to '*'@'some.ip.address' identified by ''; and now I can't connect from localhost. how do I fix that?
00:52 <****> are there any good practices for optimizing views?
00:52 <****> in fact I did that in mysql 4 and did an upgrade to mysql 5 and was no longer able to connect from localhost
00:53 <****> zeeg: sure, optimize underlying queries.
00:54 <****> the query is simply a union that selects the primary key with no ordering
00:54 <****> (dont think I can make it any faster :)
00:54 <****> make it UNION ALL
00:54 <****> heee, performance!
00:55 <****> i dont see how union all would increase performance
00:55 <****> jpastore: then a grant for localhost doesn't exist?
00:55 <****> domas, I didn't put one in and now I can't
00:55 <****> I'm removing mysql completely and purging the /var/lib/mysql dir
00:55 <****> jpastore: --skip-grant-tables
00:55 <****> I have a dump file I can reimport
00:56 <****> domas, ok give me a sec to try thanks!
01:03 <****> hey everyone. When I run a query through a script, I store the result of that value into a variable. Apparently its showing the column header and the value
01:04 <****> Is there a way to tell msyql not to give me the column header?
01:04 <****> dont use the mysql binary
01:04 <****> use a real library
01:04 <****> in a bash script?
01:07 <****> blizzkid: I got it working! MySql I mean, it does connect!
01:07 <****> use a real scripting language
01:09 <****> !man remote
01:09 <****> (Establishing a Remote Connection to System A from System B) : http://dev.mysql.com/doc/mysql/en/remote-connection.html
01:11 <****> SQL: thanx, but the problem was something else... It's ok to create users with granted connection rights
01:12 <****> hey guys
01:12 <****> what is faster, search wise
01:12 <****> fulltext search or like?
01:15 <****> hi. im trying to learn stored procedures, but i can't get this query to work! what am i doing wrong? : http://pastebin.parentnode.org/26897
01:17 <****> cool _hopex
01:18 <****> blizzkid: it was the my.cnf file configuration
01:18 <****> oh crap
01:18 <****> blizzkid: i think we tryed all the rest options, ;P
01:19 <****> anyone kind enough to help me with the procedure? http://pastebin.parentnode.org/26897
01:19 <****> yeah, it's always the last option :P
01:19 <****> if only mysql could give sane errors :p
01:20 <****> if only!
01:21 <****> demio: Usually, a fulltext index
01:21 <****> hmmm
01:21 <****> demio: "LIKE '%word%'" is a full table scan.
01:21 <****> "MATCH(col) AGAINST('word')" is utilizing the fulltext index
01:22 <****> blizzkid: Now I can start dumping dbs and creating my next projects! MySQL is really great & fast! I'm happy :D :D xD
01:22 <****> hmmm
01:23 <****> holy shit
01:23 <****> oscommerce uses "LIKE"
01:23 <****> for search
01:23 <****> our db has over 87k products
01:24 <****> demio: A regular index will index the entire column value, so "word1 word2 word3" will be treated as a string.
01:24 <****> ea
01:24 <****> yea
01:24 <****> demio: A fulltext index will split such value into the single words, "word1", "word2", "word3" and index them seperately
01:25 <****> i seee
01:25 <****> jesus christ
01:25 <****> oscommerce's search code is so BAD
01:25 <****> it's horrible
01:25 <****> demio: So when looking for "word2", a regular index will have to scan every entry
01:26 <****> plz, any mysql guru wanna look at this shortie? http://pastebin.parentnode.org/26897
01:26 <****> gah
01:26 <****> it's all procedural programming
01:26 <****> makes my brain bleed
01:26 <****> tell me about it :P
01:27 <****> not your code, oscommerce's
01:27 <****> i meant procedural programming in general
01:27 <****> oh
01:27 <****> :P
01:27 <****> yea, it sucks
01:27 <****> oo ftw
01:27 <****> :)
01:28 <****> argh wtf
01:28 <****> fucking SEO, stealing all my info
01:29 <****> I want info about optimizing the oscommerce search procedures, all I get is SEO info
01:29 <****> -_-
01:32 <****> while you look for it, help me with stored procedures :P
01:32 <****> http://pastebin.parentnode.org/26897
01:41 <****> hello friends
01:41 <****> here's no friends.
01:41 <****> ein?
01:42 <****> you're not my friend
01:42 <****> ?
01:42 <****> ok just a question
01:44 <****> my.cnf
01:44 <****> character-set-server=utf8
01:44 <****> in what section of my.cnf ?
01:46 <****> nobody??
01:47 <****> how can i append "if the ban field is set to 0, show those entries" to foreach($_POST as $id) {
01:49 <****> wut ?
01:50 <****> that sounds like a php question
01:50 <****> GENTOODUDE: did you ask in ##php ?
01:50 <****> thumbs:no
01:51 <****> GENTOODUDE: it still doesn't make sense
Total 22 pages. You are browsing page 2/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last