| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Nothing found.
<1> !man lost connection
<0> Nothing found.
<1> damn j00
<1> !man server gone away
<0> (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<2> gah, annoying cutesy errors
<2> perhaps it is having a m***age with Flickr
<3> ok, heres what im looking to do, and why
<3> keybuffer = 128, table_cache=512, sort buffer=8, read buffer = 1
<3> i have a dual 2.4 with 2 gigs of ram, with slightly more than 1 gig always free
<4> i suggest you mail me the extra gig of ram to fix your problem.
<3> rofl
<3> that should squash the load at the cost of increased memory usage yes?
<5> on installing mysql on windows i get a cross on start service and the error "Cannot create windows service for MySQL. Error: 0"
<1> sho: it depends
<3> Leithal: thats obviously not very informative :p
<1> on if you are using indexes correctly, whether you are doing a lot of sorting, how many concurrent connections you have (for read_ and sort_ buffers)
<3> we end up having a large number of concurrent sessions
<5> any idea about install?
<1> obviously, if you are not using indexes right, thn all the memory you throw at key buffer won't mean anything
<3> but one thing that i need to work on is cleaning up is all the stale connections from phps mysql pconnect (i HATE pconnect)
<3> ok, ***uming that the tables are indexed poorly
<1> lower wait_timeout and interactive_timeout
<3> key buffer wont increase performance, but would table_cache?
<3> ah, i have a script that kills em. wait_timeout probably a better idea
<1> probably
<1> it allows you to keep more tables open concurrently, if you have a bunch of connections then chances are it will increase performance
<6> Does MySQL have any sort of logging system? So i can log changes to data in a db?
<3> is wait_timeout in seconds, or what
<1> get indexing right and increase key buffer a good way, that will give good improvements
<7> Niacin, Sure!
<6> will transaction logging?
<7> !m Niacin genera query log
<0> Niacin: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<7> !m Niacin binary log
<0> Niacin: (The Binary Log) : http://dev.mysql.com/doc/mysql/en/Binary_log.html
<7> !m Niacin slow query log
<0> Niacin: (The Slow Query Log) : http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
<7> One more...
<3> Leithal : i dont really control the indexes... webhosting environment
<7> Error log! ah
<7> !man log
<0> (Mathematical Functions) : http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
<1> _sho_: You have access to a mysql database and you can create tables then you can create indexes as well
<1> they are database objects
<1> a PRIMARY KEY on a table is an index
<6> will i'm trying to keep track of people changing customer data.. Which is the best method?
<7> Niacin, Build it into your app.
<6> there is no functionality in MySQL to save me time? :)
<5> any one help with install on windows?
<1> Niacin: Triggers!
<7> Niacin, Yes, you can use the general query log. But it's not "nice".
<3> Leithal: i dont think you understand. i dont own and can not modify client database content
<7> Andy298, Best to say what the problem is...
<5> on installing mysql on windows i get a cross on start service and the error "Cannot create windows service for MySQL. Error: 0"
<1> _sho_: ****s
<7> Niacin, If you want a quick and dirty way, yeah, general query log. If this is for something on going, better to do aduiting in your app.
<7> Or stored procedure/trigger.
<8> just upgraded from 4.1 to 5.0. can't connect to localhost...needs port 111 open???
<7> No
<7> Error message probably says error 111
<8> what's goin on will?
<8> oh
<9> !perror 111
<0> System error: 111 = Connection refused
<8> ya is
<8> kk
<7> !man connection refused
<0> Nothing found.
<7> awww
<3> yep, it does
<3> ok, now im cookin with gas
<8> first I wanted to: # service mysqld status mysqld unrecogniced service
<3> Mem: 2069008 1883484 185524 0 64300 1114156
<10> rado2: I bet it's "mysql".
<10> But I'm guessing.
<10> You can look, I can't!
<8> the daemon?
<7> DEMON
<8> hold on
<10> No, the init script.
<10> That's what "service" manipulates, the stuff in /etc/init.d
<8> friggin will huh?
<5> so you have the error now - any advice?
<5> i get a cross on start service and the error "Cannot create windows service for MySQL. Error: 0"
<8> wow
<7> Well, I don't have any advice. I don't use MySQL on Windows. But from what I've tried, it looks really easy to install.
<11> what version of mysql is neeed for INSERT ... ON DUPLICATE KEY UPDATE ?
<3> thanks much Therion
<7> Thanks Therion
<8> in 4.1 ....wasn't the service called mysqld tho?...or am I really losing it
<7> Depends on package.
<5> hmm well SQL won't configure! :|
<8> just the stock pkg that comes w/rhel4/centos4
<5> as a service on windows! :S
<10> rado2: By my weak recollection, old RH packages called it "mysqld", while MySQL AB's packages called it "mysql".
<12> loooooooool
<12> ii vreun roman pe aici ??
<12> :D
<12> :-/
<8> well,...not gonna look back ...it's service mysql now...and it works for me
<12> :-?
<8> Starting MySQLCouldn't find MySQL manager or server [FAILED]
<5> how can i delete an old MySQL service from windows?
<13> will: YOU ARE NOT WELCOME
<7> Therion, Since you're here...
<13> Andy298: mysqld-nt.exe --remove? :)
<7> !man load data
<0> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<7> !man load data infile
<0> (Problems with NULL Values) : http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html
<7> ?
<13> will: Nothing I can do about the way it's ranked there
<13> will: WEll, I could delete that row from the database
<7> Is it your search engine?
<13> No
<7> I thought sometime ago you changed it to search title first...
<5> Therion: didn't work!!
<5> i've deleted the folder
<13> Andy298: Installer should handle these situations
<13> will: it tries to
<13> will: if it finds a direct title match it uses that
<7> Computers ****.
<13> ie
<7> !man load data infile syntax
<13> !man load data infile syntax
<0> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<13> heh
<5> well it hasn't! anyway to force the removal from services?
<0> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<7> :P
<5> i've disabled it but i want to delete it!
<13> Andy298: Editing your registry.
<13> Andy298: Otherwise use the no-installer version, grab the mysqld-nt.exe binary, use --remove or whatever
Return to
#mysql
or
Go to some related
logs:
MySQL 160bit
preteen jpg
TheGladiator rom
boot.conf gentoo
#ai
ubuntu vn800
#css
#suse
#sql
googletoolbar/not
|
|