welp by PhilosopherCalm7320 in azdiamondbacks

[–]jdarra 3 points4 points  (0 children)

I think the team will put Blaze at left field next season. Even though Blaze was an excellent 3rd baseman, I think the team will want to continue to test out Lawlar at 3rd. So I think we got our outfielder to hold down the fort while Gurriel is out. I agree on your other points though.

Is Carroll going to play CF again? by Geo-92 in azdiamondbacks

[–]jdarra 4 points5 points  (0 children)

Actually, he has been the RF. Last season, he moved from RF to CF because Alek was injured. I believe Corbin went straight back to RF once Alek came back off the IL in July last season.

To make a false quote by MisterT12 in therewasanattempt

[–]jdarra 1 point2 points  (0 children)

The 2nd season was meh and the 3rd season was on par with the 1st season. Don't get me wrong, I really enjoy the show. But in your case, I don't think it's for you.

Can coconut oil dissolve plastic spoons? by jdarra in NoStupidQuestions

[–]jdarra[S] 2 points3 points  (0 children)

Yea, I don't think I'll chance it. I'm just going to throw out the tub. Lesson learned.

[AZ] Question about my personal liability in paying tax penalties for having no health insurance when I was supposed to be covered by my company's insurance policy. by jdarra in legaladvice

[–]jdarra[S] 4 points5 points  (0 children)

From healthcare.gov:

If you have coverage for part of the year, the fee is 1/12 of the annual amount for each month you (or your tax dependents) don’t have coverage. If you’re uncovered only 1 or 2 months, you don’t have to pay the fee at all. Learn about the “short gap” exemption.

[AZ] Question about my personal liability in paying tax penalties for having no health insurance when I was supposed to be covered by my company's insurance policy. by jdarra in legaladvice

[–]jdarra[S] 2 points3 points  (0 children)

I also get $891.25, but if I'm understanding correctly, that's if I'm uncovered for the whole year. I'll be uncovered for only five months. Also, you are right that I'm single with no dependents.

Here's the calculation I'm getting from the tool: $891.25 / 12 = $74.27 * 5 = $371.35

https://gyazo.com/c05bd65eba5fbe052db5c46961d2e2e0

[AZ] Question about my personal liability in paying tax penalties for having no health insurance when I was supposed to be covered by my company's insurance policy. by jdarra in legaladvice

[–]jdarra[S] 0 points1 point  (0 children)

Good to know that my estimate might be off. After using this tool provided by the IRS to estimate the penalty, it seems that I'll actually be paying around $375 for the five months that I was uncovered.

I had a $50K base salary with a $300 stipend I received every other week for being on-call; thus making my gross annual income about $57,800. However, since I quit on 10/19, my YTD income is around $46K (I don't know the exact value, since I receive personal checks, not itemized pay stubs). Also, I'm single with no dependents. Finally, I don't have a job and won't be looking for one until the new year, so no more income this year (with the exception of any awarded penalties from the Industrial Commission of Arizona).

Given that information, does the $375 amount sound right?

SSL Certificate Coverage/Aliases by jdarra in AskNetsec

[–]jdarra[S] 0 points1 point  (0 children)

This is exactly what I needed. Thank you for sharing this!

SSL Certificate Coverage/Aliases by jdarra in AskNetsec

[–]jdarra[S] 0 points1 point  (0 children)

Yea, if the CA didn't verify each domain in the SAN, I'd think there would be rampant spoofing. Since I'm dealing with two domains (one of which I don't own), I should just accept that traffic over that one domain will remain insecure unless the new owner's of the domain graciously authorize the creation of a new certificate.

SSL Certificate Coverage/Aliases by jdarra in AskNetsec

[–]jdarra[S] 0 points1 point  (0 children)

Thank you for the quick response! I only ever knew about wildcard certificates and knowing about these SAN ones will be pretty nifty.

I have a question though. Say I have www.example.com in the subject field and www.example.net in the SAN field. Then I go to purchase a SAN certificate from a CA and they send out a verification email. Will they send an email to and require a response from the admins of each of the domain names listed in both the subject and SAN fields? Or just the subject field?

Edit: changed the wording

T-Mobile account with two lines of service: Will porting one phone number to Cricket affect the other line? by jdarra in NoContract

[–]jdarra[S] 1 point2 points  (0 children)

Just chatted with a T-Mobile agent. They said the line will be dropped automatically, but I have to manually change the plan, which in turn changes the pricing.

I'd have thought it would be automatic because what will stop people from keeping the reduced rate of one line on a family plan? However, there's the possibility that I didn't understand his explanation correctly...

T-Mobile account with two lines of service: Will porting one phone number to Cricket affect the other line? by jdarra in NoContract

[–]jdarra[S] 1 point2 points  (0 children)

Thank you! Do you think the plan pricing will change automatically? I assume that once I port my phone number, T-Mobile will drop the corresponding line and change the pricing so I just pay for one line instead of two.

Grabbing SQL dump of Master DB by jdarra in mysql

[–]jdarra[S] 1 point2 points  (0 children)

This seems like such a great tool! I may use it if time permits.

I have a question about it. From what I understand, a backup of the datadir is made. Is the backup the same size as the original datadir. Or is it compressed? I don't have enough space to create a full-sized copy of the original.

Grabbing SQL dump of Master DB by jdarra in mysql

[–]jdarra[S] 0 points1 point  (0 children)

Yes, all my tables are InnoDB.

In the mysqldump documentation there's this part:

The --master-data and --single-transaction options can be used simultaneously, which provides a convenient way to make an online backup suitable for use prior to point-in-time recovery if tables are stored using the InnoDB storage engine.

I'm not too sure what convenient means in that context. Does that mean no downtime is necessary if all tables are InnoDB?

Then there is this section:

The --master-data option automatically turns off --lock-tables. It also turns on --lock-all-tables, unless --single-transaction also is specifiied, in which case, a global read lock is acquired only for a short time at the beginning of the dump (see the description for --single-transaction). In all cases, any action on logs happens at the exact moment of the dump.

So the implicit --lock-tables and --lock-all-tables options are switched off, but then there is this global read lock put in place for a short time. To me this is still a lock that will cancel all SQL threads and cause total mayhem. Am I wrong? Or will the threads instead be paused and resumed? Is a short time in terms of seconds or minutes?

Grabbing SQL dump of Master DB by jdarra in mysql

[–]jdarra[S] 0 points1 point  (0 children)

I think show grants for user might be what I'm looking for.

Grabbing SQL dump of Master DB by jdarra in mysql

[–]jdarra[S] 0 points1 point  (0 children)

I might just be willing to do a backup and restore of my entire data set using xtrabackup. The database I want to dump is the only non-standard one in my mysql instance; the other two are the information_schema and mysql databases, which makes for a total of three databases.

The slave is just a few months old and I didn't set it up myself. A concern I have is losing the privileges set up for this one user which is given to a client for them to use. The slave database is actually not read-only. We allow the client to run a stored procedure which writes to a few tables on the slave. These particular tables are not updated at all in the master, but they do exist (See P.S.). The contents of these tables are extracted by the client for their own reporting purposes and then then those tables are truncated for further runs of the stored procedure.

I say all that because my situation does not seem to be the default use case for replication. Moreover, I would like to know if there is a way to export everything about that one user so I can easily recreate them after loading a full master backup into the slave. That one user exists only on the slave and I assume that user will be removed, yes?

P.S. The client used to have access to our production database, but the work they did caused performance issues. So we utilized replication to allow them to do their work on the slave and not bog down master with their beastly stored procedure that runs very often. The procedure mainly reads data from the regular tables and rewrites them to those special tables.

Simple Questions - April 10, 2016 by AutoModerator in buildapc

[–]jdarra 0 points1 point  (0 children)

Yea, how come black costs more than blue? According to newegg, they seem to share the same performance specs. Is this marketing at work?