| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> format is innodb
<0> shouldn't this operation be blindingly fast even on a table of millions of rows?
<0> or maybe there is a fundamental performance problem with compound keys?
<1> no inserts with indexes cannot be "blindingly fast"
<2> it has to do with cache hit rates
<2> what is your innodb_buffer_pool_size?
<2> and is this the primary key?
<3> 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
<0> 1GB buffer pool size
<0> there is no primary key
<0> because the compound key is not unique
<0> there is only 1 key
<4> 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?
<2> okay, so it is a hidden primary key
<0> yes
<0> is that the problem?
<2> not neccesarily
<2> how are you inserting data?
<0> table is super simple: int1, int2, int3, int4, int5, key(int1,int2)
<0> i'm doing multi-inserts
<2> how many rows per insert?
<3> what is the command/function to use to convert "Fri, 10 Feb 2006 11:21:00 GMT" to a unix timestamp ?
<0> i've played around to get the fastest i can get
<5> CarlH, Man.. I already told you the function and sent you the link to the documentation
<2> and are you wrapping multiple ones in transactions?
<0> but its around letsee 1000
<0> i've tried 1000->5000
<2> yea, it won't make too big of a difference
<0> is there any point if i'm already inserting in batchers of 1000->5000 rows?
<3> exonic: str_to_date('Fri, 10 Feb 2006 11:21:00 GMT', get_format(date, 'usa')); --- returns NULL
<0> batches
<2> could make a difference
<2> or for the duration of the load you could set innodb_flush_log_at_trx_commit = 0
<6> 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?
<7> exonic: http://rafb.net/paste/results/LM8nEy86.html
<7> exonic: Try that one.
<3> what is wrong with the above query ?
<2> also how big are your log files?
<8> what permissions does a user need to have in order to be able to "create temporary table"?
<5> Xgc, awesome
<9> Brice, What error are they getting?
<7> exonic: Nice. You're welcome.
<5> XG thx a ton
<6> will, as far as i know: syntax near '
<6> 'collate latin1_general_ci NOT NULL, `config_value`
<6> '
<6> sorry about the multi-line there
<10> hello
<9> Most likely they are running MySQL <4.1
<11> Brice: yes better for #mysql
<6> zircu, ;)
<10> is it possible that the only numeric format that i can use for a column is decimal???!!!!!
<6> will, that's what I'm thinking
<10> if i user float or double... the myodbc returns me strange values
<6> is there a way to create dumpfiles that include important fields properties (like auto_increment, etc) that are distributed?
<10> a float(4,2) the mysql console return 12.61, the my odbc returns 12.61000001
<7> 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.
<6> err, suitable for distribution
<10> Xgc: i think it's a myodbc problem
<7> sal: Could be.
<10> i'm using myodbc because i'm developing with vb6
<10> it ****s
<7> sal: That's not an error/problem.
<10> Xgc: what happen if i only use decimal?
<10> Xgc: no? and then wat is it?
<7> sal: That looks like round-off in/by your local language.
<3> 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
<12> 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?
<7> 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.
<10> hmmm
<7> sal: If you force the SQL to return a string/varchar and not a float, you'll probably not see this behavior.
<10> Xgc: i did.... adding a format() in the query
<7> sal: Show the SQL. I'm curious.
<7> sal: and you read it via the API as a string?
<13> 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...
<13> kind of off topic :(
<14> If I want to embed a ' in a SQL command, (like VALUES('I'm a contraction user') would \' be the correct syntax?
<1> CarlH the format does not match the date string
<10> Xgc: select replace(replace(replace(format(field_in, 2),'.'':'),',','.'),':',',') as field_out from table
<3> achivist: Ahh thank you, what format should I use?
<10> xgc: hehehe
<7> TJNII: 'That''s correct' ... 'That\'s correct'
<3> if you know off hand
<14> ty
<10> a little bit complicated
<7> sal: What's the type of field_in?
<10> float(4,2)
<8> what permissions does a user need to be able to 'create temporary table'?
<9> I think just CREATE
<8> nope, i have a user who i 'GRANT ALL' ed to, still is unable to create temporary table
<9> Error message?
<8> standard "Access Denied"
<15> erm , who was helping me earlier or does this chan log sessions?
<15> Charbal u there?
<9> roo9, What does the docs say?
<16> chrisx2: What's up?
<15> erm i need help again my sql hehe
<17> does anyone else find it amusing to type "/join mysql" in IRC?
<18> heh
<15> what did i need to type to set the default
<8> will: i'm pouring through them now
<16> chrisx2: --defaults-file?
<8> will: I see a "Create" privlidge, i don't see any called create temporary though
<15> yeh
<15> where was the file i needed to add
<15> Charbal that doesnt work lolz
<16> 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
<19> how do I change a table that is read-only to writeable?
<15> so what did i do:$ hehe
<15> /etc/mysql/my.cnf /etc/my.cnf
<15> what was the first bit
<16> chrisx2: ln -s
<7> sal: Did you try SELECT field1*1000000 FROM table1; To see what the data looks like beyond the displayed fraction?
<20> hello
<20> 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?
<18> yes just make sure mysql isn't writing to them when you copy
<21> !m spuds mysqldump
<22> spuds: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<1> spuds yes for myisam, use mysqldump if innodb as well
<15> Charbal u there mate?
<16> chrisx2: Yeah
<15> are u sure it wat /etc/mysql/my.cnf ?
<15> *was
<16> chrisx2: "11:55 <16> Though it would appear to be a bug in the package. ln -s /etc/mysql/my.cnf /etc/my.cnf"
<16> chrisx2: And you said it worked after that.
<15> yea hm
<15> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<15> again
<15> :S
<15> a
<15> ah its not there..
<15> can i paste error?
<7> Use the pastebin.
<15> pm ChaosEngine
<23> Hi every 1
<20> archivist, when my mysqldatabase gets corrupted or anything. Can I just copy the backup directory with the files in it?
<23> What tool/app could you suggest me to create/alter/execute stored proc in mysql 5.X ?
<16> chrisx2: Take a look at the syslog... tail /var/log/syslog
<23> Lost all hope with mysqlnavigator and phpmyadmin. Both failed with executing even simplest stored procs
<15> can i paste that?
<15> pm ChaosEngine
<23> BTW: Linux would be my choice of an OS
<15> * Charbal
<16> chrisx2: Looking at it now... just a sec
<15> okay
<1> spuds for best backups use mysqldump because innodb is held in ibdata etc files not in the subdirs
<23> chrisx2: 'pm' ? Sorry, don't get that ?
<15> nm didnt press tab right lolz
<15> 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
|
|