| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> that should tell you if the time is spent in the read or the write operation
<1> ndee, How many users do you have? Upgrade the RAM?
<2> I guess to rephrase my question, should innodb support be "enabled" just by starting up mysqld with the following snippet in my my.cnf file? http://jtest.umecit.maine.edu/cnf.txt
<1> ndee, We can't really answer that kind of question. Your app could be Webserver heavy or DB heavy. Doing that may cause FreeBSD from crashing though.
<3> oh oh, i see
<0> less just prevents you from getting flooded with output
<3> yeah
<0> handy when you want all the output but don't want to see it scroll by really quick
<0> pager grep -v Sleep
<0> that's a handy one on a server with a lot of open connections that aren't doing something right now
<3> neat
<3> learned something new ;)
<0> reminds me a bug i have yet to submit.. for some reason setting the pager in your my.cnf will cause mysqldump not to work because "pager" is invalid config directive for it
<3> so, the first select was a little slower, but still not that bad. the rest were cached
<0> even if pager is in [client] section
<0> but yeah...
<0> ok.. from your pastebin, it looks like it's alternating
<0> cache hit; cache miss; cache hit; cache miss
<3> that was just chance
<0> that's why i asked about foreign keys
<3> i could run it a few more times
<3> and get slow slow slow fast fast slow fast slow
<0> seems like something else is changing in the source table or for some reason the cache is getting cleared
<3> nothing else is running... maybe a timeout?
<0> show variables like '%query_cache%';
<4> I just updated my gentoo instalation, and now my c++ cgi programs does not work. it is the part where the program connects to the mysql database. using mysqlpp::Connection connect(); I get 500 returncode from apache. Why can my c++ program not connect anymore?
<0> actually, check out this page: http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html
<1> Mc_Fly, Do you have a complete error message?
<5> hi ll
<5> hi all :)
<1> What did you upgrade?
<5> I'm getting this error sometimes how can I fix it , "Lost connection to Mysql server during in adodb-mysql.inc.php"
<6> !tell us about evil
<7> litheum asked me to tell you this: Evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html
<4> will: If I run a simple program that just tryes to ceonnect I get "segmentation fault"
<5> and I need to restart mysql server after that error :-/
<1> !m w1z3r gone away
<7> w1z3r: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<4> will: mysql for one
<1> Mc_Fly, I don't think your program is catching errors. What version did you have previously? What is it now?
<1> Trix are for kids.
<5> eh lol
<5> well any solution exists ?
<1> !m w1z3r gone away
<7> w1z3r: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<5> sorry didnt see that :)
<1> :)
<4> will: 5.0.19 and mysql++ 1.7.26
<1> Eww, mysql++
<4> will: I use that with c++ to connect
<1> Suggest not using that, as it's not an official MySQL product.
<1> You can use the regular C API
<4> will: Well It used to work fine :-)
<1> Mc_Fly, What version did you upgrade from?
<4> will: I can't remember
<8> hi, how would you deal with things that sometimes are visible, and sometimes not.. say i got 6 deduction types: SUB_TOTAL_AMOUNT, SUB_TOTAL_PERCENT, SHIPPING_COST_PERCENT, SHIPPING_COST_AMOUNT, then i got 2 that the people should not see in the voucher selection, say PAYMENT_TYPE_AMOUNT or PAYMENT_TYPE_PERCENT (these get chosen if they pay per CC for example).. to generate the list ,would you use another field (visible y/n) or filter by the type di
<1> Mc_Fly, That ****s.
<4> will: The mysql server woorks fine :-) I can stilll use phpmyadmin
<1> Mc_Fly, Run <?php phpinfo(); ?> and tell me the mysql client library version it's using. (will be in the mysql section)
<4> will: so I guess it is mysql++ that is causing the trouble or perhaps mysqld does not accept cgi connections? Could that be??
<1> I'm guessing mysql++
<1> !m Mc_Fly old client
<7> Mc_Fly: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<1> Just a guess...
<4> will: Client api: 5.0.19
<1> Try that link ab ove
<8> answer slaves!
<4> will: well, I have 5.0.19 so that link will not really help will it?
<1> Mc_Fly, PHP uses the 5.0 client library, but your mysql++ might not.
<1> There is a real easy way to try it out though :)
<1> Hint: OLD_P***WORD
<1> Jax, I have no idea what you're asking...
<8> well the question is, should i make a param in the db, `visble` or just filter by type in the application
<8> i will give you a picture of my sister with gun in exchange
<0> jax, are we talking 2 different sets of data or 2 different sets of fields
<0> jax, or 2 different sets of eyes viewing the data
<8> i got an ENUM(SUB_TOTAL_AMOUNT, SUB_TOTAL_PERCENT, SHIPPING_COST_PERCENT, SHIPPING_COST_AMOUNT, PAYMENT_TYPE_AMOUNT , PAYMENT_TYPE_PERCENT)
<1> Jax, Sure... pic... :)
<8> and then i got some DeductionList cl***, which gets the deductions for this user (i.e the ones he/she didn't use yet)
<8> and displays them on the checkout page
<8> but, the payment type ones, shouldn't be displayed
<8> i.e not selectable (they are FORCED on the client)
<8> because he has to pay more because of certain conditions, or so
<1> Jax, Your application should determine what the client sees.
<8> hm
<8> but then i have to do something like...
<0> true but a flag would let him determine which are which as far as which to pull from the database
<1> Not at a DB level. You can set what type it is (CC order), and the app sees that it is a CC and shows what it needs.
<1> Pull them all.
<8> if(deductionType != 'deductointypeX' or deductionTypeY) display
<0> if you need to pull them all for the sale, then a flag is unnecessary
<1> Maybe I'm lost...
<8> hm i guess i could juts code it in the app..
<1> Why do you have that above ENUM?
<8> i.e SELECT ... FROM deductions WHERE type NOT LIKE 'PAYMENT%'
<8> or so
<8> why not?
<8> would you make it a varchar?
<1> I would have a table that has every one of those elements as their own column.
<1> Depending on value type
<8> hm again?
<1> Is this for a sales order?
<8> yeah wine shop still
<1> I have no idea where you work/ed
<1> Ok, you have a sales order table. In that table, it contains like name, address, etc. Also contains SUB_TOTAL_AMOUNT, SUB_TOTAL_PERCENT, SHIPPING_COST_PERCENT, SHIPPING_COST_AMOUNT, PAYMENT_TYPE_AMOUNT , PAYMENT_TYPE_PERCENT, each as a column.
<8> 1) basket -> 2) deduction -> 3) payment type (add payment_deduction etc if he pays with e-banking) -> 4) checkout
<0> the enum would be faster than a varchar
<8> will no, the deductions are always in the deductions table which has these fields:
<1> Wait... huh?
<8> DeductionID UserID OrderID Amount Used Note Type DateConfirmed DateAdded
<8> OrderID is NULL until ***igned to an order (at checkout)
<8> and Type is that ENUM
<8> with the possible deduction types
<0> this is a table holding deductions that a user can apply to an order... that's my take
<8> yeah
<0> some automatically apply
<8> and also ones we give him
<8> like if a bottle breaks
<8> yeah we need to force some on customer
<8> i.e ones that are NOT selectable ;)
<0> and he wants to differentiate between the forced ones and the optional ones
<1> ahhhhhh
<1> User defined deductions...
<8> not sure if i should even seperate by table
<1> Yes
<1> That way you can dynamically add as the business grows.
<8> hm
<8> ok so you'd make 2 tables with exact same structure...
<8> and then also 2 cl***es, which do exactly the same thing.. basicaly
<8> ForcedDeductions, UserDeductions
<1> No
<8> ForcedDeductionsList, UserDeductionsList
<1> That would be a flag. Status flag.
<8> hm well that's what i was asking
<1> Why didn't you ask that in the first place! :)
<8> hah
<8> actually, i wanted surcharges, and deductions in same table
<8> but then, couldn't ifnd a name for the cl*** holding a list of them lol
<8> so put them in 2 tables
<2> So, gonna try my question again ;). I was under the impression that all you had to do to enable innodb support in mysql was to uncomment certain lines in my.cnf like so http://jtest.umecit.maine.edu/cnf.txt but even after restarting mysqld the software it isn't detected. Is there something else I need to do to enable innodb support?
<8> DeductionsSurchargesList gahism
<1> CosmicHippo, Are you using Gentoo?
<2> will, slack 10.2
<1> How do you know you don't have InnoDB support?
<8> she's nuts haha
<2> Well, in essence, I'm using this aspect of mysql with a specific kind of software that I install on top of it. (request tracker software). In all previous dependency-checks with other systems, there have been no problems, but now all of a sudden after I had to reinstall mysql it doesn't like it
<1> oh
<1> Jax, Good night. Want some good dreams tonight.
Return to
#mysql
or
Go to some related
logs:
#python
ldap +libpam +libnss-ldap +etch
#php
defpackage :use is undefined
asterisk dead but subsys locked
filadoda
sp_executesql chain
realtime-lsm gcc-3.3
#linux
bash programming if syntax -e -r -x
|
|