| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> use RLIKE and a regex expression
<1> ooh sweet thanks
<0> !m rlike
<2> Incorrect usage. See 'help m'
<0> d'oh
<0> http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html
<0> there you go
<1> thank you
<0> don't ask me how to form the regex expression you want, though :)
<0> I know what regex is good for, but I have no clue how to write them :)
<0> ok... now I'm really REALLY going to bed
<0> 'nit all
<3> man 3 strstr
<3> oops
<4> how do you select based on two requirements
<4> select from blah where this ="that" and foo = "bar";
<5> s/"/'/
<5> s/"/'/g
<6> select something
<7> just like that except with a "FROM table" clause
<3> Bruce_LeeRoy: that's how
<4> hmm, it wasnt working
<3> then you were doing it wrong
<3> SELECT something FROM table WHERE this="that" AND foo="bar";
<4> ok, i see what i did wrong
<4> thanks guys
<3> :D
<7> Darien: are you terribly busy ?
<3> not *terribly* so
<3> my level of business is inversely proportional to the interest your question generates
<7> Darien: mind looking at a script I wrote and giving any recommendations.
<3> busy-ness
<7> http://www.day32.com/tuning-primer.sh
<3> well pastebin the script and we can find out how busy I am
<7> it logs into mysql looks at global variables and status varaiables and makes tuning recomendations.
<7> makes no changes though.
<3> well the first problem is that you're not using four-character tabs
<3> shame on you
<7> 900+ lines of bash :)
<3> sheesh
<3> why not use PHP?
<7> It started out as a quick hack and got away from me.
<7> I may redo it in PERL.
<3> neat
<3> 'Perl'
<3> anyway
<3> I didn't know you worked for rackspace
<7> ya
<3> the real issue with my reading this is the dozens of lines you spend to create functions that already exist in PHP and Perl :p
<3> I bet you could do this in a hundred lines of PHP or four lines of illegible perl :p
<8> Darien: and I would save cycles not going back and forth between to the db.
<3> yeh
<3> br
<3> b
<5> Therion: DIE
<8> Darien: I'm mostly concerned with the functionality and correctness of the recommendation and less about the coding style or esthetic
<9> hi all
<3> back
<3> wtf
<3> stupid people calling
<3> go to bed jack***es :/
<10> why does it increase created_tmp_disk_tables? how can i stop it using disk tables?
<10> what's a good value for max_connections?
<8> bobnormal: increase your tmp_table_size
<10> i have only two websites running from php, occasionally a remote system uploading
<10> todointx: thanks
<8> bobnormal: max_connections depends on what your max_used_connections status is set to.
<8> if you've only used 15 connections then a max_connections of 100 is fine.
<10> todo: max 7, average 3
<10> todointx: thats from mysql administrator, unsure if its the same value
<10> todointx: on no, its threads ;)
<8> I don't like to have a max_used_connections > 85% of max_connections.
<8> bobnormal: give my tuning-primer.sh a test.
<10> todo: im on 4.x, i dont think i have max_used_connections
<8> http://www.day32.com/tuning-primer.sh
<10> todointx: cheers :)
<8> it won't make any changes
<8> bobnormal: tell me if there's anything that seems off
<8> bobnormal: by the way it would be -- show status like 'Max_used_connections;
<10> todo: yeah, no var...
<11> What's the SQL query to make a copy of a database?
<12> copy of a database ? there is none
<11> I mean I need to have two databases with different names and identical content.
<12> if you want to copy a table, that is another matter
<11> Sneaky_Bastard, a whole database.
<12> yes, I can read
<11> Do I have to export then import to the new one ?
<12> can you?
<12> three is no *query* for what you ask
<12> there are utilities I believe
<12> I think that is what you would have to do
<12> export the tables and import into new DB
<11> Sneaky_Bastard, ok, but I think such a query would be fun to be added. Since I suppose export/import shall work slower
<11> but atm I'll do it like that since it's the only way to go
<10> todointx: thanks, it found the query_cache_size is too small, plus 1 queries where a join could not use an index properly
<10> todointx: also 48% of tmp tables created were disk based, Current table_cache hit rate is 21%, while 100% of your table cache is in use
<10> todointx: thanks, that tool rocks ;)
<8> I'm reworking it in perl right now.
<8> a.k.a. learning perl...
<8> I think it beats the hell out of those "MySQL tuning in 3/5min." articles on planetmysql a couple of days ago.
<10> todo: yeah, the articles i've been reading yesterday/today ****. a lot of it is automatable
<8> hence tuning-primer.sh
<10> todo: even better, determine system memory usage, and check filesystem mount types
<10> todo: if it can tell there's memory spare or not, then the suggested optimizations could change
<10> todo: even 'BUY MORE MEMORY!' ;)
<8> coo
<3> grr
<3> TodoInTX: still on calls :p
<8> also if you have IDE's and lots of Handler_read_next then look into SCSI's
<8> bobnormal: 9 out of 10 times the performance problems come from not effectively using the memory you've got.
<8> and stupid queries / indexes.
<10> todointx: my problem is my hosting provider decided im using too much memory
<10> todointx: but i cant really reduce the memory use of my app
<13> whats the equiv of this "and pc_***ign_worklist.pxWorkGroup = pr_data_admin.pyWorkGroupName(+)" in mysql ?
<10> todointx: its low cpu, lots of caching, etc.. but there's ~200 tables, some with lots of data, lots of complex queries
<10> todointx: i already optimized queries, the slow queries log is empty now
<10> todointx: but they say i use too much memory ... i dunno how to reduce it, they had query cache etc. all OFF .. now they gave me root (it's v.ded) and i'm supposed to fix it
<3> so you decrease the 'slow query' threshold and then re-optimise :p
<10> todointx: any ideas?
<3> bobnormal: upgrade the memory
<10> darien: it has 8GB, we're allowed 200MB(!!!!!)
<3> ?
<10> darien: its a v.ded host on a 4 x 3.2Xeon host
<3> what do you mean 'allowed' ?
<3> v.ded?
<3> real words please :/
<10> darien: its xen i think
<3> eeew
<8> I think Darien is right, you may have optimized your queries such that they execute in less than long_query_time but are still relatively poor performing.
<10> darien: it's not a real system, it's a virtual system
<3> it's a virtual nightmare
<10> todointx: ok i'll try that
<3> lesson one: your business is worth spending money on; this includes colocation
<10> darien: damn right, so i've been looking for colo providers all day
<13> Anyone ?
<3> bobnormal: colo or dedicated server?
<10> darien: its my client's business, not mine, and he pays me good money by the hour, so im not complaining
<3> bobnormal: fair enough, but that just means it's *their* lesson, not yours
<3> you didn't sound like the type to say 'let's skimp out on hardware'
<10> darien: either are fine, but i want to combine many existing sites in to a single host, so it has to have some beef
<3> bobnormal: I normally recommend Serverbeach
<10> darien: no, i'm not .. i'm also the application programmer, so i'd prefer zero skimping if at all possible
<3> bobnormal: depending on the budget, Rackspace may be an option as well
<14> xen is nice ;)
<8> :)
<3> Rackspace will give you more bang for your buck; whether you need/want/can afford that bang is the real question
<3> Serverbeach is low-cost and low-maintenance, and works quite well for the low-end
<8> Darien: little know fact. serverbeach used to be a subsidiary of Rackspace.
<10> darien: i spoke to them today, they said entry-level for me is 600-700USD/month, i'm looking more like 100USD/month, we use bugger all bandwidth -- 20GB/month .. but if i combine sites, maybe 50GB-100GB roughly within the next few months
Return to
#mysql
or
Go to some related
logs:
resize compiz slow
#perl
#php
#suse
css no opacity
how to kill a screen session
Vortex: vortex_fifo_setadbctrl fail via
#web
#fluxbox
how to add something to $path in dapper
|
|