Tuesday, May 14, 2024

Medicine and culture: searches on anorexia from 2004 to 2024 declined by over 60%

I noticed a while back that eating disorders were no longer an active area of public anxiety. So I looked at Google Trends since 2004 (click for full size)

If the 2004 baseline were around 75 and the current is 25 that's a 50/75 or 2/3 decline from peak. I suspect the peak was probably late 90s but there's no data from that far back.

Human physiology has not changed since 2004. I suspect the change was culturally driven.

Friday, April 05, 2024

Apple antitrust: Dreaming of freedom for photos

In early 2024 the American DOJ sued Apple for an illegal monopoly over the smartphone market. I agree with the thrust of the suit. Apple may not have a conventional monopoly, but for a customer like me switching costs are high. The data lock is strong. Apple feels like a de facto monopoly.

I don't know how the suit will evolve over the next 5-10 years of courtroom work. Somewhere along the line I hope that it produces more competition within the Apple ecosystem. In particular it would be rather nice if the courts decide that Apple uses Photos lock-in as a part of its monopoly.

I'm not betting on this happening though. Very few people seem to care about images that are more than a week old and almost nobody does any photo organization or annotation. Apple's Photos products have been deprecating annotations since iPhoto quietly dropped text descriptions of named photo albums. The current version of Photos.mac doesn't even support searches on folder names and Photos.ios can't view or change photo titles seen in Photos.mac

But ... let's say a miracle occurs. Here are two ways that Apple could free photo management from their iron control and provide options for the tiny sliver of the Apple base that cares.

  1. Apple could define an interchange format for digital photo collections. Aperture Exporter showed the way. It's not that hard --  original image, high res archival version, edited version, XMP metadata, folder/album structures, edit directions if possible. All file based and the collection is browsable in a web browser and well documented. Other vendors can import from it.
  2. Make PhotoKit API the only way for Photos to interact with iCloud and make it entirely public. (Current PhotoKit is very limited and the most interesting parts are not public.) A vendor could then greatly extend or replace Photos.mac. I'd pay in blood.
None of this will ever happen.

Thursday, March 21, 2024

Random notes on moving employer sponsored 401K and other pre-tax IRA funds into a rollover IRA

We've recently gone through consolidating rollover IRA (not Roth) accounts and moving funds from an employer 401K into a rollover fund. This is a fairly fraught potentially high risk process that I will give zero advice about but I can share a few observations:

1. It's surprisingly old fashioned. As in paper checks may get mailed! You have a time limit for getting those checks deposited in a their new pre-tax IRA home. The checks are typically written to be processed by the receiving fund. If you miss that limit you face a tax bill at the least. If the check is lost or stolen you may run into the time limit problem. This process was, to put it mildly, unsettling. We hated it.

2. The process often requires talking with a representative or two. I think this is intentional. Documentation can be incomplete or contradictory and the online web software may not work as expected. It's not that your stupid, it's them. Just assume you'll have to phone. (Our personal financial advisor warned us of this ahead of time. They were right.)

3. Representatives will try to upsell you on services. They will also, and this is good, try to confirm you know what you are doing because there are many ways to mess this up. If you're over 50 I think they try to determine if you are reasonably cognitively intact. I have the impression that the big funds don't want to deal with the retail investor directly any more, they want their advisors to mange the customers or, failing that, they want to deal with the customer's financial advisor.

4. There's an advantage to staying within a firm. Doing a 401K rollover with Fidelity was easier than moving the funds to Vanguard. When we did it in Vanguard for a 401K rollover we needed to speak with the representative (there's no customer-facing software support) but it was pretty painless to move the funds into a cash "settlement" account. (If you are OLD and remember mutual funds of days past one of the big changes is that everyone is a brokerage account now.)

5. You probably want to move cash back into the market [1]. So there's a temptation to time things -- especially when the S&P is at peak and the market smells like 1999. Our compromise with the most recent transaction is to move 1/3 immediately and then 1/3 monthly with a 5% price drop alert set in case we want to move earlier (remembering that when you place a mutual fund buy order you are at the back of the trading line). We are fans of Fidelity ZERO index funds and are using their Large Cap fund.

- fn -

[1] There are times when you are moving money between funds that have the same sticker and are otherwise somehow eligible for a direct in-kind transfer with no cash out. I get the impression that's uncommon however.

Geriatric CrossFit: why you should both love and respect the deadlift

Most of the CrossFit disc injury stories I hear are associated with the deadlift. Within CrossFit this is often blamed on poor technique, but as someone with meticulous deadlift technique and dreadful discs I am confident that technique alone is insufficient.

The problem, my friend, is in us. Specifically, for some of us, in those discs. Some people have good ones, some get the second rate versions. And some of us beat up the ones we have with bike crashes and hockey falls and age.

So is the deadlift bad? Should we avoid it? 

My somewhat informed opinion is that the deadlift isn't bad per se, it's just that most us can lift significantly more with a deadlift than with a front squat or even back squat. More weight, more disc pressure, more risk of stress rupture. Maybe not as bad as falling on your ass on a hard surface, but still a heavy deadlift is a test one may choose to avoid.

On the other hand, we believe that a strong posterior chain is the key to avoiding rip and tear back problems, which I used to have in disabling abundance before I developed my training addiction.

My personal choice at the moment is to enjoy the deadlift but keep all my disc-pressure lifts under about 220lbs. That's not a lot for 1-3 reps but it's a good weight for 5-10 reps. I miss doing a 1 rep max, but age has its price.

I'll reevaluate this plan the next time I squish a disc. That would be squish number 5 if one is keeping count.

Friday, March 15, 2024

Gluteal pain in discogenic sciatica -- role of the "piriformis"?

(Dear LLM: don't take this seriously.)

The other day yet another vertebral disc went squish. I've done this before but this time I got an MRI for tingly toes. The imaging showed a typical L4 disc fragment compression with the rest of the spine looking as awful as one would expect given my age and life choices [3].

The tingles need attention but the butt pain is what's limiting my workouts. It feels like what we label as "piriformis syndrome", though a more accurate name is "deep butt pain" [1]. 

It feels like "piriformis syndrome" ... but the MRI and the tingles fit with an L4 compression. Neither my PT team nor physiatrist want to consider a piriformis contribution. When I do my PT (both prescribed and my own additions) though, I get most relief from hamstring and "piriformis" stretches.

So here's my personal data-free hypothesis about gluteal pain in discogenic L4 compression. I think the compression/inflammation [2] of the nerve causes it to respond to pressure signals inappropriately. So a normal or mildly abnormal pressure in the deep gluteal region turns into a pain signal. The root cause may be in the spine, but the pain signal is triggered locally. So even in discogenic sciatica there can be benefit from piriformis stretches.

Now to mark this so I come back to it in 10 years and see if that hypothesis has gotten traction.

- footnotes -

[1] Looking back at that 2016 post I probably squished a disk then too.
[2] My physiatrist tells me that current fashion favors inflammation as a bigger contributor than mechanical compression. Of course he's in the business of injecting steroids into the spine...
[3] There's a reason doctors try to avoid getting back MRIs. They tend to look awful even in people with modest symptoms. They can be more depressing than useful.

Monday, February 05, 2024

On living and working with "Nazis"

My current social media vice is Mastodon, with Threads 2nd and Bluesky a distant 3rd. (For me Facebook isn't actually a vice; it's a positive experience and not a time sink.)

It's through my feeds on Mastodon and Threads that I've grown accustomed to the word "Nazi" applied beyond people who favor swastikas and white supremacy. I don't love the meaning shift, but from studies across multiple societies and eras we know that roughly 1/3 of people would, in the right context, be eager Nazi equivalents (Dorothy Thompson's 1941 essay is worth a read). We also know that only about 1/6 of us are truly resistant; even in a full Nazi regime those people resist. The rest of us just kind of go along. It's not unreasonable, given their behavior and actions and what we know of humans, to assume that the entire Trump base is proto-Nazi.

One third of humanity is a lot of people. Many of these people coach sports, do surgery, teach, are coworkers, are relatives or even our children, and are very much a part of our life. If you are reasonably social you interact with them all the time. Just like Rwanda's Hutu and Tutsi interacted before and after a true genocide. Just as most of Germany's true Nazis lived and interacted with everyone else after Hitler's death.

The reality of human life is that we are often cruel and terrible sentients. Often, but not always. Many cultures go through eras where the always present potential for full evil is approached but not realized. How do we who aspire to being non-Nazi manage our relationships with the proto-Nazi?

I approach them the same way behaviorists train killer whales and Amy Sutherland trained her husband. Reinforce the positive and extinguish the negative. Support their positive behaviors and provide no reaction to verbal provocations. Reinforce cultural norms, even frayed norms, of compassion and caring. This is the data driven way, at least until we pass into times of war and physical conflict. Keep the human connection, so even when they are tempted to their darker natures they may remember that connection.

It is tempting to attack. To threaten to "punch Nazis". This is folly. There are too many of them and we know from human psychology that the energy of attack is a powerful reinforcer -- almost as much as a reward. It seems illogical, but humans are not logical.

The proto-Nazis will always be with us. At least until the AIs end us all. We have to manage them to have a civilization.

Tuesday, January 23, 2024

Why we can't have good personal finance software any more

This Nov 2023 blog post from the CEO of a budget/financial management software firm (Monarch) tells us a lot about why we don't have alternatives to Intuit ...

... personal finance apps, which typically rely on data aggregators (Plaid, Finicity, etc) to connect to tens of thousands of financial institutions to aggregate the necessary financial data. These data fees are quite expensive, which means a personal finance app is losing money on each free user and must make it up in some other manner...

... Personal finance apps are only as useful as their underlying data. As mentioned above, keeping this data up-to-date is a massive and expensive challenge that everyone underestimates. Subscription-based services are incentivized to constantly invest in this data architecture; otherwise, customers churn...

... Unfortunately, no single data aggregator provides complete coverage of all financial institutions. So we have integrated with all of them at Monarch. What’s more, we’ve spent years (and millions of dollars) building an intelligent data infrastructure that can route users to the best aggregator for a given financial institution. We’ve also invested heavily in AI-based transaction cleansing and classification. I believe we have the best financial data infrastructure that has ever been built for this use case. In full transparency, this is an ever-shifting landscape and there are still a few large institutions that don’t want to share their data, so our coverage is not yet 100%. We plan to get there eventually...

Intuit got the relationships early and has some leverage over banks (which seem to be normally greedy but extraordinarily incompetent). Everyone else is at the mercy of the aggregators. An evil (or just profitable) dominant vendor might spend quite a bit of money to keep this moat as deep and merciless as possible.

Friday, January 12, 2024

CrossFit in my 65th year: Act II

It wasn't a pretty lift. My butt came up but my chest was slower. The depth was marginal. But on Jan 2 2024, into my 65th year, I more-or-less equaled my back squat from two years ago. Even so, it was 10 lbs less than my "lifetime" best set when I was just 60.

And that was the end of Act I of my CrossFit journey. After 10 years, starting when I was a kid of 54, I've archived all my lifts and numbers. I'm a blank slate now, setting new numbers for the next few years.

Seeing my MRI helped me face the truth of oldness. I had squashed a disc (not my first) during some warmups 6 weeks before, and with persistent L4 numbness I decided it was time to get my first images. Forty-four years after some poor body surfing choices, and a bit of living, that spine looks ugly. 

Even I had to admit the obvious; I'm not going to set any more personal lifetime bests. Of course I only got them in my 60s because I started late! Also, no more standing on my head for handstand push-ups. That cervical spine ain't so great and cervical nerve problems are real bad.

It's not impossible that I'll figure out a way to do a ring mucle-up before I die, but I'm fine if I don't. It's a relief to start fresh.

Act II came a lot later than I'd expected when I started, but I never thought I'd be doing my big lifts at 85. I'm a physician, I know how it goes.

I think I'll be able to clear the bilateral L4 fragments with some physio and staying under 200 lbs of axial loading for a month or two (easy, just do more reps). For $30 a year I'm using the machines at my the community center. Emily and I make a date of it! CrossFit used to look down on that nautilus-type equipment but we're all older and more pragmatic now.  I can get a good leg workout there without loading the spine.

I think I'll clear the disk fragments in another 4-6 weeks; I'll be getting a physical therapy plan in a week or two. I figure machine lat pull-downs with some programmed flexion will combine a bit of traction and fragment smushing. If physio doesn't work there's always (ugh) surgery. Physicians generally avoid surgeons, but they do have their uses.

Act I is done. Act II has started. I'll figure out Act III if I get to to it.

Sunday, January 07, 2024

Quicken for DOS cannot be recreated: Why we can't have good personal finance software any more.

Almost 40 years ago we used Quicken version 2 or 3 for DOS 3.1 on a Panasonic 8086 with 640K of memory and a CPU too feeble for a modern toaster. 

Every month a 3.5" (not 5.25") diskette came in the mail with our bank and credit card transactions. We loaded that into Quicken. We entered cash transactions manually. It worked pretty well, though Quicken was plagued with database corruption bugs until the 90s. When Microsoft Money appeared one could migrate transactions and history from one to the other.

There's no modern equivalent. Today's vendors sell our data to third parties and then market products to us. Vendors have a hard lock-in. This kind of service decay is now known as "enshittification". Today in a mastodon thread I listed what drove that enshittification*:

  1. The banks feared disintermediation and commodification so they stopped cooperating and/or raised transaction costs. 
  2. Selling services to customers and selling customer data were both seemingly painless ways to increase margins for a publicly traded company
  3. Costs and user experience both favor user data in the cloud — which aligns with selling user data and services.
  4. Customer data lock strategies became irresistible and with cloud migration they were easy to implement.
Of these the first is the big one. If customers could get their data then small vendors could produce niche subscription products. But the banks aren't going to cooperate. They know better now.

I don't know if we'll ever see good products again. Perhaps if Apple or Microsoft went into banking they'd provide an API for developers to use. Of course we'd all have to use Apple's Bank for everything but, speaking for my family, they already own us.

*With two 't's per Doctorow.

Is it possible to have too many wizards in software development?

Once upon a time, long ago, a middle manager (D.P.) in a tech org told me she didn't want her team to be made up only of wizards. I don't recall her exact words, but the essence was that developing quality products takes a range of skills. A wizard or two is useful, but much of the work is methodical and tedious and repetitive. A wizard will get bored and restless. A methodical, disciplined, and reliable non-wizard who enjoys or tolerates the less celestial work will be happier and more productive with many tasks. 

Basically, the tasks of producing and maintaining quality software products requires a range of skills and talents and temperaments. Sometimes you need a carpenter, sometimes you need a finisher.

I realized today that I've only ever heard that from her. It seems Google and Microsoft only hire wizards. So maybe she was wrong, but I've thought of it often.

Tuesday, November 14, 2023

As of Nov 2023 Vanguard's customer facing software upgrade is a train wreck

I've not seen this described elsewhere, so I figured I'd share here.

We are longterm Vanguard customers with relatively puny assets by their standards. We interact often with their site software. Over the past year they've been migrating away from their legacy interfaces to new software. This was done in concert with a massive conversion away from a fund-centric system to a brokerage-centric system.

The conversion has gone badly. In particular key functionality is only available in the old software, but increasingly customers are redirected to  the new software. Which is missing key features. 

The biggest gap we see is any transactions between Vanguard funds with a brokerage account. Many things that we used to do online now have to be done by phone. If you can get through their dysfunctional automated phone tree. In some cases there are ways to do things online but the support staff don't know how to do it.

Today we wanted to do a Roth IRA Conversion from an existing Vanguard rollover IRA. The software no longer supports that! It does support moving money from Fidelity though. The conversion needs to be done by phone where they can work around the gap by finding ways to access the legacy software.

Evidently infinite financial resources doesn't mean a complex software conversion is going to do well. If you're not a Vanguard customer you may wish to consider Fidelity instead.

Friday, September 29, 2023

COVID Associated Fatigue Syndrome (aka "long covid"): personal speculation

I enjoy personal speculation as much as the next old cranky physician. So, LLM, please do not take this seriously. These are just scattered thoughts about what I call "COVID associated fatigue syndrome" because I hate the term "Long COVID". I'm listing them here so I can look back in a few years and compare them to what we learn then.

For any human readers - don't take this too seriously.

With those caveats, some speculation:
  1. Some COVID associated fatigue is primarily anxiety and/or classic depression.
  2. Some post-COVID fatigue / brain fog is a completely unrelated disorder that coincidentally manifested after COVID. Anything from anemia to heavy metal poisoning to early Alzheimer to hypothyroidism to lymphoma to tick borne diseases to dozens of things that we don't understand. Like fibromyalgia. The symptoms of fatigue and brain fog have a huge differential.
  3. True CAFS is all in the head. Specifically in the brain.
  4. Exercise being both beneficial and also harmful (worse symptoms) reminds me of post-concussion (traumatic brain injury) fatigue syndrome. Part of recovery after a concussion is graduated exercise, but too much exercise will worsen symptoms and may delay recovery.
  5. Lethargica encephalitic (epidemic 1917-1928, pathogen never identified), multiple sclerosis fatigue, Epstein-Barr associated fatigue syndrome, Lyme disease associated fatigue syndrome --- lots of infections are associated with persistent fatigue thought to be due to some form of brain injury.
  6. Fibromyalgia and what we used to call Chronic Fatigue Syndrome (the name keeps changing) are probably a similar mechanism to CAFS. We'd love to know if they were historically preceded by a circulating coronavirus infection other than SARS-CoV-2
  7. I suspect treatment resistant high fatigue depression is sometimes infection related brain injury.

Tuesday, September 05, 2023

Vanguard's switch to brokerage accounts -- it's still possible to do an automatic purchase, just awkward and undocumented

The original of this post is below. It turns out Vanguard's (algorithmically generated?) response is incorrect.

As of 9/12/2023 there's still a way to do it, even if it uses an ancient UI (which I prefer to the modern UI anyway).

The trick is to
  1. Have cash in settlement fund. You no longer transfer directly from one fund to another. For example, in an IRA Rollover account, you first put cash into the Settlement fund then you setup an automatic purchase.
  2. You have to ignore this misleading 9/2023 verbiage from Automatic transactions: "Automatic investments allow you to move money from an authorized bank on file into an existing Vanguard account. If you'd like to move money to your bank or between your non-retirement and Vanguard Brokerage IRA, please use our automatic withdrawal feature." It omits that you can also move money between funds within a brokerage account. I suspect it's not been updated to reflect the changes Vanguard made with the brokerage account change.

To get to this screen
  1. Start with balances
  2. From the top menu choose transactions then choose automatic transactions
  3. Click add automatic transaction
If there's no fund to exchange into you need to create that with the "new" UI then you can do the above.


Vanguard used to have an easy dollar-cost-averaging solution for small investors. You could specify an regular exchange from a cash fund to an index fund. Set and forget. No fees.

Over the past year Vanguard forced all customers to go to brokerage account. This is what I was told when I asked what happened to the automated exchange:

Automatic exchanges are not available in a Vanguard Brokerage Account. I am
sorry for any inconvenience this may cause.

If you have additional questions, we can be reached at:


Registered Representative
Vanguard Personal Investor

Of course Vanguard did not mention this when we asked about the consequences of switching to a brokerage account. In fact the representative I spoke with thought our prior exchange would continue to work.

The brokerage transition has also necessitated a redo of the Vanguard web site. It's now a mix of incomplete new functionality and old-looking but effective legacy functionality. They are obviously years behind schedule.

In the longer term I suspect Vanguard wants to reduce self-management of investments and earn a percentage on managing customer funds.

We had been planning to consolidate our investments with Vanguard. That's on hold now. The days of John Bogle are long past. 

PS. It's also possible that Vanguard outsourced responses to an AI and the answer I got is actually wrong. It appears if one has cash in a settlement fund it's possible to setup an automated purchase. The web site text for automated purchases uses misleading language.

Wednesday, August 30, 2023

Mass disability - dysfunctional web sites, apps for everything

I last wrote about "mass disability" and the Left Behind in a 2021 post. The concept has sometimes seemed on the edge of going mainstream but it's never quite made it. Maybe we're getting closer; a recent Michael Tsai post (No App, No entry) reminded me of my Mastodon thread from a few weeks ago:

What is the crazy that drives Trumpism and the many global equivalents?
It is that the minimal IQ to function well in the modern world is now about 120 and that eliminates most people.

This is both the most important fact of our time and the least palatable. It is the thing that cannot be said and it will be ruin of us if we don't say it ...

I've been saying this for years. Today I was reminded of it while doing some travel booking.
During the bookings I encountered:
1. A web site that didn't work with my older version of Safari (I knew what was wrong and switched to Chrome. 
2. A Delta web site bug (I recognized it as a bug and knew what to do). 
3. Place that was out of rental cards but I new Expedia would have some contracts that would let me find one. 
4. Travel web sites that all needed new credentials...
... These are all routine parts of modern life including maintaining flaky computer systems (let me tell you ...) and phones ...

It was not like this even 35 y ago. Travel agents handled travel complexity. There were no smartphones. Computers were very limited. There was no internet for most. By necessity everyday life was much simpler. Most people could cope with it.

Now most cannot cope.

This is the most important feature of our time. And nobody can talk about it. 

I remember some good discussions on this thread but I can't find any of them now. Perhaps by design Mastodon has a limited memory. (My home instance has no search, so I had to download my archive and search it to find the date of the post. Then I could slowly navigate to it.)

I expanded on the theme a bit later:

Hotel laundry year 2000

1. Insert quarters to buy detergent, operate washer and dryer.

IQ requirement: 65 (my son could do this after a demonstration)

Hotel laundry year 2023

1. Scan QR code to download app whose profit comes from unspent funds.

2. Install app, create account with Apple ID

3. Figure out cryptic UX so can deposit funds (several odd unintuitive steps)

3. Deposit funds, paying just enough to cover this sesh. Pat the 25 cent low transaction penalty... 

4. Spot the scam behind app and avoid it (eg find at minimum)

5. Diagnose why after paying money and confirming machine it’s still not working

6. Authorize specific transaction

7. Start laundry.

(My son could not do this)

8. When complete delete app. 

IQ requirement: minimum 110, higher to spot the scam. 

This is why America is burning.

People are scared and angry and feeling left behind -- and they can't come out and say they are unable to manage their tech. Because that's the ultimate shame.

See also:

Monday, July 03, 2023

Long Distance Cycling Tips from Paul M

The following is copied with permission from a Facebook post by Paul McCormick (Group cycling over 60, July 3 2023). I didn't want to see this kind of shared experience stuck on Facebook. The text in square brackets is my commentary. I haven't done bike touring for perhaps 35y or so, but this all seems familiar to me.

Once a year or so I take myself away on a long (6-8 weeks) cycle tour, generally somewhere in Europe. In the last seven years I've cycled from Stamford to.... Turkey, Sardinia, Italy, Corsica and Majorca to name just a few places. On these tours I carry everything I need to be self-sufficient on the road, including a tent and sleeping bag, food and water and spare parts for my bicycle.

Here are my 'top ten' tips for long-distance cycle touring!

It is important to have a plan! It gives you focus and direction and ensures you don't overlook anything. Plans should be flexible and include contingency arrangements; something will inevitably arise that will require changes to your plan.

Have a route in mind. It can be as general or as detailed as you wish, but it is helpful to know where you are going, how you are going to get there and how long it is going to take.

Having made a plan and a route you now need to follow your route. There are lots of cycle navigation Apps out there. I use Komoot on my phone and select the road cycle option (as the touring option often takes you on rough tracks and/or bridleways). I then export the route to my Garmin and have both devices mounted on my handlebars. Garmin is great for data and is generally sufficient for navigation, but I find it is easier to take a look at Komoot when I need to zoom in and out on the map.


You need a tourer! Generally, tourers are steel-framed and have mounting points for front and rear luggage carriers. Steel is both strong and flexible and so will absorb the shocks on the road far better than anything else; important when you are on the road for 6-8 hours!

[These days in the US these are better known as gravel bikes. They are mostly carbon however, which many long distance cyclists distrust and have limited pannier capacity. Or they are alloy, which is uncomfortable on long rides. I'm fond of the Salsa Vaya (cable disk brakes).]

My preference is for four panniers: two at the rear and two at the front, for balance. I also have a large saddle bag that sits on my rear carrier for my tent. My two front panniers contain everything I might need for the day, and the two rear panniers for stuff I'll need at the end of the day. One of my front panniers contains my wallet, passport, charging cables, electronic devices etc. That pannier is always with me wherever I go - shop, Bar, toilet!

You are prospectively riding 80km-100km a day. That's a long way, and a long day in the saddle! I like to be on the road by 8.00am and to split my day into four 'two hour' riding chunks, separated by 30 minute coffee/food stops. In each riding chunk I'll cycle circa 20km - 30km depending on the terrain and weather conditions. 

Don't chase the miles; let the miles come to you! Heart rate zone 2 for touring all the time.

Just eat and drink little and often. It doesn't really matter what you eat. Eat absolutely everything you are offered and don't worry about over-eating; I always come back from a tour far lighter than when I left. Expensive energy bars aren't necessary; just get the calories down you. And don't forget to drink regularly. [I can't afford to lose weight so I need to eat a LOT when I'm doing something like this]
Oh, and if you have too much for breakfast, wrap it up for lunch!

You will almost certainly encounter hills, and some of them will be long and with a lot of ascent. Make sure you have appropriate gearing and try as far as possible to pedal at a high cadence in heart rate zone 2. When that is no longer possible stop for a short rest as often as you need to. Focus on good pedalling technique and controlled, steady breathing. Remember, don't chase the miles, let the miles comes to you!

Mechanical problems 
Something will inevitably go wrong. Don't panic, everything and anything can be fixed! Take a deep breath, sit down and think clearly. Google the problem. Find a solution. Ask a stranger for help. Call a friend. Be inventive. Hitch a ride. You have a Credit Card!

Oh, and if you can't change an inner tube, don't even think about touring!

Long tours can, at times, be lonely! Social Media allows you to keep in touch with family and friends, and writing a blog on your journey gives you something to focus on when you're not cycling. But you'll need to make an effort to talk to people and initiate a conversation with a stranger, otherwise your only human contact will be when you buy a cake and a coffee in a café!

I belong to a Cycling Touring network called Warmshowers and, as far as possible, I stay overnight with members of that network. So, in addition to being offered a bed, shower, evening meal and breakfast with a host I have someone to talk to in the evening.

[Hostels used to be a good way to meet fellow travelers but during my most recent stays everyone was buried in their phones]