| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> it could
<1> dual xeon 2gig and load is 12
<2> hi
<1> nothing in top, nothing in ps - nothing as in over %1 cpu or !5 mem usage.
<0> if you're disk-locked you could run a PII and get the same performance
<1> I am thinking it is a kernel problem maybe?
<2> how can I monitore mysql error log ?
<0> log slow queries first
<1> "disk-locked" - whats that mean?
<0> then work from that. SEt the limit below 0.2 sec
<1> ok will do
<0> meaning, disk io is your bottleneck
<3> mikefoo: If you have iostat, try that and see what it reports
<1> yeah iowait is avg of 35%
<0> SurcouF, what do you mean?
<1> what else should I look at?
<0> tail -f works
<0> :)
<0> (1) get data
<0> (2) analyze data
<0> (3) repeat from (1) based on (2)
<0> :)
<2> shannon, I want to got a notification from nagios when an error is present in mysql logs
<0> have you checked for a relevant plugin?
<0> if there isn't one, write one
<2> no relevant plugin found
<2> the question is: how can I do this check ?
<0> then I guess you're going to have to polish up your perl
<0> they have samples, modify one to parse the error log
<2> which samples are you talking about ?
<4> why mysql uses "sessionId" as index instead of "queries" here? (both are keys, separated) explain select queries from stats where sessionId = 124 order by queries limit 10;
<5> runa: where is executed first then order by, so better to reduce rows before the sorting
<6> hi, could someone help me with a little problem ? http://hashmysql.org/1880
<5> st1lgar: change left join to inner join
<6> that doesn't seem to work lokus.
<5> st1lgar: you did not say what does not work in the first place
<6> ok, I'll try to explain, apparently my description was not too good :)
<2> can we select a specific variable using show command ?
<5> st1lgar: but for sure you do not need left join here, inner join will do
<5> SurcouF: show ... like ... for most show commands
<2> thanks
<6> the left join is there because sometimes there are no records at all in usermeta that match users.ID (on usermeta.user_id) and I still want to see all rows in users.
<2> I've found myerrolog module for moodoss
<7> Can I create an implicit table with >1 rows?
<5> st1lgar: i missed the description, will take a look
<7> I.e. select * from 1,2,3; -- that sort of thing?
<2> it's written in tcl language but..
<6> In usermeta, there can be 0 or more rows that match one user, but at most one with the value 'nickname' for the column 'meta_key'
<5> st1lgar: you will need a left join for that nad remove the WHERE condition
<5> st1lgar: the where cause the user with no usermeta to be filtered away
<6> that is my dilemma :)
<5> st1lgar: test with no WHERE and you will see the result
<8> is there a quick command to dump the structures of every table & db to an output file (like show databases & desc table) without having to do each one individually
<7> Iontas: mysqldump
<6> yes, I know, but I need the WHERE to get the nickname, to be able to sort on it.
<7> Oh, each database. Not afaik.
<5> st1lgar: add OR ... is null
<5> strib: yes it can
<7> Coo, didn't know that
<5> strib: check the help mysqldump --help
<8> ok... so --databases, --no-create-info and --no-create-db?
<5> there is all database, no-data or something
<5> no create info will hide the table structure
<5> lontas: or use the information schema if you are using mysql 5
<8> lokus> on 4
<5> mysqldump then
<9> hi all...does anyone uses php5+mysql on IIS6 ?
<9> im having caching problems with php scripts that store data in mysql
<9> its only user experience question!
<7> Sounds like it's not a MySQL question
<0> caching problems?
<9> strib iknow
<9> its only user experience question!
<7> *sigh* 64% of commands run on my mysql box are "change db"
<9> shannon : yeah: the pages does not refresh...its take a long time to br uptaded even when is changed
<10> is it IE thats doing the caching
<0> 64%????
<0> how is that possible? they would have to run back-to-back
<6> lokus: I still only get the the rows from users that have a row in usermeta that matches meta_key = 'nickname'. I'm starting to think that I will need a union for this.
<5> st1lgar: add OR meta_key is null
<0> Burnys - try [shift]-refresh
<0> :)
<0> but it doesn't sound like a MySQL question
<11> Does anyone know whether MySQLdb (python package) caches its results, and whether it is possible to disable that?
<6> yep, I did that with no success. But let me verify that again, thanks for the help.
<8> --all-databases --no-data --skip-opt worked....thx all
<7> scarfboy: I'm sure it doesn't.
<9> thanks a lot...i know that isnt a mysql questiom, but i just think that if anyone was experienced with this task they can help me
<7> scarfboy: how is it to know that things like 'SELECT NOW()' are mutable, for example?
<9> sorry
<5> scarfboy: but mysql server can cache results
<6> I have added the OR, and added an example of what the content of the tables look like: http://hashmysql.org/paste/viewentry.php?id=1881
<12> If I'm designing a database to hold product information; Items have different sizes. Small, Large, Extra-Large Tall, Small Tall, 28, 32, 34, etc - should I have a table like Sizes: SizeID, SizeName Then have each item lookup the SizeID, instead of a hardcoded Size Name?
<12> Then, like Shirts: ItemNumber, SizeID, Price
<6> lokus, thanks for your help, I got it to work.
<13> fiXXXerMet: What problem would that extra table solve?
<12> mendel: Consistency/Normalization?
<13> If you're just going to add a sizeid/sizename pair every time there's a new sizename, you may as well put the sizenames in the main table. if you have to enforce a set of sizenames, then sure, that's one way to enforce it
<14> If you needed to store "row colors" (for alternating colors on rows of data...this is a user setting, so they can be customized) how would you store it? a table that has user_id, order(so the colors are displayed in the right order), color (stored as 6 character hex)?
<15> hi
<15> get i can predictable random number generation?
<15> (by initializing the generator with a certain number)
<13> predictable... random...? Sure, use "1" for everything.
<13> If you want predictable something, don't use random something.
<16> AaronCampbell: you can either store the 6 char hex so that you can just plop it directly in the html or if you only want certain colors maybe setup an enum for your color choices and a matching conversion in your code
<15> mendel: thanks for the ethical advice, but you can initialize a random generator with a specific number in many languages and i wondered if that is possible with mysql
<14> i\nsomnia: the manual on RAND(): http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#id3204860
<15> pitty
<13> Asking for predictable random numbers is like asking for a red ball that is blue. If you don't want stupid answers, don't ask stupid questions.
<17> need input pls
<18> i\nsomnia: Returns a random floating-point value v between 0 and 1 inclusive (that is, in the range 0 <= v <= 1.0). If an integer argument N is specified, it is used as the seed value, which produces a repeatable sequence.
<13> If you're designing an app based on a particular RNG's particular behavior with a specific seed, your program is broken before you begin.
<18> RAND(N)
<17> trying to bui;d 2 tables in a mysql db
<15> mendel: pseudorandom number generators are predictable
<18> mendel: not at all.
<14> shabbs: Well, unfortunately the users are already spoiled in getting to choose any color. (although I've checked, and ONLY females use custom colors right now) Thanks for the advice though
<15> thanks
<13> Yep, and they're free to change them next version. Oops, surprise.
<17> I put them bot in a install.sql file
<15> mendel: i know what i'm doing thanks
<17> but they fail to make
<16> AaronCampbell: I don't see a problem with storing the hex color code then
<13> Of course you do.
<17> when I run the install script
<13> That's why someone here had to point you to the manual.
<14> shabbs: ok
<17> http://pastebin.ca/58389
<17> this is the file I created
<17> thats not loading into the db
<17> I dont get why
<17> did I miss something
<19> ok and what error are you getting?
<17> customerdb: Module install script failed to run
<17> I am writing a module
<16> well have your module print the mysql error
<16> if it fails
<17> shabb doe the file look right
<0> !tell us about doesn't work
<20> shannon asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<0> I love that one
<16> Tier_1: I'm not an SQL parser
<0> Tier_1 - try running the script manually.
<16> Tier_1: it's a lot easier if you do proper error checking and can provide us with an error. in fact, I bet if you see the error, you can probably figure it out on your own
<16> you lose
<17> looking again brb
<16> :D
<16> 'CREATE TABLE IF NOT EXISTS...'
<0> it's cheating to read the file
<0> :)
Return to
#mysql
or
Go to some related
logs:
connect phpbb with eqdkp
etch graphic characters debian
#python
#asm
#math
+PHP +dotproject +Allowed memory size
ped_file_system_resize call
ubuntu mysql-administrator apt-get
install kinit ubuntu apt-get
#javascript
|
|