Amazon Vancouver | Hang Hu | Vancouver, Amazon, Alexa team

Here is the post from Hang Hu.  

It has been almost three years since I joined Amazon. I've been enjoying the time delivering customer focused features and collaborating with my colleagues.

Today, the entire Alexa-hosted skill team is impacted by the layoff and I am given 60 days to find another internal or external position. It's pretty sad to see Alexa-hosted skill is no longer getting invested. I won't forget the time when being blocked by challenges and the happiness when the solution was found, the excitement when we launched new features, and the time working with my colleagues. I learned a lot from my brilliant and passionate colleagues, I feel grateful to work with them.

I also want to thank my manager Sai Chiligireddy, Ilia Pak, Umur Kontacı, Veer Yuganter Singh, Harry Harim Park, Beichen Zhang and other colleagues, friends for your efforts to try to find a position for me. The layoff is cold, but the recognition and the help from you make me feel so warm and supported.

Moving forward, I am looking for both Amazon internal and external SDE opportunities. I am #opentowork for positions in Canada or in the US that accepts remote from Canada. I don't need visa sponsor to work in Canada. I am proficient in Java, and familiar with AWS architectural design and development, Spring framework, Javascript, React. Here follows some of the features I launched.

Code import: https://lnkd.in/gKwPC2DN

Song request: https://lnkd.in/gkPxz3D7

#amazon #layoff #help #canada #software #engineers

WordPress database | 12 tables

12 tables inside the database

1. wp_termmeta
2. wp_users
3. wp_usermeta
4. wp_terms
5. wp_term_taxonomy
6. wp_term_relationships
7. wp_posts
8. wp_users
9. wp_comments
10. wp_commentmeta
11. wp_links
12. wp_postmeta

From version 4.4.2 onwards, WordPress has 12 tables inside the database. These tables are used to perform various default functionalities of WordPress. However, this number can vary depending upon the number of themes and plugins installed in your WordPress.

Each plugin and theme create its own tables and it won’t be wrong to say that more the plugins you install the more tables you will have in your database. Let’s see the WordPress Database Diagram, so we can have a basic understanding of how a database works in WordPress.

Let’s take a look at what each database table stores:

1. wp_users: Whenever you create a user is stored in this table along with its details and status.
2. wp_usermeta: Stores meta information of users.
3. wp_posts: Custom post types, pages data, and post data are stored in this table.
4. wp_postmeta: Post meta information store here.
5. wp_comments: This table stores comments placed on your site.
6. wp_commentmeta: Meta information for comments stored here.
7. wp_terms: Tags and categories for both posts and links are stored here.
8. wp_termmeta: Meta information for terms stored here.
9. wp_term_relationships: This stores the relationship between the members of wp_terms.
10. wp_term_texonomy: Description of a category, link, or tag used in a wp_term table stored here.
11. wp_links: This stores blogroll links that are depreciated but can be activated using Link Manager.
12. wp_options: Options set in admin are stored here.

WP-Optimize | WordPress plugin | How to optimize WordPress database

WP-Optimize is another WordPress plugin used for database optimization. It cleans up the WordPress database effectively and automatically. You can install and activate this plugin from your WordPress dashboard.

It also has a list of options for removing unwanted revisions, comments, posts data, and transient options. Make your selection and click on the “Run all selected optimizations” button to initialize the process.

Summary

I discussed WordPress database optimization in detail and why it is important to run these cleanups every now and then. You have also learned two different methods of optimizing databases on WordPress. If you find this article useful or would like to add something, please share your feedback in the comments section below.

Frequently Asked Questions

Q: How Do I Optimize my WordPress Database?

You can optimize your WordPress database by accessing phpMyAdmin via your hosting provider. You will be required to log in to the cPanel, but if your hosting provider does not use a cPanel, look for the alternative MySQL management tool. You may then optimize your database from there. Also, you can use a WordPress database plugin to optimize your database easily.

Q: Is WordPress Good for Database?

Yes, WordPress is good for a database and uses MySQL as its database management system. MySQL is an open-source software used for creating a database and retrieving data when required.

Q: How Does WordPress Store Database Data?

WordPress stores database data in the form of tables. All the unique data is presented in rows in each table. WordPress automatically creates the tables by default as soon as you set up your website.

Q: How Do I Use WordPress to Create a Database?

You can use WordPress to create a database using Plesk, cPanel, phpMyAdmin, or MySQL client.

If you are a Cloudways user, you can create a database via phpMyAdmin by following the steps below:

• Access phpMyAdmin from Application Management.
• You will see the database management window.
• Click Create Table.
• Now set your preferences by either using the SQL commands or via the UI option.

Amazon | Alexa | Vancouver layoff

Here is the link.

Amazon is reportedly laying off thousands of people starting this week, and its Canadian teams are not exempt.

The New York Times was first to report earlier this week on the retail giant’s downsizing, noting Amazon plans to cut 10,000 jobs In recent days, LinkedIn posts from stated Amazon employees have indicated that the layoffs have begun.

According to some LinkedIn posts, Canadians have been part of the cuts. The posts indicate that those affected include developers for Alexa, Amazon’s voice-controlled assistant device.

The Verge reported today that senior vice president Dave Limp sent an email to employees on Wednesday confirming the layoffs. In

Per Amazon’s LinkedIn page, it has about 19,800 employees based in Canada. The exact number of Canadian employees impacted by the layoffs at Amazon is unclear.

Amazon did not immediately respond to BetaKit for comment.

The New York Times noted that the 10,000 employee number will likely remain fluid, according to sources familiar with the matter. The cuts would amount to three percent of Amazon’s corporate staff and less than one percent of its global workforce.

Burnaby-based software development engineer Hang Hu wrote on LinkedIn that the entire Alexa-hosted skill team was impacted by the cuts at Amazon.

As reported by The New York Times, the downsizing will focus on Amazon’s devices organization. In addition to Alexa, impacted teams are reported to comprise Amazon’s retail and human resources divisions, among others.

The layoffs at Amazon follows its previous commitment to Canada last year of hiring 1,800 tech and corporate roles by the end of 2021. At that time, it confirmed it had about 25,000 Canadian employees across its fulfillment centres, corporate offices, development centres, and other facilities. Amazon has locations in British Columbia, Ontario, Alberta, Manitoba, and Québec.

RELATED: Amazon to add 1,800 Canadian tech, corporate jobs this year as part of broader hiring plans

Amazon’s stock price has declined by almost 43 percent year to date, trading at $97.77 USD on Nasdaq at the time of publication. This time last year it was trading at $177.04 USD. The change represents a 45 percent dip.

The US retail giant is the latest major tech company to implement mass staff cuts as they go into survival mode amid the macroeconomic downturn.

Last week, Meta’s broad reductions across its organization also affected Canadian employees as part of the 11,000 people laid off last week. And the week prior, Twitter’s job cuts hit its Canadian offices, which saw top levels of its team let go. This includes managing director Paul Burns, director of public policy for Canada Michele Austine, and Twitter Canada communications lead Cam Gordon.

Google | Layoff analysis

Even today, Google has no problem making plenty of money. But the fact that it is getting a little harder is still painful.

The internet giant’s parent company, Alphabet Inc., GOOG 0.68%increase; green up pointing triangle

 generated operating income of $78.6 billion for the trailing 12-month period ended September—the third-highest among S&P 500 companies over that span, according to S&P Global Market Intelligence. But margins have taken a hit as a big jump in costs has run headlong into a broad-based slowdown in online advertising. The operating margin for the third quarter came in at 24.8%—a drop of nearly 8 percentage points from a year earlier, as the company added 12,765 workers to its rolls in the most recent period.  

The big jump in head count and costs stunned even analysts who had been bracing for the ad slowdown; Alphabet shed 20% of its market value in the week following its release of third-quarter results on Oct. 25. The number of new hires was a record for a company that hardly pays peanuts. Alphabet’s median employee pay for 2021 totaled $295,884—the highest in the S&P 500, according to a tabulation by The Wall Street Journal. It is also more than twice the median income for the metropolitan statistical area that is home to the company’s Silicon Valley headquarters. 

Chief Executive Sundar Pichai said on last month’s earnings call that head-count growth “will be significantly lower” in the current quarter. That still hasn’t satisfied those who think the company is spending too lavishly for an advertising business potentially facing even further slowdowns if a global recession hits. Activist investor TCI Fund Management released a letter Tuesday calling on Google to join fellow tech companies Amazon and Facebook parent Meta Platforms in cutting both its head count and employee-compensation levels. A reduction on the scale of Meta’s 13% cut announced last week would cost about 24,000 Googlers their jobs. 

How to Install and Configure Redis on WordPress (Boost Your Site’s Performance)

How to Set Up a Redis Server And Use With PHP

Install Redis on Xampp - Windows - Gist de GitHub

What is the best alternative for MySQL Query Cache?

Here is the article. 

The alternative to query cache is to write code to cache data yourself, in the application. You decide which query results need to be cached, for how long, and in what format.

• Many queries are against constantly-changing data, and your application requires viewing the current data.

• Other queries are tolerant of viewing data that is not strictly current, so it's fine to use the cached copy for a few minutes, even though the underlying data has been updated.

• Caching the data in the form of a result set isn't the only option. I have an application where I format results from several queries into one string which is a fragment of HTML, that store that string in the cache. It avoids having to re-format that part of the HTML every time someone views the page.

You can also use a shared cache like Redis or Memcached so if your app is deployed as multiple appserver instances, they can all share the same cache.

This is more work for you as a developer. There's no automatic solution for a server like MySQL to know which queries deserve to be cached.

Optimizing is often more work than simple, non-optimal solutions.

8.10.3 The MySQL Query Cache

Here is the article. 

 The query cache stores the text of a SELECT statement together with the corresponding result that was sent to the client. If an identical statement is received later, the server retrieves the results from the query cache rather than parsing and executing the statement again. The query cache is shared among sessions, so a result set generated by one client can be sent in response to the same query issued by another client.

The query cache can be useful in an environment where you have tables that do not change very often and for which the server receives many identical queries. This is a typical situation for many Web servers that generate many dynamic pages based on database content.

The query cache does not return stale data. When tables are modified, any relevant entries in the query cache are flushed.

MySQL - max_queries_per_hour

 

Fatal error: Uncaught mysqli_sql_exception: User '' has exceeded the 'max_queries_per_hour' resource (current value: 600) in C:\xampp\htdocs\testsite\exercises\FixtureToChip\private\classes\Fixture.class.php:13 Stack trace: #0 C:\xampp\htdocs\testsite\exercises\FixtureToChip\private\classes\Fixture.class.php(13): mysqli->query('SELECT id FROM ...') #1 C:\xampp\htdocs\testsite\exercises\FixtureToChip\private\classes\Fixture.class.php(57): Fixture::find_by_sql('SELECT id FROM ...') #2 C:\xampp\htdocs\testsite\exercises\FixtureToChip\public\indexLearning.php(42): Fixture::find_by_name('L227W-S') #3 {main} thrown in C:\xampp\htdocs\testsite\exercises\FixtureToChip\private\classes\Fixture.class.php on line 13

https://dev.mysql.com/doc/refman/8.0/en/user-resources.html

mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100;

Seekingalpha.com - Annual subscription - Renew this Dec. 15, 2022

 My Deals and Promotions

40% off a subscription to The Dividend Kings.
Expires at 8:59 PM on December 15, 2022Claim Discount

Seeking Alpha Premium

Plan Details

Annual subscription

Annual pricing may soon increase. Lock in the introductory rate before it expires
with Multi-Year Options.Multi-Year Options

PRO includes all Premium features as well as Top Ideas from top-performing authors, list of short ideas, powerful screeners, exclusive content and more.Upgrade to PRO

Start Date

December 14, 2021

Payments

Next payment

Email Invoice

$239.00December 14, 2022

Recent payments

$179.99December 14, 2021

Cancel Subscription

If you cancel, your credit card will not be charged in the future.Cancel Subscription

Contact Us

If you have a general question about payments, billing, etc. contact customer service atsubscriptions@seekingalpha.comand we will reply in a timely manner. For other questions, you are welcome to send the author a direct message

富士康

 和大部分人一样，齐瑞涛看中的也是富士康的返费。据了解，富士康的员工大体可以分为正式工、返费工以及小时工三种，其中返费工的主要运作模式是在职 90 天，打卡 55 天后，在每月收入的基础上，能够拿到一笔万元左右的一次性收入，他们的合同通常只有三个月左右。

每年 8-10 月，返费通常都会超过 1 万元。2020 年 6 月，齐瑞涛第一次踏入这座工厂时，富士康给出的返费大约是 7500 元。

" 有固定收入的人可能理解不了，有些学历不高又没工作的人，可能真的会面临没饭吃的情况，去富士康起码初期的吃住都不是问题。" 郑卓胜接触过这样的人，对方曾经开了一家餐馆，疫情前每年的净收入能达到 20 万元，但受疫情影响，生意一落千丈。

餐饮不同于其他行业，除了店铺的房租以外，食材的存放意味着百分之百的损失。找到郑卓胜的时候，对方几乎到了身无分无的程度，那时候郑卓胜借了他 50 元的体检费，双方约定好发了工资再还。在对方看来，" 先用后付 " 的吃饭及住宿真的帮了大忙。

" 当你身无分文的时候，可以选择去富士康，但其他地方可能很难收留你。" 郑卓胜说。

当然，也有人选择富士康是为了过渡。28 岁的齐瑞涛曾先后两次进出富士康，皆是因为工作的变动，没能及时找到合适的下家，但却需要持续的收入。

每年 8-10 月，返费通常都会超过 1 万元。2020 年 6 月，齐瑞涛第一次踏入这座工厂时，富士康给出的返费大约是 7500 元。

开车4个坏习惯，千万不要带到高速上，易发生车毁人亡的交通事故

Here is the link. 

新手坐在车内判断车距的6大技巧，掌握后有效避免剐蹭！太实用了

Here is the link. 

刹车抱死是什么意思

Here is the link.

刹车抱死

 刹车抱死就是轮子受到强大的制动力后停止转动， 由于车速产生的惯性， 即使轮子不转了， 车还是在向前滑动。

刹车抱死产生现象

编辑 播报

刹车抱死时，如果当时前轮和后轮的轨迹在同一直线上， 也就是说车是直行的， 那么车是向前运动。如果当时前后轮的轨迹不再一条直线上， 那么车就会甩尾。更要命的是，一旦车轮抱死后产生滑行现象，打方向盘将不能再修正方向， 因为车轮不转的情况下， 车就是靠轮胎着地的那块面积滑行， 车轮不能依靠转动来产生转向效应。

.行车中刹车抱死会产生的严重后果

编辑 播报

刹车抱死后，由于轮胎与地面形成滑动摩擦，车辆不受控，容易导致汽车甩尾，产生二次事故或是轮胎在强烈的摩擦下爆胎，车辆在高速情况下会翻车。

解决办法

编辑 播报

汽车工程师为了解决这个问题，使用了ABS防抱死的技术，这项技术主要特点是在紧急情况下急踩刹车后，车轮并不会停止转动，这样会保证车辆与地面不是滑动摩擦，能够保证车辆不会失去控制，同时轮胎也不会因为滑动摩擦而爆胎。

ABS防抱死作用原理

编辑 播报

ECU的功能就是控制ABS作动器增加、维持或减少每个车轮的刹车液压力。每个车轮均设有转速（车速）感知器，将车轮的速率信号传送至ECU，一旦刹车力过大有可能引发车轮死锁状况之时，ECU便会发送信号至ABS作动器，降低刹车油压力量，当即将死锁的轮胎被刹车放开之后，自然又恢复抓地控制能力。

在刹车持续加压的过程中，如果ECU又察觉到车速继续增加，马上会立即施加刹车油压力量，车轮又再次减速然后放开，如此持续死锁又放开的动作方式，最快甚至在一秒钟之内可以连续加压和释放数十次之多，使得车辆可以迅速减速，又不至于将轮胎死锁得以闪避障碍。 [1]