Osaile: And thread stack is 256k.
Franks: Avoiding going to swap is also useful.
Osaile: How about “percona reviewed it and they didn’t notice that either”? Lol.
Moag: Well, if you’re overly conservative and will never come near the amount of ram that you have, perhaps.
Moag: But i would never risk it on a production box.
Moag: Which reminds me when we got smacked by rackspace for adding a swapfile on the fly on a vps.
Osaile: I don’t seem to see used ram peak above steady state during traffic bursts, bulk loads, etc.
Osaile: Maybe if i had many large simultaneous requests?
Osaile: 5gb seems a lot of headroom.
Sudo: Unsure of standard practice. Is this fine? Encrypt’firstp***word’, concat’$6$’, substringsharand, 16, ‘email1example. Com’.
Hostler: I’ll read any writeups anyone wants to send me, too.
Hesselink: What are you trying to do?
Mayton: Hey so this is a bizarre question, more looking for the right channel to join, but is there a channel that is not so much mysql specific, but more for general database questions?
Kwaterski: I have a crazy idea that my just work for my industry, and i need some people to Batterson ideas off of.
Correl: Actually, setting up postfix and friends. Not interfacing with php right now, but that doc says it uses unix’s crypt which is what mysql’s encrypt uses so if that’s standard i guess i’m all set.
Childress: Depends on the question. If you’re using mysql, then it’s ok to ask here.
Childress: Crossdatabasecompatibility ****s. The sql standard has lots of “up to the vendor to choose” things, so many things aren’t handled the same.
Wachowiak: Oh, here we go, the wikipedia page on crypt explans these $ identifiers. Cool.
Lavgle: Everyone says ‘use bcrypt’ so i’ll probably be using bcrypt!
Heimbach: Ok. So i am using mysql, and i work in the portfolio recovery industry. And something that statistical ****ysis on my part has borne out is that people with names that are steretypical with certain ethnicitiesraces are more or less liely to pay their debts. When purchasing portfolios, we are usually given access to a limited version of the database that allows us to see names, states and a few other things, but none of the inform.
Fross: Ation of the actual debts. What i would like to do is setup a way to essentially check the composition of the portfolios based on raceethnicity to decide if it is worth purchasing. I am thinking in mysql the best way would be to set up a table for specific racesethnicities and run queries to see how many entries from each table are present in the portfolio. To do this i would need something like a dictionary for racialethnic n.
Gildow: Ames per group. Does this make any sense to anyone here?
Cassiday: Also, would be setting up categories for old people names, as they tend to be less likely to pay as they are usually on social securityssi and they know they cant be garnished etc.
Cintora: So they just dont care.
Presler: Any idea what would be the best way to set up something like this?
Antony: Start with a normalized schema, as it should make extracting groups easier.
Childress: It sounds like what you’re asking for is very much business logic. Mysql can help with that, but it’s only one piece. A query can only help with providing the data to the question, but not provide you with “yeah, buy it”.
Pickney: Yeah. I am thinking for each table, i would have something like a firstname and lastname field. My issue is going to be finding the data on what names are common in specific racesagesethnicities. I am also thinking i will probalbly have a few things that rae just partial names that are mroe common in specific groups, such as any name ending in kwon.
Erskin: Or any name starting with mc or mac.
Antony: I agree with Childress.
Childress: You may have already done it, but the important part about everything is defining the rules and percentages used to determine your options. You should be able to do this with using a spreadsheet with paper. Then you can convert it to mysql.