| |
| |
| |
|
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
Comments:
<0> hi all. is there a way to get only the last matched row in a query?
<1> hmm.. reverse sort and LIMIT 1?
<1> (gives you the first)
<0> yer, hmm. no other way huh?
<1> possibly there's some meaning to LIMIT -1
<1> who knows...
<0> nope i checked
<1> then I don't know.
<0> np thankx anyway
<1> is there a way you can select the port of the mysql server?
<0> [mysqld]
<0> # The TCP/IP Port the MySQL Server will listen on
<0> port=3306
<0> my.ini
<1> Yeah, but I suspected there were two daemons running on this server that's not mine
<1> because in phpmyadmin I see tables that php doesn't see
<1> and I'm completely stumped as to why
<1> and to simplify it, the mysql shell doesn't see them either
<1> and it seems both are accessing localhost 3306
<1> gaah
<1> logic tell me this is impossible
<1> reality is persistent, though.
<2> do both connect w/ same user/p***word?
<1> yes
<1> yeah
<1> *headache*
<1> I don't have any idea what this could be
<1> same port, same login, same database, same host
<1> all as far as IC an tell
<2> and when you connect w/ mysql client, are the tables visible?
<1> the ones that were there before, yes. The ones I created an hour ago with phpmyadmin, no
<2> do you see them on the filesystem?
<1> not my system
<1> can't tell
<3> I'm using MySQL v4.1.? on both Linux (CentOS) and Win 2003 server; trying to set up replication. Bombs because of 'character_set_*' and 'collation_*' differences. Do I change Windows to match Linux, or Linux to match Windows?
<3> Does it matter which?
<4> WB0TRA: just set them to be equal
<3> Does it matter which I change?
<4> no
<4> just make server settings equal
<1> gah, no coffee:/
<3> Ok. Two sections in the /etc/my.cnf file; which section do these get made in?
<4> [mysqld]
<3> Got it; thanks.
<5> did the universe at least rearrange itself scarfboy?
<1> not noticeably.
<5> can't have it all, or even some of it apparently :(
<1> Indeed. Usually I can make at least some sense of why mysql doesn't make sense:)
<1> You know, this could be the university bigbrain center doing Extra Funky Firewall Crap(tm).
<1> Except, no, I doubt they reroute localhost:)
<3> Got timeout error on restarting MySQLd on the Linux box. Commented out my changes and seems ok now. Try one change at a time?
<6> looked in phpmyadmin's config to see where its connecting too
<7> scarfboy: there could be different permissions for each host... eg. user@localhost perms != user@ip.ad.dr.ess perms
<1> that would disallow me from even seeing the tables?
<3> Tried changing ONLY charaacter_set_server and collation_server; started up ok this time.
<1> and it comes from the same host in both cases
<1> the same host has apache, mysql, both connect to localhost with the same credentials.
<1> I mean, both phpmyadmin and mysql shell (and php too) do.
<8> what is the best type for storing p***words in tables ??
<8> that allow any character
<9> iturk: md5?
<8> what is md5 ?
<10> is there any possibility to just get one of these columns, like select <column>? http://tools.wikimedia.de/~leon/test
<1> you should hash the p***word, not store the p***word
<1> better for security
<8> could you get me a link for that
<9> oy, hey LeonWP :)
<10> hie Duesentrieb :)
<9> LeonWP: oh... from the slave status... hm...
<9> that would be cool :)
<9> actually, i'd like to be able to to a join on the result of SHOW TABLES;
<9> hmm.... maybe it works as a subquery?
<9> anyway, goota go
<10> how?
<10> mhm, bye Duesentrieb
<7> scarfboy: yes, that could prevent you from even seeing the tables... also, although phpMyAdmin should be setup to connect the exact same as you do, it doesn't guarantee that it was setup that way...
<9> select Master_Host from ( show slave status )
<9> or something like that
<9> worth a try
<10> ah, i'll try
<1> kibab, how not?
<7> scarfboy: it's the only possibility that makes sense to me... although someone else might point something else out as well...
<1> both connect from the same server, to localhost, 3306 (or default in the config), same username, same p***word
<7> Duesentrieb: sounds like you need information_schema (mysql-5+)
<1> I don't think the rules could make a distinction if they wanted to
<10> doesn't work
<7> scarfboy: if they are on the same box, they probably just use the local pipe... but if they are connecting to 127.0.0.1, it shouldn't matter...
<10> can somebody else help me?
<1> unix socket vs tcp 127? I guess that's somewhat possible
<1> if sounding very dubious
<7> scarfboy: those should both be the same... now user@ip.ad.dr.ess would be different... it all depends on the grant(s) used.
<7> scarfboy: hmmm... what type of tables are these? are they all InnoDB? MyIsam?
<11> hi
<1> you mean they may connect via different interfaces?
<11> i'm doing some extensive work on a mysql5 database, and as usual it allocates very much memory. when i start working with gnome again (like starting a terminal, moving a window) my system starts to swap alot.. schedulerload went up to 270 once! is there a way to limit mysql5 memory allocation or is there another way to solve this problem?
<1> well, even then my php code should work
<1> It had myISAM before, I created InnoDBs
<1> but also just a myisam to test, it can't see that either
<11> i am using myisamtables.. read they are memorymapped when compressed.. aren't compressed here.
<7> headhunter: check the slow_queries log.... something's not right there.
<11> my programs can run very fast for hours
<11> only when i touch my system it wrecks
<12> scarfboy: try select current_user(); in both places see if there is a difference
<7> scarfboy: with innodb tables, do you have to commit before the other 'session' can see them?
<11> but i check
<1> but phpmyadmin created them
<11> kibab: where can i find that log?
<1> I even did an isolated COMMIT;
<1> just to be sure
<12> scarfboy: did you check the users?
<7> scarfboy: not sure.. per shabbs(), do they return the same thing?
<11> kibab: seems i have none of those.. my sql queries are all boring anyway. i've done some testing and i really thinkg this is because mysql allocates all memory. when i start a terminal (which might take like 30mb) the system has to swap like crazy.
<7> headhunter: grep my.cnf | slow queries ... and if it's not there, turn it on
<11> i got no slow queries entry?
<13> hi
<1> ooh, those aren't identical
<12> so they're not logging in as the same user
<7> headhunter: lol... surprised you could understand that now that I look back at it ;)
<11> what do you mean?
<1> I ***umed the user that was in the phpmyadmin file was the one it was logging in as
<1> silly me
<7> headhunter: I should have had grep "slow" my.cnf ...
<12> you know about ***umptions right
<1> yes
<1> "They don't work when you have mysql"
<12> they're the mother of all ****ups?
<1> that too
<12> has nothing to do with mysql :)
<1> okay
<1> "...phpmyadmin"
<12> there ya go
<1> same differene
<12> not really
<1> that's why that expression is so versatile
<1> and so annoying:)
<11> kibab: ok, i will benchmark my queries.. is there any way to limit the amount of memory mysql can use?
<1> thanks, anyway
<12> np
<14> Hi! Could you please tell me what the "grantor" and "colunm_priv" columns are used for in mysql.tables_priv?
<7> headhunter: show variables like '%mem%';
<7> headhunter: hmm... there are some others too...
<1> how is it logging in with the credentials that are commented out anyway?
<1> *boggles*
<12> sure it's using the right config file?
<7> headhunter: show variables like '%cache%'
<7> headhunter: I turned up a number of settings so mine typically uses about 512 megs of RAM... before that it was only ever at about 40 Megs.
<11> query_cache_limit | 1048576 -> i guess that means my 1gig of ram fully belongs to mysql?
<1> config.inc.php
Return to
#mysql
or
Go to some related
logs:
split 700mb coreutils cat
#physics
#web
bunzip sarge
phunkbot
#css
I want to clear mail queue in Postfix.
radfoj
tias means
ubuntu This codecs.conf is too old and incompatible with this MPlayer release!
|
|