IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[00:17]<rrse>hello all
[00:17]<rrse>is there a date_format() for RFC-822 ?
[00:21]<sgjdns>you can almost get it with %a, %d %b %Y %H:%i:%s
[00:21]<sgjdns>but that's missing the timezone
[00:22]<zzaxyvysv>Munger probably time to upgrade your mysql, what version are you attempting to load onto
[00:23]<muzznz>Sorry. Somebody just responded to me and I clicked the close box by mistake when switching tabs. Can you please repeat :-)
[00:23]<zzaxyvysv>Munger probably time to upgrade your mysql, what version are you attempting to load onto
[00:24]<muzznz>4.1.14
[00:25]<muzznz>Pretty recent
[00:26]<muzznz>mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 5.1
[00:27]<zzaxyvysv>somebody had the same prob the other day there may be a setting to set longer key lengths
[00:28]<rjjmy_>is it possible to follow a redirect with ajax?
[00:28]<rjjmy_>asdf
[00:28]<rjjmy_>sorry.-) wrong channe
[00:28]<dxdffdnz>Now that's on topic.
[00:28]<zzaxyvysv>goodi_, silly question for #mysql
[00:28]<rjjmy_>l
[00:28]<rjjmy_>yes, sorry
[00:31]<muzznz>archivist. The solution seems to be to set the default character set for the database to latin1, but I have no idea how to do that
[00:32]<muzznz>utf character sets take twice as many bytes
[00:34]<zzaxyvysv>Munger http://dev.mysql.com/doc/refman/4.1/en/localization.html
[00:39]<muzznz>archivist. That still doesn't make a lot of sense to me. I am just trying to install a package. I could change the line in the script where it creates the database, if I knew what to change it to. that page is dealing with mysql defaults
[00:44]<muzznz>I just added DEFAULT CHARSET=latin1 tot he CREATE DATABASE line, and it woked, although it set the collation to latin1_swedish_ci for all the fields !!!!
[00:44]<muzznz>I ain't swedish :-)
[00:46]<dxdffdnz>YOu are now.
[00:46]<jspzdgzjg>du ar ny :-)
[00:48]<muzznz>I'm really not trying to be lazy, but please just tell me what i need to add to the CREATE DATABASE command to set a latin1 english character set.
[00:48]<mjzvys_czuuuf>http://www.avemetal.com ! :)
[00:48]<dxdffdnz>Unless your server has its defaults changed you should not have to add anything.
[00:49]<dxdffdnz>!kick Mortis_kruuul We don't care.
[00:49]<muzznz>I never changed the defaults.
[00:50]<muzznz>I never even looked at character sets before. I just got errors trying to configure a package and have wasted 12 hours trying to fix it
[00:51]<fuzgrrnbrrc>amigos, re: http://sheeri.com/archives/81 ; I have posted a comment. let's see how she responds...
[00:51]<fuzgrrnbrrc>PASTE:
[00:51]<fuzgrrnbrrc>Your comment is awaiting moderation.
[00:51]<fuzgrrnbrrc>May 12th, 2006 at 5:02 pm
[00:51]<fuzgrrnbrrc>Hi,
[00:51]<fuzgrrnbrrc>I read this post via planetmysql but can you please explain why it?s so clever, as I don?t ?get it?. If you are logging queries, I don?t see why you?d need to SELECT ??; and if you?re not logging queries, how would you see the string unless you retrieved the result of the query that you just executed (the text of which you already have)?
[00:52]<fuzgrrnbrrc>somebody mentioned that it could be handy during a batch job piped to mysql client.
[00:52]<fuzgrrnbrrc>does that make sense to anyone?
[00:52]<dxdffdnz>Yes
[00:52]<fuzgranbjd>I can sorta see the use of that.
[00:53]<fuzgranbjd>it was likened to debugging by prints, which I do a lot anyway :)
[00:54]<muzznz>If my default charset is set to UTF8, I have no idea why. I don't know what i will break if I change it. I would feel safer just creating this 1 database with latin1
[01:11]<rgvagyaaufya>please i need locate a simple full example for mysql connector for VB.net only select intruccion, do you help me? please
[01:13]<dxdffdnz>www.vbmysql.com
[01:17]<rgvagyaaufya>mhillyer: ok thanks i go it
[01:25]<ag2n>hello, is it possible to show only the 20 latest characters in an mysql table?
[01:26]<rgvagyaaufya>char(45)
[01:27]<rgvagyaaufya>sorry
[01:27]<dxdffdnz>latest characters?
[01:27]<mzvzvxgzgmzjym>help. Failed to execute SQL: UPDATE forum_forums SET title = "hmm2", desc = "test", permissions = 2 WHERE id=7 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc = "test", permissions = 2 WHERE id=7' at line 1
[01:27]<zzaxyvysv>20 chrs in a field or rows in a table
[01:28]<jd>DataTheAndroid, desc is a mysql word
[01:28]<ygvysj>!m DataTheAndroid keywords
[01:28]<sql>DataTheAndroid: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
[01:28]<jd>`desc`="test"
[01:28]<dxdffdnz>so the right-most 20 characters?
[01:28]<ag2n>i guess it would be 20 chrs in a field
[01:28]<mzvzvxgzgmzjym>ah thanks
[01:29]<zzaxyvysv>!m Anbe string functions
[01:29]<sql>Anbe: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
[01:29]<dxdffdnz>You want the right-most 20 characters of a field Anbe?
[01:29]<sajjqdq>man 5.0.21 keeps giving me these "table blah is full" errors
[01:29]<dzzygg>so empty it
[01:29]<sajjqdq>its not full
[01:29]<dzzygg>so don't empty it
[01:29]<dzzygg>have you tried running repair table on it?
[01:30]<zzaxyvysv>give it more space
[01:30]<sajjqdq>innodb file per table should grow on its own
[01:30]<dzzygg>give it some space, let it breathe
[01:30]<zzaxyvysv>allow auto extend
[01:30]<sajjqdq>no auto extend needed with file per table
[01:31]<dxdffdnz>So how do you know it is not full?
[01:31]<sajjqdq>its supposed to be able to grow pretty much as big as it wants
[01:32]<dxdffdnz>You call that an answer. How do you know it is not full?
[01:32]<dxdffdnz>Define full, define its current state.
[01:32]<sajjqdq>after a few minutes i can add more data
[01:32]<sajjqdq>a
[01:32]<dxdffdnz>Ok then, that will suffice.
[01:33]<dxdffdnz>How many rows does it have, how large is the tablespace file?
[01:33]<sajjqdq>on the master its a 30gb file
[01:33]<sajjqdq>i'd guess probably 80 million rows
[01:35]<dxdffdnz>Does it only happen during certain queries, certain loads?
[01:36]<\djgsvnz\>hey if you have a recursive procedure, and with each 'loop' you print out using SELECT ..is it somehow possible to make the final output look as if its one result with multiple rows instead of multiple results with 1 row each?
[01:36]<\djgsvnz\>http://pastebin.com/714336 // thats the output from calling my procedure, i want to make it as if its a single result
[01:37]<dxdffdnz>\monster\: Instead insert into a temp table, then finish the proc with a SELECT * from the temp table.
[01:37]<sajjqdq>mhillyer: http://bugs.mysql.com/bug.php?id=18828
[01:37]<\djgsvnz\>how efficient is that
[01:37]<dxdffdnz>I'd say as efficient as what you are doing now ;)
[01:37]<\djgsvnz\>hmm k
[01:38]<\djgsvnz\>will try
[01:38]<dxdffdnz>scooby2: Do you have that level of transactions?
[01:38]<sajjqdq>how the heck do i check?
[01:38]<dxdffdnz>Well what are your load levels like? How many concurrent connections?
[01:39]<sajjqdq>around 100 concurrent connections
[01:40]<sajjqdq>Number of rows inserted 2046604, updated 2108481, deleted 0, read 2108483
[01:40]<sajjqdq>11.54 inserts/s, 19.42 updates/s, 0.00 deletes/s, 19.44 reads/s

Back to #mysql
Or go to some related logs:
#php
#gentoo
#iptables
#gentoo
#css