#mysql
03 January 2008
Total 3 pages. You are browsing page 1/3.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Jan 03 00:00:09 2008
00:00 <****> so just alter table and be done with it
00:00 <****> hi
00:00 <****> can i use DESC with LIMIT ?
00:01 <****> Yes
00:01 <****> haygus: yes.
00:01 <****> so i have an error : "SELECT * FROM video LIMIT 0, 1 DESC"
00:01 <****> or order by id ?
00:01 <****> the last i want
00:01 <****> haygus: you're inventing syntax. Have you read any of the manual?
00:02 <****> yeah
00:02 <****> mysql: id, auto_increment - which is the first number? 1 or 0?
00:02 <****> Hreno: 1
00:02 <****> is_null: thanks
00:02 <****> yw
00:02 <****> brb
00:02 <****> haygus: select * from t1 order by col desc limit 1;
00:03 <****> yeah i have just read it
00:05 <****> ty
00:05 <****> is there a way to check if a table exsist other then show tables?
00:05 <****> Crash1hd: you could use the information_schema
00:05 <****> select 1 from table limit 0
00:05 <****> information schema
00:05 <****> information_schema is a virtual database of databases inside of MySQL 5.0. You can use it to get schema, table and column metadata. Please note: It only shows information the user has access to. For more info: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
00:05 <****> or check the super slow lame retarded information schema
00:06 <****> an opinion!
00:06 <****> hehe
00:07 <****> select * from TABLES where TABLE_SCHEMA='test' and TABLE_NAME='t';
00:07 <****> takes .05 seconds
00:08 <****> select 1 from test.t limit 0;
00:08 <****> 0.00 seconds
00:08 <****> haha
00:08 <****> I think my MySQL server is underperforming... with dual 1.8Ghz Xeons, it took XXX minutes to select 417,000 rows from a MyISAM table into a new InnoDB one that is the same. While running top showed that mysqld was only using 14% of the CPU and nothing else.
00:08 <****> Do you think I am hitting a disk IO bottleneck?
00:08 <****> yeah
00:08 <****> Sembiance what did iostat say?
00:08 <****> ebergen: ooo not aware of that command, going to go check that out now
00:09 <****> do this: iostat -dkx 1
00:09 <****> I_S: http://bugs.mysql.com/bug.php?id=19588
00:09 <****> bora77 see what I mean :)
00:09 <****> I_S is a POS and what's worse is that most of the show commands have been converted to use it
00:09 <****> hate it
00:10 <****> almost like a DOS attack
00:10 <****> yeah :)
00:10 <****> I remember show status was converted to I_S it would create a temporary table
00:11 <****> Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util
00:11 <****> sda 1.00 50.00 139.00 47.00 588.00 400.00 10.62 14.56 143.15 5.38 100.10
00:11 <****> Sembiance please don't
00:11 <****> if %util is 100% you are i/o bottlenecked
00:11 <****> ebergen: sorry, it was only two lines, thought it would be okay :)
00:11 <****> or i/o bound
00:11 <****> ebergen: it fluctuates between 95% and 100% or so. hrm...
00:12 <****> i/o bound
00:12 <****> I guess disks are important :)
00:12 <****> that's what my email tells me several times a day
00:13 <****> thanks all
00:15 <****> threnody, it does? Mine tells me hacked copies of WinXP are important.
00:15 <****> And penis size.
00:15 <****> Anyone know off hand if version 5.0.41 had any bugs in it that would cause mysql(maybe innodb related) to stop handing queries for 5-30 seconds?
00:18 <****> domas it's pretty sad that information schema is slower than innodb
00:22 <****> ebergen: I've seen more sad things :)
00:22 <****> Simetrical: While shopping for your next M$ o/s you might find these 'Now Slower and with More Bugs' stickers useful. http://evilmadscience.com/else/62-bugs-stickers
00:22 <****> domas me too but that one is pretty high up
00:22 <****> So I'm importing a fairly large db via command line, and it has failed is there a switch I can use so it doesnt import the rows that are already there, or am I sol?
00:22 <****> "Look we gave you information schema but it's so slow you can't use it!"
00:23 <****> deshymers you can change the inserts to insert ignore
00:23 <****> threnody, hopefully I won't have to shop for any M$ OSes ever again. :D
00:23 * Simetrical kicks Wine
00:24 <****> you won't, no one is moving past XP :)
00:24 <****> Simetrical: If it isn't infested with DRM I just won't use it.
00:24 <****> ebergen, probably what they said about 98 too.
00:25 <****> yeah, when ME came out
00:25 <****> To be fair, there are some improvements in Vista, like actually not encouraging users to run as as root.
00:25 <****> I can't really say since I haven't ran it first hand
00:25 <****> but most of what I hear is really bad
00:25 <****> Simetrical: some of that vaunted M$ creativity.
00:25 <****> Also to be fair, it seems to take about four minutes to boot and requires ludicrous resources for minimal if any visual improvements, not to mention all the fun DRM and so on.
00:25 <****> it like XP with more ugly and annoying added, as far as I could tell.
00:26 <****> I just wish Wine would hurry up and finish already.
00:26 <****> xp for the win
00:26 * Simetrical should contribute to Wine, but is more familiar with scripting and is too lazy to learn how to actually program properly in C, use debuggers, etc.
00:28 <****> only a couple of apps keep me on windaz, 3d solid modeler is one
00:28 <****> ebergen: sort of like an implanted chemotherapy distribution unit for life, rather than just cutting that malodorous tumor out and being done with it.
00:28 <****> hahaha
00:29 <****> playforsure is the only thing keeping me near windows
00:29 <****> ugh
00:29 <****> servers are so expensive :(
00:29 <****> not really
00:29 <****> running servers is more expensive
00:33 <****> I'm already paying $150/month for my dedicated server with a Xeon 3040 Dualcore CPU, 3000GB/monthly bandwidth and 150GB 7200RPM drive
00:33 <****> ouch
00:33 <****> but clearly that drive is slowing down MySQL :)
00:33 <****> I pay $515/mo for a half rack
00:33 <****> all the bandwidth you can eat?
00:33 <****> ebergen, owned or rented?
00:34 <****> well we rent the rack and own the hardware
00:34 <****> and do you rent the servers or are you colo'ing :)
00:34 <****> ahh
00:34 <****> ebergen, right, you own the hardware.
00:34 <****> If you rent the hardware, prices are considerably steeper.
Total 3 pages. You are browsing page 1/3.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last