#mysql
21 October 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last
22:29 <****> Most importantly, can you reproduce it in your dev env?
22:30 <****> MarkR42 there are other 3 processes the same
22:30 <****> and around 60 marked as "sleep"
22:30 <****> 2 as query
22:31 <****> i am not sure i can reproduce it, it is a torrent tracker
22:31 <****> gopp: as a general rule if it soulds like you copied it out of a textbook we won't help you
22:31 <****> sounds too
22:32 <****> Kuki1: In your develpoment environmen you should engineer a load testing system which utilises the DB in the same way as production if possible
22:32 <****> This will enable you to see exactly what's happening and try out tweaks safely
22:32 <****> You could of course disable delayed inserts, but that might cause more problems itself
22:33 <****> If the server is very busy, other things will be blocking the delayed inserts, for a long time potentially
22:33 <****> yeah it is pretty busy
22:33 <****> could someone help me make a small query
22:34 <****> Does anyone know of a good application with which I can model my tables?
22:34 <****> [SilverFox], ask your question and we'll see.
22:34 <****> preferably in UML (graphically)
22:34 <****> got 3 colums. account, data (want index 34) and name. But I'm unsure how to call info from a spit like index 34..
22:34 <****> Kuki1: You really should consult the developers to find out why they used delayed inserts and what they were trying to achieve, before turning them off unilaterally or making any other configuration change.
22:35 <****> Moreover, any such configuration change should go through some QA process, like, you should at least test that the application behaves correctly, and if possible do performance testing
22:35 <****> hi, i am running 5.0.30, and i am having an issue, that might have been solved in 5.0.45, so i downloaded the binaries for 5.0.45, but i don't know how to run them without doing a full install, is there a quick to run them
22:35 <****> [SilverFox], maybe you want: SELECT * FROM put your table name here WHERE data=34;
22:36 <****> ok thanks
22:37 <****> thanks mark
22:41 <****> blobaugh sucks I'm glad he isn't here
22:41 <****> oh we better stop talking about him
22:42 <****> yeah, that kids a turd
22:43 <****> hehe
22:43 * chadmaynard is gone
22:55 <****> ecvening all
22:55 <****> anyone know what the CREATE USER syntax for mysql 4.1 was ?!?
22:56 <****> SleepingSloth, GRANT could create users
22:56 <****> HarrisonF - brilliant... has the grant syntax changed much then?
22:57 <****> no
23:00 <****> cheers - sorted =)
23:01 <****> is there any way to start a repair on all tables in all databases?
23:01 <****> had a server crash and an hour after, mysql got stuck at 100%
23:02 <****> I would backup all data I could and try a fsck first
23:03 <****> can i run fsck in regular runlevel?
23:04 <****> i don't have time to take backup first :p
23:04 <****> if something happens i'll get it from last night's backup :p
23:04 <****> you'll need it to do at boot time, I think, so you have your drive unmounted
23:05 <****> running mysqlcheck :p
23:05 <****> --all-databses
23:06 <****> it's mostly webstatistic tables that are fuxed
23:32 <****> Any idea why my "mysqlimport" might be rejecting some table rows even though they are identical data ?
23:32 <****> I've checked field seperators, possible hidden special characters, illegal data types, all to no avail :(
23:34 <****> Only thing I can think of ... eg SMALLINT(6) might need exactly 6 numerals ? But lees should be OK .. right ?
23:34 <****> For integer types, the number following it is used for output formatting only, and doesn't affect the range of valid input data.
23:42 <****> Simetrical .. thought so :)
23:42 <****> Does mysql tell me somewhere why it's rejecting the rows, or is just a count ?
23:45 <****> grobda24: warnings
23:46 <****> I can find a count of warnings.
23:46 <****> show warnings;
23:48 * chadmaynard just realized he completely screwed up his fft
23:48 <****> k ... thanks :)
23:50 <****> grobda24: a signed smallint can't hold 999999
23:50 <****> it can't even hold 32768
23:50 <****> unsigned holds 0 - 65535
23:52 <****> I comparing an imported row and a row that won't import. they match exactly except some SMALLINT fields have less numerals that the defined length.
23:53 <****> grobda24: the defined length is what you don't understand i think
23:53 <****> forget defined length
23:53 <****> it means nothing
23:53 <****> Anyway, I might have it. Just trying the same import on a newer version of mSQL instead of my ancient local version :/
23:53 <****> we should just deprecate it
23:53 <****> domas: please
23:54 <****> k
23:54 <****> Hi, is there a way to input information into a database without using the command line? (e.g. spreadsheet)
23:54 <****> jftsang: csv
23:55 <****> jftsang: ODBC drivers
23:55 <****> jftsang: then you can connect with excel or access =)
23:55 <****> jftsang: or you can use Query Browser
23:55 <****> domas: how do you do that exactly
23:55 <****> or you can ..
23:55 <****> use any other gui tool
23:56 <****> how do i use ODBC...
23:56 <****> nevermind
23:56 <****> I'm going to sleep
23:56 <****> work tomorrow
23:56 <****> !
23:56 <****> ;-)
23:57 <****> chadmaynard: where are the csv files, or how do i convert into csv
23:57 <****> jftsang: with excel?
23:58 <****> chadmaynard: i know how to use excel for CSV; how do i put it into mysql
23:58 <****> or otherwise usable for phping
23:59 <****> jftsang: load data infile can take csv
23:59 <****> chadmaynard: thanks very much, does the program assume the first line to be field headers?
--- Log closed Mon Oct 22 00:00:37 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last