| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> Wanted
<1> b1n0ry: lol
<2> Therion: I also updated the tables to utf-8, I don't know if that woudl contribute
<1> awormus: yes
<0> heh, forgot to pay the water bill... brb
<2> some tables have 500k rows
<1> awormus: Can slow down queries that are using sorts if it thinks that it may need 3 bytes per character
<3> i have a table with an entry "date date" ... when i insert into the table, how do i make "date" get automagically filled in?
<3> with the current date
<2> Therion: what is the best solution in that case? We have very little utf8 data in the database, probably just the oc***ional or
<1> awormus: latin1 has such characters
<1> awormus: So unless you really have utf8-encoded data outside latin1 set, you could just use the default latin1_swedish_ci collation/charset
<1> awormus: ie: same thing 3.23 was using :)
<2> Therion: we really need it, spent a month transitioning our site, for an upcoming japanese localization project..
<3> how do i fill in the current date into a variable of type "date" with INSERT?
<4> vali_: CURRENT_DATE
<4> !m vali_ CURRENT_DATE
<5> vali_: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<2> Therion: I did a show variables, is there anythign I'm looking for specifically?
<1> awormus: key_buffer_size, innodb_buffer_pool_size (if you use it)... anything ending in _size
<1> awormus: but your utf8 change sounds likely to be a contributing factor
<1> awormus: I am curious if you dumped and reloaded your tables
<1> awormus: or just did a binary upgrade
<1> awormus: If you did not dump/reload and have indexes on char/varchar columns that contain,oh, tabs or carriage returns or linefeeds (ie: whitespace other than "space"), you can cause yourself all sorts of nightmares
<2> We didn't dump and reload, just ran ALTER queries to change the charsets of a couple of the tables
<1> dangerous if you have such columns
<6> If I'm doing a table join on table A and B, is there a way for me to join based on the lowest number in a column of table B? Ie, a join returns multiple rows of table B for each row in table A, but I don't have another table to join with to limit to one row per row in table A.
<1> sort order for such was changed in 4.1
<1> (and some similar changes were made in 5.0, also needing dump/reload)
<2> Therion: but the funny thing is that even queries on tables which aren't UTF8 encoded are going slow
<7> Technology geeks are the laziest people in the world. All they do is think up ways to make technology do their work for them.
<8> how can i find which database im currently using?
<9> hi@all
<9> how can i transfer a database from one computer to another?
<10> what's the max username length in mysql 4.0 ?
<11> well that was odd
<7> !m planetp backup
<5> planetp: (Database Backups) : http://dev.mysql.com/doc/mysql/en/Backup.html
<7> ceu, 16?
<9> thx will
<7> Therion, Did jax's username "patch" ever go through?
<12> shabbs: do you have a Netgear or Linksys router perchance?
<10> will: thank you
<11> I'm at work, we have cisco routers
<7> Or maybe 12
<7> WE HAVE NETGEAR ROUTER WHY DO YOU ASK?
<11> though my screen went completely black
<11> so I wouldn't rule anything out
<12> just the normal connection reset by stateful packet inspection behavior, at the same time as several other channels made me suspect that it might have been the DCC SEND issue.
<1> will: I dunno
<11> infi: nah, my screen went completely black, only the cursor was up. had to hard reboot
<7> Therion, I thought you were testing it.
<1> will: no, I asked dev team to look at it
<7> Or maybe just helping him submit it..
<7> Ah
<1> will: but I don't know if anyone did, as I don't have time to babysit that right now
<7> Therion, Why?
<7> Make time!
<7> Do you still play WoW?
<1> will: No, not until they spend some of the hundreds of millions of dollars they've made and find a better solution to server instability than making us waiting in goddamned lines
<13> People line up to play WoW?
<0> lol
<0> it's like an amusement park... pay $40 admission and stand in line 45 minutes for a 35 second roller coaster ride.
<4> 'Here, buy our game! Pay us money! Stand in line!'
<14> well, the AV queue... ::curses the AV queue::
<4> if I wanted to stand in line I'd go to the ****ing supermarket and get some soda
<7> lol
<14> and there they will actually call a second checker..
<7> How did the "waiting in line" start?
<13> mmm, soda
<14> too heavy of load on some of the servers
<0> heh, you don't shop at our supermarket's then. 30 checkout lines and only 5 are open at any given time. at night, only one - so there are like 50 carts in one line while 29 other checkout lines sit closed.
<0> the love of metropolitan superstores.
<4> inviso: actually, I'd use the self-serve and be done in five minutes
<1> will: it started out at launch becuase there were too many people trying to go to the same place at the same time
<13> Those never showed up around here.
<1> will: because Blizzard for some reason didn't understand the concept of their own popularity
<4> because unlike Fredericton, where I used to live, people in Montreal can figure out that if you're too dumb to use the automatic machines, you go stand in the god damned line
<1> will: It's _continued 2 years later_ because they're ***holes.
<1> Heh, we have two stores in this entire city with self-serve lines like that
<1> and there's never anybody at them but me
<15> how can i change the name of a database?
<4> go into the filesystem and rename the directory
<0> then update your mysql.* tables to reflect, eh, Darien?
<15> Darien: where is it stored?
<15> i'm running debian etch
<7> Therion, Oh... so now that I bought a kick*** computer to play games, you won't play with me ? :(
<7> </3>
<7> </3
<7> haha, I've been doing too much HTML..
<1> will: Play Everquest2? Play Second Life? Play Diablo 2? :P
<1> will: Play WoW and tell me to get over it and stfu?
<7> I could..
<7> You should be more patient
<0> vaxen: it would be stored whereever you set the compiler options to store it and whereever your mysql config file tells it to be stored. i know on my system it's /var/mysql
<7> damn_I_am_good
<15> i thought it would be in /var/mysql, its not there
<16> will ?
<15> so i just change the name of the dir? and thats it
<0> vaxen: then look at your mysql config files and see where it says
<0> vaxen: you'll have to update any references in your mysql.* tables
<0> user permissions and that sort of thing
<15> okay
<15> /var/lib/mysql
<7> damn_I_am_good?
<7> damn_I_am_good!
<15> b1n0ry: thanks
<0> np
<16> will how can I help you ? :)
<1> will: I thought paying them for 2 years was pretty patient ;)
<0> heh, all of my utility providers charge a fee to pay bill with a credit card over the phone now
<1> Firebomb them.
<17> Hi everyone :) I got a "small" issue, i change the root's p***wd, i flush privileges but... nothing, i still can access mysql without p***word... any idea ?
<1> Estes2: SELECT CURRENT_USER();
<17> ?
<1> Estes2: Execute that and see what login you have been authenticated as.
<17> oki
<7> Therion, Did you see my new computer?
<17> | root@localhost |
<1> will: "no" comes to mind
<17> I have the rights
<1> Estes2: You ahve logged in without a p***word? :)
<17> yes
<1> Estes2: restart mysqld
<17> i logged in without p***wd, set a p***word with GRANT and FLUSH PRIVILEGES...
<17> and nothing, i still login without p***wd :P
<1> Log out
<17> oki
<1> log back in
<1> see if CURRENT_USER() says root@localhost
<7> Therion, http://hashmysql.org/153
<7> Therion, http://hashmysql.org/1535
<1> If so, SELECT p***word FROM mysql.user WHERE user='root';
<1> see if SELECT P***WORD('your p***word here'); reports the same hash
<1> will: Ahhh I saw that
<17> still
<17> even after restarted
<17> and current use is root@localhost
<1> Estes2: how are you logging in?
<17> # mysql
<1> odd
<17> yes
<1> If so, SELECT p***word FROM mysql.user WHERE user='root';
<1> Estes2: is there a hash?
Return to
#mysql
or
Go to some related
logs:
#suse
rewrite_tags php
PHPEclipse include_path
#debian
#suse
x11-common kubuntu
Blockit debian
debian conflict x11-common xfree86-common
linux slow key
#linux
|
|