| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> thx
<1> where is the default my.cnf of mysql
<1> i remove my.cnf /etc
<1> but seems mysql still runs
<0> kernel20, it can be running without my.cnf
<0> as I know
<2> can anybody think of a reason why a mysql-cluster SQL node would try to start up in InnoDB instead of using ndbcluster as a storage engine?!
<1> ?
<0> kernel20, there are some default options, I tried to use mysql without my.cnf or my.ini under win32 and it works
<1> where can i edit the default options
<1> i want to mysql to use my.cnf
<2> christ...
<2> so do I
<0> kernel20, write options u need in your /etc/my.cnf and use it
<1> yeah i did
<3> maybe if you coated your my.cnf file in chocolate it might be more appealing to mysql
<4> hello guys
<0> lsmith, I am using query: Insert into `clients` ( `addr`, `lastping` ) values ( '127.0.0.1', UNIX_TIMESTAMP( ) ) on duplicate key update `lastping` = UNIX_TIMESTAMP( ), what is incorrect?
<3> or perhaps an advertising campaign of some kind :P
<1> actually i am working on default-character-set=sjis
<1> the entries looks ?????
<1> i dont know why
<4> is it possible to change the character set of multiple table in one go?
<4> something like:
<0> kernel20, change it if u need
<4> ALTER TABLE `cOUNTRIES` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ,
<4> ALTER TABLE `iPCITYISP` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
<1> aibo: yes
<1> default character type of the table is already sjis
<1> but it still displays ????
<4> except that with this i have an error message :
<4> #1064 - 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 'TABLE `iPCITYISP` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 2
<1> ENGINE=InnoDB DEFAULT CHARSET=sjis
<0> kernel20, /etc/init.d/mysql restart
<1> aibo: done a couple of times
<0> kernel20, execute query: show variables like %charset%;
<4> any hint?
<1> display is question mark
<0> kernel20, w8
<0> kernel20, show variables like 'char%'
<0> kernel20, and watch on your charsets, on server charset and client charset
<0> andrewbryson, can u help me with my qry?
<1> sjis
<1> but display is ????????????
<0> kernel20, it is about character-set-client
<1> then?
<0> kernel20, configure this option in your my.cnf
<1> what option?
<0> kernel20, character-set-client
<1> [mysql]?
<1> character-set-client=sjis?
<0> kernel20, yes
<1> k wait
<1> still the same
<1> question mark
<1> aibo:?
<5> Fixed. Thanks again, infi.
<0> kernel20, what mark;
<0> kernel20, read this -> http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
<6> hi everybody, i have "small" problem after upgrade from 4.1 to 5.0. it's explained here (i don't wanna to copy everything :P) http://forums.gentoo.org/viewtopic-t-465905.html - any help from you?
<2> man oh man, i never thought it'd be so f*cking hard to start two instances of mysqld on the same box
<3> erm ?
<3> it isn't difficult at all...
<2> tell that to mysql-cluster
<2> which doesn't want to f-in' recognize another damn config file
<3> hey mysql-cluster - it is not difficult at all
<3> there you go marc7 :)
<2> seriously, i'm almost ready to paypal someone $20 to help me figure this out.
<3> LOL $20 would not even pay for my time to do it :P
<2> right
<2> because if it was so easy, it would totally be worth it
<2> quick fix
<2> it's not, you'd easily get wrapped up in this.. and then be like ARGHHHHHH
<2> and my point will be proven.
<7> did you read the docs?
<7> !m marc7 multiple servers
<8> marc7: (Running Multiple MySQL Servers on the Same Machine) : http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
<2> infi: I'm going to try blowing everything away and starting over again... hold on a sec.
<9> question: what is the best way to decrement an auto_inc index when you remove something? essentially re-sync your index?
<6> why this query takes soooo much time on MySQL 5? (it's fast as hell in MySQL 4.1)
<6> SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek, City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id = gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId = gra_gwiazdy.miastoid) INNER JOIN (swiat_panstwa) ON (swiat_panstwa.CountryId = gra_gwiazdy.countryid) INNER JOIN (gra_gm) ON (gra_gm.gid = gra_gwiazdy.id) WHERE gra_gwiazdy.id != '1310' ORDER BY
<3> do you have the same indexes as you did on mysql 4 ?
<6> hm... let's check that :>
<6> yes, there are same as in 4.1
<6> maybe it's not this query problem but... hm, i don't know, maybe something changed beetween 4.1 and 5.0 in my.cnf?
<6> on start in mysql.err i have: No argument was provided to --log-bin, and --log-bin-index was not used ... but AFAIK it can be promblematic with replication?
<2> so andrew... thanks for joking around about it... I went back to the drawing board... and found a much better way to get it all setup. kudos.
<2> *sigh of relief*
<6> ah, and something strange, is that there is only one mysqld process ? :|
<3> try connecting from several clients at once
<3> see if more spawn
<6> nope
<6> there is only one, even if there is more clients
<3> intriguing
<10> well it depends
<6> and that one is about 100% cpu usage
<10> on debian they are visible like one per connection
<6> if i remember well, on Gentoo, when I've got 4.1 it act like you say, one per connection
<11> is there something funky that is happening when i have blobs in my database... like a max size... ? my pictures are getting cut off
<11> what the heck does this mean: Mysql::Error: MySQL server has gone away: ?
<2> okay, if I'm invoking /usr/local/mysql-cluster/bin/mysqld_safe --defaults-file=/etc/my-cluster.cnf, where /usr/local/mysql-cluster is a symlink to mysql-max-5.0.21.... and /etc/my-cluster.cnf has "basedir = /usr/local/mysql-cluster" as a line in it... why is it still trying to invoke /usr/local/mysql/bin/mysqld instead?
<11> folks.... any idea when i try to insert a picture into a blob, it cuts off a bunch of the image?
<12> max_allowed_packet may be too low?
<12> that would be one reason for server gone away
<12> !man aborted connection
<8> (Communication Errors and Aborted Connections) : http://dev.mysql.com/doc/mysql/en/Communication_errors.html
<11> leith: mysql just dies when i try a large image
<12> i.e you should set max_allowed_packet to something larger than the largest BLOB you will upload
<12> define "large"
<11> Leith: what is the command to make that statement
<11> happen
<12> SET GLOBAL max_allowed_packet = 1*1024*1024*1024;
<12> then set it in your my.cnf file as well so it survives a restart
<12> or just set it for the session
<12> SET SESSION max_allowed_packet....;
<11> leith = size in bytes?
<12> yea
<12> but takes an expression like above
<11> is postgre a better db than mysql ? why or why not?
<11> (i have heard that mysql doesn't handle blobs well)
<12> I surely couldn't answer that ;)
<2> how can I tell mysqld_safe *NOT* to use /usr/local/mysql/bin/mysqld.... but start somewhere else instead? --defaults-file and --basedir don't seem to be doing it.
<11> leith: is there a way to do that through the myssql command line?
<12> arooni: that is exactly how you do it through the command line
<12> marc7: try --defaults-extra-file as the first parameter?
<13> hi!
<12> domas!
<13> how to shrink ibdata?!!?! :)
<3> dammit!
<13> oh wait...
<11> leith: do i need to run the command 'mysqladmin'first ?
<12> domas: rm -f
<13> Leith: yeah, doing that at the moment
<13> ****ing 400GB files
<12> lol
<13> I forgot to delete one database few months ago
<2> Leith: done... and the file has this in it "basedir = /usr/local/mysql-cluster"... but it still tries to invoke /usr/local/mysql/bin/mysqld instead of looking in /usr/local/mysql-cluster/ for the binaries.
<13> or rather was too lazy to communicate some bits ;-)
<2> er, defaults-extra-file? or just defaults-file?
<12> I always use -extra- for some perverted reason I can never remember
<2> fair enough
<12> but you might check there are no other .cnf files elsewhere
<12> lik /etc
<2> there *is*
<2> so should I move that out of the way?
<12> or rename it, if it's not needed
<2> it is, but I could invoke the other instance with --defaults-file as well
<2> nope.
<2> no go.
Return to
#mysql
or
Go to some related
logs:
#python
suse visudo 10.0
decompyle xubuntu
#debian
#gentoo
fatal: gethostbyname: Resource temporarily unavailable
setenv SDL_AUDIODRIVER esd debian
public aways + stupid
Error * Unable to open an ra_local session to URL
#xorg
|
|