| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> hey
<1> it looks by the syntax page that "JOIN" is an inner join and "LEFT JOIN" is an outer join?
<0> any thoughts on why i might be getting this? http://pastebin.com/564778
<0> the problem is occuring when i try to dump tab seperated
<1> ahhh, left join is an outer join, it just kicked in, thanks a ton
<1> makes my query much smaller too, that's nifty
<1> Edward123, are you sure that file is writeable?
<1> have you chmod 755'd it?
<0> well i'm running mysqldump as root
<0> or doesn't it work like that?
<1> if it's 666, then it's only readable
<0> it's 755
<1> then that should be fine
<0> it's producing that error, though
<1> it doesn't do it when you don't dump tab seperated?
<2> ehm.. 6 is rw
<2> 7 is rwx
<1> oh
<1> well, I'm definitely not a linux user
<1> have you tried another directory?
<0> ah right
<0> yeah
<1> has anyone ever heard their processor through their speakers?
<0> yeah
<1> never heard of it ever happening to anyone, always happens to me, 3 sets of speakers, 3 sound cards, over time I start hearing my processor
<1> I thought my hard drive was dying out on me
<1> was racing to back up data when I realized it was my speakers again
<1> would that mean something isn't grounded?
<0> well i get it when i plug my amp into my mic
<0> socket
<1> it's kinda neat though, always scrolling text horizontally makes the most sound, other than hard drive activity
<0> on my laptop
<3> bummer .. mysql simply bombs on a complex multi layered subquery
<3> i was able to rewrite it by putting the subquery inside the from clause
<3> that got it to work again
<0> figured out my mysqldump problems in case anyone else gets it
<0> arguments in wrong order
<3> horrible performance still
<4> rewrite as a straight join so you can force the execution/join order
<3> archivist: not so easy .. trying to see if that is possible
<3> but there are two group by's involved
<3> archivist: http://pastebin.com/564805
<3> the first query gets horrible performance .. the second just runs wild for ages
<5> hi all. I accidentally (and embar***ingly) deleted /var/lib/mysql when I was trying to move the data directory. what's the best way to get mysql working again? there were no critical databases lost (just lots of frustration)...
<3> i just added explain output http://pastebin.com/564806
<6> lsmith: stop scarying me.
<6> I never ever had a sql-syntax that was bigger then like 2 lines :>
<6> and i'm glad for that :>
<3> hehe
<4> well i was about to say break it up a bit and get it to use indexes
<3> archivist: its clearly mysql running amok .. if i do things in two queries performance improves considerably
<3> still not great though
<4> Some people like leaving everything up to the optimiser but I dont
<3> the thing is that this also needs to run on oracle
<3> where it just zips through in no time
<4> in that case report as a bug
<7> hi ppl. im in a pickle: im getting loads of connections started, and not dying out by themselves, eventually clogging up the server. @ night i got up to 512 mysqld threads (thats the limit). all were in the state: "35055 | unauthenticated user | 10.1.1.9:54674 | NULL | Connect | NULL | login | NULL" (output of show processlist;). google isnt really helping. this only happens when connecting from a remote host (local connections are ok). anyone ever enco
<4> dont use pconnect
<7> archivist: same app - wokrs ok at one time, causes the above error on a diff occasion. it seems random - and to be homest im not even sure if its mysql's fault. the fact is - without any actions - sometimes the threads die out by themselves, and sometimes i have to killall -9 mysqld to shut down the server.
<4> NEVER -9 use -15
<7> k. point is that i dont understand why sometimes i have to do that, and sometimes it goes away by itself.
<4> mysqd does not see -9 so cannot clean up before exit therefore db damage is likely
<8> not with innodb
<7> archivist: and im not using pconnect.
<8> or blackhole
<4> blackhole the perfect data store
<8> perfect it is
<9> I can use SHOW TABLES to list the tables in a database but is it possible to obtain more information about those tables? such as foreign keys, etc...
<7> archivist: im looking at a couple of options here: something is wrong with 1) mysql 2) apache on the remote machine 3) php on the remote machine 4) libmysqlclient(or whatever its called) on the remote 5) the kernel. maybe you could help me eliminate at least one of those ?
<5> okay, I've reinstalled mysql and it's working nicely. what's the best way to change the data directory (so that it gets backed up)? move everything and edit /etc/mysql/my.cnf? or create a symbolic link for /var/lib/mysql?
<10> hello
<11> ndlovu: mysql comes with tools that allow making backup without this kind of rude intervention
<10> I have this query, SELECT something from table where id in number
<10> can I do a select on only some rows of the table ?
<10> like I want to do select on half the table on one machine and select other half of the table on another machine
<10> the database is really big and I want to speed up the query by parallelizing it ?
<9> DESCRIBE table; give me info on the standard table columns but does not give info on foreign keys.
<9> order does it?
<2> i wouldn't paralyze the db if i were you
<5> Urgleflogue: I realise that it's not ideal, but I have an automatic backup script that backs up my home folder. Setting up separate backup processes for databases could be problematic
<12> manj: proper index will helps
<10> syf: what would I do ?
<5> Urgleflogue: unless an automated backup of the data directory would not be sufficient to retrieve the databases afterwards, in which case I'd have to go for something more robust
<11> ndlovu: technically it is possible to copy mysql dir to another location and thus backup it, but it's strongly recommended that you use mysqld-aware tools
<5> Urgleflogue: like running mysqldump as a cron job?
<11> ndlovu: it's simple, 1) stop mysqld, 2) copy data directory, 3) start mysqld
<11> ndlovu: in ideal world yes. mysqldump is aware of table locking, write synchronization etc. so that no data will be corrupted
<11> the export output of mysqldump can be piped through bzip2 filter if occupied space is something of concern
<11> something like mysqldump -h host -u user -p p***word --all-databases | bzip2 > db_backup.sql.bz2
<11> restoring is as simple as bzcat db_backup.sql.bz2 | mysql -h host -u user -p p***word
<5> thanks Urgleflogue, that should do exactly what I'm looking for
<10> can I please get an example of using index to select some n/i rows out of n rows ? where i is the number of parallel machines ?
<10> a link to something on the internet is also fine, as I am really new to sql
<11> manju: you might want to play with mysql's LIMIT clause
<11> manju: http://dev.mysql.com/doc/refman/5.0/en/select.html
<10> Urgleflogue: thank you
<13> hi
<13> i've got a varchar column containing numbers for now. can i somehow sort it like a numeric field? actual order by: 10, 111, 112, 12 should be: 10, 12, 111, 112
<14> hi how can i access an Mysql Database from an extern system?
<13> kami22: perhaps your server only binds a socket and you need to configure a tcp-port? look for "port = 3306" in your (probably) /etc/my.cnf. perhaps it's commented out
<15> Can you tell me about MySQL Cluster.
<14> no its not commented out its activated and i am sitting in the same local network so no firewall
<14> DBI connect('database=TVprg:192.168.0.37:3306','TVprg',...) failed: Host '192.168.0.3' is not allowed to connect to this MySQL server at...
<13> ok, if your tcp-communication is ok, you have to ***ure, that's your user you try to connect with is not only defined for localhost. look for a user like username@% or username@<ip>
<13> or better create it :)
<14> ohh this could bee
<14> wait a minute i will test
<15> hi
<15> hi all
<15> I need some help regarding MySQL Cluster.
<14> okay thanks it works :)
<16> hello
<16> help, mysql can't login from localhost
<16> hmm?
<16> anybody here?
<11> gerryxiao: yes.
<17> hey guys, quick question, how do you select every row starting with a certain letter? e.g. for displaying lists of people's surnames starting with a certain letter
<17> like A% maybe?
<4> select fields,... where 'name' like 'A%'
<17> hehe, thanks
<17> yeah, that worked
<18> hi guys, quick question - to lock a users account, do I only need to null the host field in the user.mysql table for the user's record?
<16> Urgleflogue: when i type "mysql -u root -h localhost -pxxx", i just got errors
<16> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)
<11> gerryxiao: http://www.tech-recipes.com/mysql_tips762.html
<11> gerryxiao: first google match on "Can't connect to local MySQL server through socket"...
<16> Urgleflogue: i'm sure that mysql sever is running
<11> is it using '/var/run/mysqld/mysqld.sock'
<16> sure
<16> mysql -h tiger -u root etc ; i can connect it without any questions
<16> tiger =another hostname
<11> yeah but here mysqld is running on localhost
<16> sure
<11> and my question was - is mysqld daemon using '/var/run/mysqld/mysqld.sock' or just /tmp/mysql.sock or something like that?
<16> in my my.conf that's /var/run/mysqld/mysqld.sock
<16> my.cnf
<16> user = mysql
<16> port = 3306
<16> socket = /var/run/mysqld/mysqld.sock
<16> pid-file = /var/run/mysqld/mysqld.pid
<16> log-error = /var/log/mysql/mysqld.err
<16> ba
<16> that's it
<11> gerryxiao: is there in my.cnf [client] section with row that states something like "socket=/var/lib/mysql/mysql.sock" ?
<16> moment
<11> or in your case /var/run/mysqld/mysqld.sock
<16> Urgleflogue: that's /var/run/mysqld/mysqld.sock
<16> in client
<19> How can I check what characterset mysql is using?
<11> gerryxiao: what is the result of just 'mysql -u root' ?
<16> still gave me that error :)
Return to
#mysql
or
Go to some related
logs:
colyli
strtod alternative
device has unknown breezy
how evil eat this kitten
#awk
iptables logs on terminals
Ubuntu ddclient interface used
#sql
pk11_authenticate failed
gentoo dispatch-config
|
|