| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> snoyes: Ah, I see. Thanks. In a PM with mercestes, I found that "show tables", etc. won't work as queries to the API from, say PHP. You can only use those in the mysql CLI. But it's good to know that I can do it from the API in >=5 though.
<1> php has some functions like mysql_list_tables and mysql_list_fields
<2> Anyone know what might cause this. I read that it may be to do with the default character set, but don't know how to fix it .... http://munger.pastebin.com/714230
<3> hello all
<3> is there a date_format() for RFC-822 ?
<1> you can almost get it with %a, %d %b %Y %H:%i:%s
<1> but that's missing the timezone
<4> Munger probably time to upgrade your mysql, what version are you attempting to load onto
<2> Sorry. Somebody just responded to me and I clicked the close box by mistake when switching tabs. Can you please repeat :-)
<4> Munger probably time to upgrade your mysql, what version are you attempting to load onto
<2> 4.1.14
<2> Pretty recent
<2> mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 5.1
<4> somebody had the same prob the other day there may be a setting to set longer key lengths
<5> is it possible to follow a redirect with ajax?
<5> asdf
<5> sorry.-) wrong channe
<6> Now that's on topic.
<4> goodi_, silly question for #mysql
<5> l
<5> yes, sorry
<2> 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
<2> utf character sets take twice as many bytes
<4> Munger http://dev.mysql.com/doc/refman/4.1/en/localization.html
<2> 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
<2> 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 !!!!
<2> I ain't swedish :-)
<6> YOu are now.
<7> du ar ny :-)
<2> 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.
<8> http://www.avemetal.com ! :)
<6> Unless your server has its defaults changed you should not have to add anything.
<6> !kick Mortis_kruuul We don't care.
<2> I never changed the defaults.
<2> 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
<9> amigos, re: http://sheeri.com/archives/81 ; I have posted a comment. let's see how she responds...
<9> PASTE:
<9> Your comment is awaiting moderation.
<9> May 12th, 2006 at 5:02 pm
<9> Hi,
<9> 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)?
<9> somebody mentioned that it could be handy during a batch job piped to mysql client.
<9> does that make sense to anyone?
<6> Yes
<10> I can sorta see the use of that.
<10> it was likened to debugging by prints, which I do a lot anyway :)
<2> 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
<11> please i need locate a simple full example for mysql connector for VB.net only select intruccion, do you help me? please
<6> www.vbmysql.com
<11> mhillyer: ok thanks i go it
<12> hello, is it possible to show only the 20 latest characters in an mysql table?
<11> char(45)
<11> sorry
<6> latest characters?
<13> 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
<4> 20 chrs in a field or rows in a table
<14> DataTheAndroid, desc is a mysql word
<15> !m DataTheAndroid keywords
<16> DataTheAndroid: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<14> `desc`="test"
<6> so the right-most 20 characters?
<12> i guess it would be 20 chrs in a field
<13> ah thanks
<4> !m Anbe string functions
<16> Anbe: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<6> You want the right-most 20 characters of a field Anbe?
<17> man 5.0.21 keeps giving me these "table blah is full" errors
<18> so empty it
<17> its not full
<18> so don't empty it
<18> have you tried running repair table on it?
<4> give it more space
<17> innodb file per table should grow on its own
<18> give it some space, let it breathe
<4> allow auto extend
<17> no auto extend needed with file per table
<6> So how do you know it is not full?
<17> its supposed to be able to grow pretty much as big as it wants
<6> You call that an answer. How do you know it is not full?
<6> Define full, define its current state.
<17> after a few minutes i can add more data
<17> a
<6> Ok then, that will suffice.
<6> How many rows does it have, how large is the tablespace file?
<17> on the master its a 30gb file
<17> i'd guess probably 80 million rows
<6> Does it only happen during certain queries, certain loads?
<19> 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?
<19> http://pastebin.com/714336 // thats the output from calling my procedure, i want to make it as if its a single result
<6> \monster\: Instead insert into a temp table, then finish the proc with a SELECT * from the temp table.
<17> mhillyer: http://bugs.mysql.com/bug.php?id=18828
<19> how efficient is that
<6> I'd say as efficient as what you are doing now ;)
<19> hmm k
<19> will try
<6> scooby2: Do you have that level of transactions?
<17> how the heck do i check?
<6> Well what are your load levels like? How many concurrent connections?
<17> around 100 concurrent connections
<17> Number of rows inserted 2046604, updated 2108481, deleted 0, read 2108483
<17> 11.54 inserts/s, 19.42 updates/s, 0.00 deletes/s, 19.44 reads/s
<17> thats for the last 6 hours
<6> Well I don't think they could each be running 10 transactions at once. Hmm. Therion any experience with this scenario?
<17> Number of rows inserted 2888360, updated 2736302, deleted 238000, read 632568329
<17> 96.09 inserts/s, 107.44 updates/s, 294.11 deletes/s, 40138.97 reads/s
<17> the slave
<20> hey is there a mysql function to limit repeats of a returned value...say X, Y, Z are stored 10 times each in a db, but I only want to display them once each, how would I do that?
<6> Which one is having the problem?
<6> Burian: You could GROUP BY the column.
<17> both are giving that table is full error
<6> Hmm, same statements cause the error on each?
<17> yeah since it replicates over
<6> Ok, so not Statement A causeing the problem on the master but statement D on the slave.
<20> mhillyer: Thanks that did the trick
<6> argh, the wife calls and the inlaws are coming for dinner. scooby2 I'm sorry but I have to leave you to the mercy of others.
<4> is it the main tablespace because of "Note: InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there."
<17> archivist: now thats an idea
<17> i bet thats it
<17> default is ibdata1:10M:autoextend:max:128M
<17> so maybe that is hitting the max at 128M
<4> found that snippet here http://dev.mysql.com/doc/refman/4.1/en/multiple-tablespaces.html
<17> you are the bomb
<21> CREATE TABLE '05122006183520' ( 'IMGNAME' TEXT NOT NULL , 'DATE' TEXT NOT NULL , 'ID' INT NOT NULL AUTO_INCREMENT PRIMARY KEY); | keeps failing with a syntax error... But I don't see it.
<17> now how big do i need to make it i wonder
<22> Servo888: wrong quotes... use `
<22> i would avoid a tablename like that though
<21> zircu, curious, why?/
<17> archivist: how do I go about making that bigger?:) If it contains data already I cant exactly just wack it and stop/start with it set to 2gb.
<21> zircu, yah that worked, ` isntead of '. hehe I didn't even notice that =\
<22> Servo888: what does that number mean? is it an archive date or something?
<21> zircu, yes it's based on date.
<4> dunno the old 128m is just a limit so anew limit should be ok
<22> Servo888: the name isn't very obvious on what it is for
<21> zircu, Month, Day, Year, Hours, Min, Second.
<17> archivist: ahh ok
<4> methink (never tried it)
<23> is it a bad idea to put whole files in a database?
<23> tens of thousands of them?
<22> palomer: generally, yeah it is a bad idea
<23> what if all the files are less than 10k?
<4> what sort of files
<15> Is there a good reason to do so? Is it searchable content?
<22> what are the files used for?
<23> well, the users are going to search for the files
<23> and then I'm going to display the results
<15> by name or contents?
<23> then he's going to download the files
Return to
#mysql
or
Go to some related
logs:
debian rssh execv
connect remote mysql-server4
gentoo acpi=off network doesn't work anymore
install opengl for ubuntu
if __FILE__ == $0 $0 is
3com 3c905cx fc5 driver
#lgp
openning djvu files
#math
#gaim
|
|