Aggregator

This is the shameless moment 14 passengers were caught on camera pushing through barriers at Wembley Park Underground station on Friday, September 19.

Chris's company has an unusual deployment. They had a MySQL database hosted on Cloud Provider A. They hired a web development company, which wanted to host their website on Cloud Provider B. Someone said, "Yeah, this makes sense," and wrote the web dev company a sizable check. They app was built, tested, and released, and everyone was happy.

Everyone was happy until the first bills came in. They expected the data load for the entire month to be in the gigabytes range, based on their userbase and expected workloads. But for some reason, the data transfer was many terabytes, blowing up their operational budget for the year in a single month.

Chris fired up a traffic monitor and saw that, yes, huge piles of data were getting shipped around with every request. Well, not every request. Every insert operation ended up retrieving a huge pile of data. A little more research was able to find the culprit:

SELECT last_insert_id() FROM some_table_name

The last_insert_id function is a useful one- it returns the last autogenerated ID in your transaction. So you can INSERT, and then check what ID was assigned to the inserted record. Great. But the way it's meant to be used is like so: SELECT last_insert_id(). Note the lack of a FROM clause.

By adding the FROM, what the developers were actually saying were "grab all rows from this table, and select the last_insert_id once for each one of them". The value of last_insert_id() just got repeated once for each row, and there were a lot of rows. Many millions. So every time a user inserted a row into most tables, the database sent back a single number, repeated millions and millions of times. Each INSERT operation caused a 30MB reply. And when you have high enough traffic, that adds up quickly.

On a technical level, it was an easy fix. On a practical one, it took six weeks to coordinate with the web dev company and their hosting setup to make the change, test the change, and deploy the change. Two of those weeks were simply spent convincing the company that yes, this was in fact happening, and yes, it was in fact their fault.

[Advertisement] Keep the plebs out of prod. Restrict NuGet feed privileges with ProGet. Learn more.

Married At First Sight UK fans beg new bride Grace to give 'lovely' groom Ashley a chance during the second episode of the E4 show. 

As Russian and American forces closed in on Germany, the prisoners were shuttled between different camps, living in terror of facing a firing squad.

It turns out that Binky Felstead has her mum to thank for her entire career as an influencer.

The disturbing rise of colorectal cancer-also known as colon or bowel cancer-in under 50s has baffled doctors around the globe.

Names, emails unplugged in DCS support snafu – but 'billing is safe'

An electric vehicle charging point provider is telling users that their data may be compromised, following a recent security "incident" at a service provider.…

They each have a number of great reasons to settle down there or pay them a visit

China-funded research suggests video app's new American operators might byte off 40 percent more traffic than they can chew

Before Larry Ellison, Michael Dell and Rupert Murdoch put pen to paper to take over TikTok’s US operations from ByteDance, they might want to consider that one of the Chinese company’s network boffins thinks the app and others like it create “massive data wastage”.…

Cracks down on malicious pessimism and expressions of ennui

China’s Cyberspace Administration yesterday announced a two-month campaign to quash netizens who “maliciously incite negative emotions”.…

She first made her mark belting out songs on Broadway in the mid 60s before going on to land her iconic role on the silver screen as one of Hollywood's most unforgettable mothers. 

There have been a number of crashes on the busy road

Last week, Central Connect, which provides services across Essex and at schools, came under fire from upset parents regarding its 331 and 333 bus services.

Two officers entered the address in Tiptree and spoke to two male suspects who refused to provide their names or answer questions.

Little House on the Prairie icon Melissa Gilbert has responded to Jason Bateman's claims he was 'hazed' by his fellow child stars on the hit show.

An anonymous reader quotes a report from Reuters: A new dark web portal to recruit spies for the UK was launched last Friday (19th September), as the UK steps up its commitment to national security. Harnessing the anonymity of the dark web for the first time, MI6's new secure messaging platform -- Silent Courier -- enables anyone, anywhere in the world with access to sensitive information relating to terrorism or hostile intelligence activity to securely contact the UK and offer their services. Instructions on how to access the portal will be publicly available on MI6's verified YouTube channel as the UK reaches out to potential new agents in Russia and around the world. MI6 advises individuals accessing its portal to use trustworthy VPNs and devices not linked to themselves, to mitigate risks which exist in some countries. The announcement was made by the outgoing Chief of MI6, Sir Richard Moore, in Istanbul where he stated that the platform will make it easier for MI6 to recruit agents online. As MI6 establishes its official presence on the dark web to reach new recruits and tackle hostile actors seeking to undermine UK security, Sir Richard said that the UK's intelligence services are "critical to calibrating risk and informing decisions" in navigating threats from hostile actors -- making platforms like these even more important in keeping our country safe. Sir Richard said: "Today we're asking those with sensitive information on global instability, international terrorism or hostile state intelligence activity to contact MI6 securely online. Our virtual door is open to you." Foreign Secretary Yvette Cooper said: "National security is the first duty of any government and the bedrock of the Prime Minister's Plan for Change. As the world changes, and the threats we're facing multiply, we must ensure the UK is always one step ahead of our adversaries. Our world class intelligence agencies are at the coalface of this challenge, working behind the scenes to keep British people safe. Now we're bolstering their efforts with cutting-edge tech so MI6 can recruit new spies for the UK - in Russia and around the world."

Read more of this story at Slashdot.

Sir Henry Ropner, 43, who reportedly dated Kate Middleton when she and William briefly split, has agreed a deal to lease 113-acres of land to build a solar farm in North Yorkshire.

Husam Zomlot, the Palestinian head of mission in the UK who is set to become the ambassador, hailed the bolstered status at a ceremony on Monday morning.

William and Annabel Woodhams' newborn Basil Groove Blofeld went viral after film fans realised he was named after the recurring antagonist in Ian Fleming's creation.

The boyfriend of a missing British yachtswoman Sam Hesop - who disappeared in 2021 - has broken his silence.