| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<geoff_> format is innodb
<geoff_> shouldn't this operation be blindingly fast even on a table of millions of rows?
<geoff_> or maybe there is a fundamental performance problem with compound keys?
<archivist> no inserts with indexes cannot be "blindingly fast"
<HarrisonF> it has to do with cache hit rates
<HarrisonF> what is your innodb_buffer_pool_size?
<HarrisonF> and is this the primary key?
<CarlH> I have a column that is varchar 50 that stores strings of dates -- like "Fri, 10 Feb 2006 11:21:00 GMT" --- I am trying to sort by that column
<geoff_> 1GB buffer pool size
<geoff_> there is no primary key
<geoff_> because the compound key is not unique
<geoff_> there is only 1 key
<yanimax> I'm getting the error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13), mysql is running and the sock file exists... I'm using dapper and just upgraded to mysql 5, does anyone know why?
<HarrisonF> okay, so it is a hidden primary key
<geoff_> yes
<geoff_> is that the problem?
<HarrisonF> not neccesarily
<HarrisonF> how are you inserting data?
<geoff_> table is super simple: int1, int2, int3, int4, int5, key(int1,int2)
<geoff_> i'm doing multi-inserts
<HarrisonF> how many rows per insert?
<CarlH> what is the command/function to use to convert "Fri, 10 Feb 2006 11:21:00 GMT" to a unix timestamp ?
<geoff_> i've played around to get the fastest i can get
<exonic> CarlH, Man.. I already told you the function and sent you the link to the documentation
<HarrisonF> and are you wrapping multiple ones in transactions?
<geoff_> but its around letsee 1000
<geoff_> i've tried 1000->5000
<HarrisonF> yea, it won't make too big of a difference
<geoff_> is there any point if i'm already inserting in batchers of 1000->5000 rows?
<CarlH> exonic: str_to_date('Fri, 10 Feb 2006 11:21:00 GMT', get_format(date, 'usa')); --- returns NULL
<geoff_> batches
<HarrisonF> could make a difference
<HarrisonF> or for the duration of the load you could set innodb_flush_log_at_trx_commit = 0
<Brice> In the installation procedure of my application, I process a MySQL dump file to create initial DB schema. Some users are complaing that it's resulting in a syntax error. I've pasted the query, along w/ a users error to http://pastebin.com/560245 .. unfortuanetley, I'm unable to repeat this error.. so maybe one of you will see a problem w/ the query?
<Xgc> exonic: http://rafb.net/paste/results/LM8nEy86.html
<Xgc> exonic: Try that one.
<CarlH> what is wrong with the above query ?
<HarrisonF> also how big are your log files?
<roo9> what permissions does a user need to have in order to be able to "create temporary table"?
<exonic> Xgc, awesome
<will> Brice, What error are they getting?
<Xgc> exonic: Nice. You're welcome.
<exonic> XG thx a ton
<Brice> will, as far as i know: syntax near '
<Brice> 'collate latin1_general_ci NOT NULL, `config_value`
<Brice> '
<Brice> sorry about the multi-line there
<sal> hello
<will> Most likely they are running MySQL <4.1
<zircu> Brice: yes better for #mysql
<Brice> zircu, ;)
<sal> is it possible that the only numeric format that i can use for a column is decimal???!!!!!
<Brice> will, that's what I'm thinking
<sal> if i user float or double... the myodbc returns me strange values
<Brice> is there a way to create dumpfiles that include important fields properties (like auto_increment, etc) that are distributed?
<sal> a float(4,2) the mysql console return 12.61, the my odbc returns 12.61000001
<Xgc> sal: Depends on the database. Strange values would suggest you aren't using the API correctly with php (or whatever your language is). This doesn't sound like a DB issue.
<Brice> err, suitable for distribution
<sal> Xgc: i think it's a myodbc problem
<Xgc> sal: Could be.
<sal> i'm using myodbc because i'm developing with vb6
<sal> it ****s
<Xgc> sal: That's not an error/problem.
<sal> Xgc: what happen if i only use decimal?
<sal> Xgc: no? and then wat is it?
<Xgc> sal: That looks like round-off in/by your local language.
<CarlH> Anyone... str_to_date('Fri, 10 Feb 2006 11:21:00 GMT', get_format(date, 'usa')); --- returns NULL ---- what am I doing wrong? Trying to obtain the timestamp
<Madeye> guys I want to select all records that inserted in the last three days and I'm using 0000-00-00 00:00:00 datetime, any idea?
<Xgc> sal: The error can be hidden by the DB engine/utils, but when you try to store/display a float locally, you are at the mercy of the local language/implementation.
<sal> hmmm
<Xgc> sal: If you force the SQL to return a string/varchar and not a float, you'll probably not see this behavior.
<sal> Xgc: i did.... adding a format() in the query
<Xgc> sal: Show the SQL. I'm curious.
<Xgc> sal: and you read it via the API as a string?
<SkramX> what do you use for b/w||system stats graphs? I have a mysql db which logs in X (minute) increments and want to make graphs of the data...
<SkramX> kind of off topic :(
<TJNII> If I want to embed a ' in a SQL command, (like VALUES('I'm a contraction user') would \' be the correct syntax?
<archivist> CarlH the format does not match the date string
<sal> Xgc: select replace(replace(replace(format(field_in, 2),'.'':'),',','.'),':',',') as field_out from table
<CarlH> achivist: Ahh thank you, what format should I use?
<sal> xgc: hehehe
<Xgc> TJNII: 'That''s correct' ... 'That\'s correct'
<CarlH> if you know off hand
<TJNII> ty
<sal> a little bit complicated
<Xgc> sal: What's the type of field_in?
<sal> float(4,2)
<roo9> what permissions does a user need to be able to 'create temporary table'?
<will> I think just CREATE
<roo9> nope, i have a user who i 'GRANT ALL' ed to, still is unable to create temporary table
<will> Error message?
<roo9> standard "Access Denied"
<chrisx2> erm , who was helping me earlier or does this chan log sessions?
<chrisx2> Charbal u there?
<will> roo9, What does the docs say?
<Charbal> chrisx2: What's up?
<chrisx2> erm i need help again my sql hehe
<IdahoEv> does anyone else find it amusing to type "/join mysql" in IRC?
<firewire> heh
<chrisx2> what did i need to type to set the default
<roo9> will: i'm pouring through them now
<Charbal> chrisx2: --defaults-file?
<roo9> will: I see a "Create" privlidge, i don't see any called create temporary though
<chrisx2> yeh
<chrisx2> where was the file i needed to add
<chrisx2> Charbal that doesnt work lolz
<Charbal> chrisx2: You had a /etc/mysql/my.cnf but the client was looking for a /etc/my.cnf so we created a symlink from the former to the latter which seemed to work
<Peanut3433> how do I change a table that is read-only to writeable?
<chrisx2> so what did i do:$ hehe
<chrisx2> /etc/mysql/my.cnf /etc/my.cnf
<chrisx2> what was the first bit
<Charbal> chrisx2: ln -s
<Xgc> sal: Did you try SELECT field1*1000000 FROM table1; To see what the data looks like beyond the displayed fraction?
<spuds> hello
<spuds> I am using mysql 5.0.18, I have read that I can just copy the .frm, .MYI, and .MYD files to backup a database is this correct?
<firewire> yes just make sure mysql isn't writing to them when you copy
<domas> !m spuds mysqldump
<SQL> spuds: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<archivist> spuds yes for myisam, use mysqldump if innodb as well
<chrisx2> Charbal u there mate?
<Charbal> chrisx2: Yeah
<chrisx2> are u sure it wat /etc/mysql/my.cnf ?
<chrisx2> *was
<Charbal> chrisx2: "11:55 <Charbal> Though it would appear to be a bug in the package. ln -s /etc/mysql/my.cnf /etc/my.cnf"
<Charbal> chrisx2: And you said it worked after that.
<chrisx2> yea hm
<chrisx2> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<chrisx2> again
<chrisx2> :S
<chrisx2> a
<chrisx2> ah its not there..
<chrisx2> can i paste error?
<Xgc> Use the pastebin.
<chrisx2> pm ChaosEngine
<ChaosEngine> Hi every 1
<spuds> archivist, when my mysqldatabase gets corrupted or anything. Can I just copy the backup directory with the files in it?
<ChaosEngine> What tool/app could you suggest me to create/alter/execute stored proc in mysql 5.X ?
<Charbal> chrisx2: Take a look at the syslog... tail /var/log/syslog
<ChaosEngine> Lost all hope with mysqlnavigator and phpmyadmin. Both failed with executing even simplest stored procs
<chrisx2> can i paste that?
<chrisx2> pm ChaosEngine
<ChaosEngine> BTW: Linux would be my choice of an OS
<chrisx2> * Charbal
<Charbal> chrisx2: Looking at it now... just a sec
<chrisx2> okay
<archivist> spuds for best backups use mysqldump because innodb is held in ibdata etc files not in the subdirs
<ChaosEngine> chrisx2: 'pm' ? Sorry, don't get that ?
<chrisx2> nm didnt press tab right lolz
<chrisx2> pm = personal message tho
Return to
#mysql
or
Go to some related
logs:
#math
#linux
qtconfigure
cfdisk: relocation error
#web
#perl
firestarter automatic start on ubuntu
.xpm snow ubuntu
SkepticsRock
via_rhine how to set mac address
|
|
