#mysql
13 October 2007
Total 15 pages. You are browsing page 1/15.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sat Oct 13 00:00:13 2007
00:00 <****> you could use a subselect. :)
00:00 <****>?
00:01 <****> if you'd do it manually and the queries are quite complex ..
00:02 <****> ie when the script asks for queries as input ;)
00:02 <****> if the number of 20 is fixed, it is not that bad. if you however do a seperate query for each row in a table, that is bad
00:03 <****> I am trying to mysqldump a database that contains views but it gives errors, and according to a co-worker mysqldump is not yet compatible with views... is this true?
00:03 <****> thinkmassive: what version?
00:04 <****> actually nevermind... i haven't had problems dumping databases with views
00:04 <****> 5.0.45
00:04 <****> hmm
00:04 <****> he suggests I dump only the tables, then each view individually, but I can't figure out how to do this
00:05 <****> is there a way to specify only tables without specifying each table individually?
00:06 <****> thinkmassive: mysqldump has some 'exclude table' option
00:07 <****> --ignore-table
00:07 <****> bradmw: thanks, I'll look into that
00:10 <****> cool, that worked to dump all but the view that was giving a problem
00:17 <****> Does anyone know some recommendable tool for OSX to design ERD's with? Some UML tools?
00:17 <****> Does anyone know some recommendable tool for OSX to design ERD's with? Some UML tools?
00:17 <****> no and no
00:18 <****> netsplits suck pretty badly
00:18 <****> i'm back
00:19 <****> Shankysv87: Make a donation then!
00:19 <****> Then you won't have any
00:19 <****> seekwill = liar
00:19 <****> No no
00:19 <****> whateva!
00:19 <****> You get access to their "special" server.
00:19 <****> You'll see everyone else split, but you won't
00:19 <****> ok with my apache being setup with a different port then the typical http port 80, will that effect my localhost db location?
00:19 <****> En
00:20 <****> No
00:20 <****> Oh
00:20 <****> damn
00:25 <****> mysqldump dumps my entire db except for a single view, giving the error "...references invalid table(s), col(s), or f'n(s) or definer/invoker of view lack rights to use them" so can anyone recommend a way to export that view by itself? (I tried --table the_problematic_view_table and got the error again)
00:25 <****> Shankysv87, Unless you have a firewall (host or network) between the apache and SQL server, there should be no difference
00:26 <****> thinkmassive, Do you want the row data?
00:27 <****> prolific: I'm not even sure what's in it so I'll take what I can get right now
00:28 <****> Anybody know how one could repair innodb tables if MySQL crashes because of it?
00:28 <****> thinkmassive, If there's only one problematic view, why not show create?
00:28 <****> is there something like myisamchk for innodb?
00:28 <****> I don't use views, though. So take my advice lightly
00:29 <****> well I've just been introduced to them today heh
00:29 <****> prolific: what do you mean "show create"?
00:30 <****> SHOW CREATE VIEW table_view
00:30 <****> this sucks, there's 13 views and all but one backed up fine, which leads me to wonder if it's even used in the application
00:31 <****> prolific: thanks, that sounds like it should work
00:31 <****> np
00:34 <****> Anybody know how one could repair innodb tables if MySQL crashes because of it?
00:35 <****> Are you sure it needs to be repaired?
00:35 <****> seekwill: mysql keeps restarting itself
00:35 <****> seekwill: it's like core-dumping or something...
00:36 <****> What does the log say?
00:36 <****> Maybe it's a different problem?
00:36 <****> let me pastebin, one sec
00:37 <****> In between queries, is there anything I should execute other than reset query cache to make sure execution time stays accurate
00:37 <****> http://pastebin.ca/734698
00:38 <****> jcooke: There is a flag to not cache
00:38 <****> seekwill, right, main reason I'm asking though is that these queries are showing up in our slow logs, and when I run them the first time they can take up to a minute
00:38 <****> but each execution after that is around a second
00:39 <****> jcooke: Do you know the criteria used to be logged in the slow query log?
00:39 <****> yes
00:40 <****> purpoze: It's not an InnoDB error. Read that pastebin and pickup on the tips it says
00:40 <****> purpoze: How did you install MySQL?
00:40 <****> just wondering why after the initial execution, the query runs much faster, even with query cache being reset
00:40 <****> Distro
00:40 <****> if it's disk caching or what
00:40 <****> jcooke: There are more than one cache ;)
00:41 <****> seekwill, right, that's what I'm asking, what else needs to be reset to get a real world result each time
00:41 <****> That won't be real world if you have to artifically reset stuff...
00:41 <****> these queries only run once per day
00:41 <****> Look at it from a bigger picture
00:41 <****> seekwill: not sure, this was setup by another guy
00:41 <****> Yeah, so you don't have to worry about it
00:42 <****> purpoze: Find out :) What OS/Distro?
00:42 <****> very old, redhat 7.3
00:42 <****> Do you know what MySQL version?
00:42 <****> seekwill, but if i'm optimizing the query, I'd like to see what the execution time will be when it runs
00:43 <****> eh, valid point
00:43 <****> What is the query?
00:43 <****> http://pastebin.ca/734390 the second one there
00:44 <****> mysql 4.0.8 version
00:44 <****> Seriously?
00:44 <****> geez
00:44 <****> i trued running another mysql 5.x version from mysql.com
00:44 <****> downloaded from binaries
00:44 <****> and ran it, and it crashed w/ same errors
00:45 <****> but this time with tons of '0's
00:45 <****> i think it's a InnoDB error
00:45 <****> I have to pack. I don't have time to help...
00:45 <****> ok, but do u know a innodb command line repair tool, like myisamchk ?
00:45 <****> or any possible document on how to repair innodb databases ?
00:45 <****> InnoDB doesn't get corrupted. If it does, you're really really screwed
00:45 <****> hehe
00:46 <****> where can i read mroe on InnoDB Engine ?
00:46 <****> i realized i have a lack of understanding of this engine
00:46 <****> dev.mysql.com/docs perhaps. I think there's an INTERNALs docpage on it
00:46 <****> I don't know if that's going to help you or not.
00:46 <****> You're better off restoring from a backup
00:46 <****> yeah, this guy makes no backups
Total 15 pages. You are browsing page 1/15.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last