#mysql
14 October 2007
Total 16 pages. You are browsing page 16/16.
First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last
23:12 <****> i have set it to 512
23:13 <****> ftpgroup are were groups are stored
23:13 <****> ftpquotalimit are limits for users
23:13 <****> how can I close these tables? must i do a close_table in php ?
23:13 <****> and ftpquotatallie are limits and quotas status for users or groups
23:13 <****> blabaxx: is that "open" or "opened" ?
23:13 <****> 1 row in set (2.87 sec)
23:13 <****> opened TodoInTX
23:14 <****> have I created properly the keys?
23:14 <****> 'opened' means over the course of the lifetime of the process
23:14 <****> the seem to be working...
23:14 <****> but you know havent 30000 records for testing it, although I'm testing LOAD DATA utility
23:14 <****> TodoInTX: so if i have 30,000 opened it is all opened ?
23:14 <****> and still open ?
23:15 <****> thanks :) for this sentence (didn't remember who said it before)...
23:15 <****> blabaxx: no, that is the "Open_tables" status variable that shows currently open.
23:15 <****> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
23:15 <****> how can it SUDDENDLY throw this error out of completely goddamn nowhere?
23:15 <****> hi, i've designed a database in an sql command file, with all the table engines specified as InnoDb, yet after i create the tables from that file, and redump using mysqldump, all the table engines have changed back to MyISAM. why is this?
23:15 <****> TodoInTX: sorry but i still get 2.80 secs query time to show one single result in 300,000 rows.. thats not normal ?
23:15 <****> or instead primary keys should I specify key directy?
23:16 <****> blabaxx: can you use a pastebin to show the table schema?
23:16 <****> anyone who knows this please :)
23:16 <****> anyone could help me?
23:16 <****> GODDAMNIT
23:17 <****> TodoInTX: its just a simple table with type=myisam and no specific things
23:17 <****> Xgc, please help me :)
23:17 <****> Ramattack: I did. Now wait for someone to respond. I have to run to dinner.
23:17 <****> if you're doing just a "SELECT COUNT(*) FROM `tbl_name`" it should return very fast regardless of the number of rows in the table.
23:18 <****> ok thanks Xgc
23:19 <****> TodoInTX: thats right
23:19 <****> TodoInTX: but if i do a select field1 from mytable; then it takes about 2,80 seconds .. and i have 300,000 rows
23:19 <****> blabaxx: no WHERE condition?
23:20 <****> no TodoInTX
23:21 <****> if you SELECT field1 FROM (all rows in) `tbl_name` it will need to do a full table scan to get all the data. Could take a while if you have a low 'read_buffer_size'
23:22 <****> yeah, but that will take a loong time since there are 300 000 records
23:22 <****> how can i check that there is a record for each word from a list of words i have
23:22 <****> if i have 2 tables with a common column, i would use JOIN to pull both tables at once right?
23:22 <****> ie. select count(*) from tbl where fld in (val1, val2); <--- ie. if 2 is returned, i know there is a record for each word - where fld is unique
23:23 <****> [domon]: correct
23:23 <****> hmm
23:23 * [domon] hasn't ever used JOIN before
23:24 <****> [domon]: http://dev.mysql.com/doc/refman/5.0/en/join.html & http://en.wikipedia.org/wiki/Join_%28SQL%29
23:24 <****> say i have table `messages` with id = 1 and table `notes` with message_id = 1
23:24 <****> would it be uhh
23:25 <****> SELECT * FROM `notes` INNER JOIN `messages` notes.message_id = messages.id WHERE messages.id = 1; ?
23:26 <****> select [field list] from messages left join notes on (messages.id = nodes.message_id) where messages.id = 1;
23:26 <****> so, i was close :P
23:26 <****> gnari TodoInTX i solved it by setting the default to 0 instead of NULL
23:26 <****> [domon]: probably yours will work too .
23:27 <****> TodoInTX: still slow queries after what you told me
23:27 <****> [domon]: you have something wrong with your ON() clause though
23:27 <****> TodoInTX: when i link 2 tables, then it goes very slow, thats what i wanted to say
23:27 <****> blabaxx: so do both column in the ON() condition have indexes?
23:28 <****> it returns 0 results :P
23:29 <****> oops
23:30 <****> it would help if i used an ID that actually exists wouldnt it? :P
23:30 <****> generally ;-)
23:30 <****> and to add ANOTHER table...
23:30 <****> just another LEFT JOIN again?
23:34 <****> why could this be set as this?
23:34 <****> PRIMARY KEY (id),
23:34 <****> UNIQUE KEY userid (userid)
23:34 <****> primary key can't be repeated...
23:35 <****> should all text cols have a ft index on them (even though they will contain very short phrases up to four words)?
23:35 <****> I see....
23:35 <****> it sets primary key for being primary key
23:35 <****> and later
23:35 <****> unique key for not be able to repeat it's value?
23:44 <****> if i have "select" sql with lots of "where" and "order by" statements how can i select next row after "somethinld"=5
23:44 <****>5 is wrong answer
23:45 <****> because of lots of order by
23:47 <****> somethinId is a column name
--- Log closed Mon Oct 15 00:00:18 2007
Total 16 pages. You are browsing page 16/16.
First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last