投稿時間:2023-08-03 02:27:39 RSSフィード2023-08-03 02:00 分まとめ(30件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	｢AirTag 2｣は2024年末に登場か ｰ 2024年第4四半期に量産開始の可能性	https://taisy0.com/2023/08/03/174901.html	airtag	2023-08-02 16:01:03
IT	InfoQ	Presentation: Leveling Up Your Architecture Game	https://www.infoq.com/presentations/progress-communication-collaboration/?utm_campaign=infoq_content&utm_source=infoq&utm_medium=feed&utm_term=global	Presentation Leveling Up Your Architecture GameThomas Betts discusses thriving in today s fast paced tech landscape using good communication and collaboration with teams By Thomas Betts	2023-08-02 16:39:00
AWS	AWS Big Data Blog	How FIS ingests and searches vector data for quick ticket resolution with Amazon OpenSearch Service	https://aws.amazon.com/blogs/big-data/how-fis-ingests-and-searches-vector-data-for-quick-ticket-resolution-with-amazon-opensearch-service/	How FIS ingests and searches vector data for quick ticket resolution with Amazon OpenSearch ServiceThis post was co written by Sheel Saket Senior Data Science Manager at FIS and Rupesh Tiwari Senior Architect at Amazon Web Services Do you ever find yourself grappling with multiple defect logging mechanisms scattered project management tools and fragmented software development platforms Have you experienced the frustration of lacking a unified view hindering your ability …	2023-08-02 16:53:22
AWS	AWS Database Blog	Best strategies for achieving high performance and high availability on Amazon RDS for MySQL with Multi-AZ DB Clusters	https://aws.amazon.com/blogs/database/best-strategies-for-achieving-high-performance-and-high-availability-on-amazon-rds-for-mysql-with-multi-az-db-clusters/	Best strategies for achieving high performance and high availability on Amazon RDS for MySQL with Multi AZ DB ClustersIn Amazon Relational Database Service Amazon RDS Multi AZ deployments can have one or two standby DB instances A Multi AZ DB instance deployment has a single standby DB instance that provides failover support but doesn t serve read traffic When the deployment has two readable standby DB instances it s called a Multi AZ DB cluster deployment A Multi AZ …	2023-08-02 16:50:41
AWS	AWS The Internet of Things Blog	How to improve device discoverability by unlocking 50 AWS IoT thing type attributes	https://aws.amazon.com/blogs/iot/how-to-improve-device-discoverability-by-unlocking-50-aws-iot-thing-type-attributes/	How to improve device discoverability by unlocking AWS IoT thing type attributesIntroduction If you are using or planning to use AWS IoT Core to manage your fleet of Internet of Things IoT devices and wondering how to search for and discover a particular device or a set of devices based on their identities and capabilities then using attributes for AWS IoT thing types is one of …	2023-08-02 16:25:15
AWS	AWS Machine Learning Blog	SageMaker Distribution is now available on Amazon SageMaker Studio	https://aws.amazon.com/blogs/machine-learning/sagemaker-distribution-is-now-available-on-amazon-sagemaker-studio/	SageMaker Distribution is now available on Amazon SageMaker StudioSageMaker Distribution is a pre built Docker image containing many popular packages for machine learning ML data science and data visualization This includes deep learning frameworks like PyTorch TensorFlow and Keras popular Python packages like NumPy scikit learn and pandas and IDEs like JupyterLab In addition to this SageMaker Distribution supports conda micromamba and pip as Python …	2023-08-02 16:43:38
AWS	AWS Machine Learning Blog	Automate caption creation and search for images at enterprise scale using generative AI and Amazon Kendra	https://aws.amazon.com/blogs/machine-learning/automate-caption-creation-and-search-for-images-at-enterprise-scale-using-generative-ai-and-amazon-kendra/	Automate caption creation and search for images at enterprise scale using generative AI and Amazon KendraAmazon Kendra is an intelligent search service powered by machine learning ML Amazon Kendra reimagines search for your websites and applications so your employees and customers can easily find the content they are looking for even when it s scattered across multiple locations and content repositories within your organization Amazon Kendra supports a variety of document …	2023-08-02 16:41:11
AWS	AWS Media Blog	Resilient video encoding across multiple AWS regions	https://aws.amazon.com/blogs/media/resilient-video-encoding-across-multiple-aws-regions/	Resilient video encoding across multiple AWS regionsThe need for resilient technology workloads transcends all industries It is particularly important for the media and entertainment M amp E industry because disruption of media workloads may lead to customer churn or brand tarnish A misunderstanding of resilience as a concept can lead to workloads that may not have resilient architecture or workloads that are over engineered …	2023-08-02 16:43:28
海外TECH	MakeUseOf	How to Control System Sounds and Notifications on Xbox Series X|S	https://www.makeuseof.com/how-to-control-system-sounds-and-notifications-on-xbox-series-xs/	important	2023-08-02 16:15:24
海外TECH	MakeUseOf	How to Fix the Windows 0x8007007E Error Code	https://www.makeuseof.com/windows-0x8007007e-error-code-fix/	windows	2023-08-02 16:15:24
Apple	AppleInsider - Frontpage News	China mulls mandatory 'minor mode' on iPhone to curb youth Internet abuse	https://appleinsider.com/articles/23/08/02/china-mulls-mandatory-minor-mode-on-iphone-to-curb-youth-internet-abuse?utm_medium=rss	China mulls mandatory x minor mode x on iPhone to curb youth Internet abuseApple other smartphone makers and app developers may have to introduce limits to how Chinese children can use devices like iPhone and the apps to run them if a new proposed law is put into effect Restricting content for kidsA draft regulation put forth by the Cyberspace Administration of China CAC would make a minor mode mandatory for smartphones and app stores imposing sharp limits on how long and when children can use devices depending on their age The law would further restrict what apps kids could download making parental permission mandatory in numerous instances Read more	2023-08-02 16:24:01
Apple	AppleInsider - Frontpage News	Google Chrome gets iOS & macOS update with new features	https://appleinsider.com/articles/23/08/02/google-chrome-gets-ios-macos-update-with-new-features?utm_medium=rss	Google Chrome gets iOS amp macOS update with new featuresGoogle Chrome is one of the most popular web browsers available and is the go to alternative to Apple s Safari ーand both iOS and Mac versions got an update today Google Chrome updateGoogle has announced a few updates for its cross platform browser across iOS and desktop The iOS update focuses on giving users more opportunities to initiate searches while the desktop update is more modest Read more	2023-08-02 16:00:26
海外TECH	Engadget	Nintendo brings 'Mario Kart 8' and 'Splatoon' for Wii U back online August 3rd	https://www.engadget.com/nintendo-brings-mario-kart-8-and-splatoon-for-wii-u-back-online-august-3rd-165434085.html?src=rss	Nintendo brings x Mario Kart x and x Splatoon x for Wii U back online August rdIt took several months but you can finally play the Wii U versions of Mario Kart and Splatoon online Nintendo has confirmed that both titles will once again be available for multiplayer as of August rd The company has fixed the security vulnerability that prompted the shutdown of online service in March Nintendo still hasn t detailed the flaw However enthusiast and tinkerer OatmealDome claims the last gen console is vulnerable to an quot ENLBufferPwn quot attack that lets intruders take over the console when it goes online The company reportedly fixed the bug last year for affected Switch titles well as Mario Kart but didn t make a similar effort for the Wii U versions until now You ll need to update both games to resume online play The months long wait isn t completely surprising when the Switch has been Nintendo s current system for several years and is clearly more popular Still this is good news if you re not in a rush to replace your Wii U ーyou won t have to stop using the older system if you still enjoy the affected titles With that said there s little doubt that Nintendo wants to wean gamers off the earlier console The company shut down the Wii U eShop this spring limiting users to re downloading existing purchases Unless you grab physical copies your game library is frozen in time unless you move to the Switch This article originally appeared on Engadget at	2023-08-02 16:54:34
海外TECH	Engadget	Google could be taking the Chrome out of ChromeOS	https://www.engadget.com/google-could-be-taking-the-chrome-out-of-chromeos-164057852.html?src=rss	Google could be taking the Chrome out of ChromeOSGoogle has reportedly been working for years to separate the Chrome browser from Chrome OS that s how entangled they are and it looks like this project is ready to bear fruit The solution seems to be a new ish standalone Linux based browser named Lacros that would replace the current Chrome OS based browser What s more Lacros is nearly ready for primetime according to About Chromebooks Why does this matter As it stands you need a full Chrome OS update to make any changes to the browser This isn t the most efficient means to issue browser patches thus the years long search for a decoupling solution Additionally older Chromebooks lose access to system updates so this move could potentially make these machines more secure You can already use Lacros but it launches alongside the built in Chrome browser and requires a fair bit of know how to get going About Chromebooks found some small code changes that suggest that Lacros is set to release as the default browser for Chromebooks potentially eliminating the current browser altogether This means that new Chromebooks would feature Lacros as the browser directly out of the box allowing browser specific patches and updates without involving the operating system Also these changes look to be coming soon like real soon All points indicate the very next system update Chrome OS will bring Lacros into the mainstream Chrome OS updates hit around once a month so probably at the end of August or the beginning of September It remains unclear if the system update will make Lacros the default browser or if it ll just remove restrictions to using Lacros instead of the default browser In the meantime recent Chrome OS updates have included Android app streaming and a robust video editor This article originally appeared on Engadget at	2023-08-02 16:40:57
Cisco	Cisco Blog	New Entry-Level Cisco Certifications: CCST Gains Ground	https://feedpress.me/link/23532/16279862/ccst-entry-level-certs-gaining-ground	New Entry Level Cisco Certifications CCST Gains GroundCisco is on a mission to empower all people with career possibilities Now with the recent release of two new entry level Cisco certifications we re building a career pathway into tech for learners from diverse backgrounds cultures and experiences	2023-08-02 16:00:44
Cisco	Cisco Blog	Mining innovation: Underground mining visibility, locating assets and protecting people	https://feedpress.me/link/23532/16279863/mining-innovation-underground-mining-visibility-locating-assets-and-protecting-people	Mining innovation Underground mining visibility locating assets and protecting peopleGeoMoby and Cisco deliver reliable network connectivity and communication to achieve high levels of visibility for mining operations	2023-08-02 16:00:43
海外TECH	WIRED	Extreme Heat Threatens the Health of Unborn Babies	https://www.wired.com/story/extreme-heat-threatens-the-health-of-unborn-babies/	Extreme Heat Threatens the Health of Unborn BabiesExposure to excessive heat during pregnancy has been linked to everything from preterm labor to low birth weight and those risks are rising as the world warms	2023-08-02 16:10:22
ニュース	BBC News - Home	Jacob Crouch: Stepfather guilty of 'vicious' baby murder	https://www.bbc.co.uk/news/uk-england-derbyshire-66307905?at_medium=RSS&at_campaign=KARANGA	fractures	2023-08-02 16:40:48
ニュース	BBC News - Home	Pittsburgh synagogue gunman gets death penalty	https://www.bbc.co.uk/news/world-us-canada-66388484?at_medium=RSS&at_campaign=KARANGA	antisemitic	2023-08-02 16:43:23
ニュース	BBC News - Home	Lizzo dancers Arianna Davis and Crystal Williams: 'No one speaks out, they are scared'	https://www.bbc.co.uk/news/entertainment-arts-66384971?at_medium=RSS&at_campaign=KARANGA	harassment	2023-08-02 16:04:25
ニュース	BBC News - Home	Brazil police raids leave at least 43 people dead	https://www.bbc.co.uk/news/world-latin-america-66387599?at_medium=RSS&at_campaign=KARANGA	gangs	2023-08-02 16:49:19
ニュース	BBC News - Home	Etsy U-turn in row over withholding sellers' money	https://www.bbc.co.uk/news/business-66387147?at_medium=RSS&at_campaign=KARANGA	marketplace	2023-08-02 16:39:03
ニュース	BBC News - Home	Toymaker Mattel promotes 'chief Uno player' job	https://www.bbc.co.uk/news/business-66387417?at_medium=RSS&at_campaign=KARANGA	applicant	2023-08-02 16:29:48
ニュース	BBC News - Home	Canada's PM Justin Trudeau and wife Sophie to separate	https://www.bbc.co.uk/news/world-us-canada-66389069?at_medium=RSS&at_campaign=KARANGA	conversations	2023-08-02 16:53:03
ニュース	BBC News - Home	Anti-vax protester guilty of harassing Matt Hancock	https://www.bbc.co.uk/news/uk-politics-66384100?at_medium=RSS&at_campaign=KARANGA	health	2023-08-02 16:12:45
ニュース	BBC News - Home	Nadine Dorries not doing MP's job properly, says Rishi Sunak	https://www.bbc.co.uk/news/uk-politics-66382232?at_medium=RSS&at_campaign=KARANGA	rishi	2023-08-02 16:14:54
ニュース	BBC News - Home	Josko Gvardiol: Manchester City agree £77m fee with RB Leipzig for defender	https://www.bbc.co.uk/sport/football/66386222?at_medium=RSS&at_campaign=KARANGA	gvardiol	2023-08-02 16:36:49
ニュース	BBC News - Home	The Hundred 2023: Fan drops a catch after Welsh Fire Luke Wells' six	https://www.bbc.co.uk/sport/av/cricket/66389246?at_medium=RSS&at_campaign=KARANGA	The Hundred Fan drops a catch after Welsh Fire Luke Wells x sixWatch as a fan in the crowd drops a catch from Welsh Fire Luke Wells six during their Hundred match against Manchester Originals in Cardiff	2023-08-02 16:50:09
ニュース	BBC News - Home	Four takeaways from the indictment	https://www.bbc.co.uk/news/world-us-canada-64034782?at_medium=RSS&at_campaign=KARANGA	broad	2023-08-02 16:38:38
GCP	Cloud Blog	A definitive guide to the Database Observability with Cloud SQL: Part 1	https://cloud.google.com/blog/products/databases/guide-to-the-database-observability-with-cloud-sql/	A definitive guide to the Database Observability with Cloud SQL Part IntroductionDatabase performance is essential for any business because it affects the efficiency and effectiveness of day to day operations A slow database can cause delays in processing transactions which can have a negative impact on customer satisfaction and profitability  Cloud SQL for PostgreSQLoffers database observability through Cloud SQL Insights and SQLcommenter which help customers diagnose detect and prevent database performance issues using a developer first approach Cloud SQL for PostgreSQL supports additional database logs that can include metadata about database connections and disconnections as well as query execution All of these logs can be configured using database flags Cloud SQL also supports widely used PostgreSQL Extensions such as pg stat statements By enabling both Cloud SQL Insights and native options customers can get the best of both worlds This blog post explains how customers who have migrated to Cloud SQL for PostgreSQL can still use familiar PostgreSQL tools such as pgBadger and pg stat statements for database observability in addition to Cloud SQL Insights Unlike Cloud SQL Insights generating reports using pgBadger requires additional steps to activate all necessary logging If logging is not enabled a partial report will be generated Additionally pgBadger requires additional operational steps to set up a server or GCE instance to download and create a report This article describes how to configure logging and generate HTML reports using pgBadger It also emphasizes the value of using pg stat statement to capture nested calls within procedural calls Configuring database flagsCloud SQL for PostgreSQL provides database flags that control the information captured in database logs First we will configure flags to enable logging of slow queries every connection and disconnection We will enable the following database flags with the values set as an example not as the recommended values Activating the above mentioned parameters or setting aggressive values for logging can put a strain on the database We should assess the performance impact on the database before changing it in production Here we can refer to the complete list of flags that are available for configuration on Cloud SQL for PostgreSQL Sample command line for updating database flags code block StructValue u code u gcloud sql instances patch lt lt instanceName gt gt database flags log connections on log disconnections on log min duration statement log temp files log lock waits on u language u u caption lt wagtail wagtailcore rich text RichText object at xebce gt We are going to activate a new setting to record all nested calls as part of a top level statement issued by clients This will help us identify problematic nested calls i e statements invoked within procedural code in the pg stat statements view code block StructValue u code u pg stat statements track all u language u u caption lt wagtail wagtailcore rich text RichText object at xebcd gt We can verify our set parameter from the database by querying the pg settings view Setting up pgbench DatabaseWe will use pgbench a tool for benchmarking PostgreSQL databases to simulate a performance baseline run on our Cloud SQL database The loads generated during the mock benchmark run will be used to generate reports from database logs using pgBadger We will initialize the database using the pgbench command line available as part of PostgreSQL client libraries on a newly created database “pgbench code block StructValue u code u deepakmahto PGPASSWORD pgbench i s partitions h localhost p U postgres pgbench r ndropping old tables r nNOTICE table pgbench accounts does not exist skipping r nNOTICE table pgbench branches does not exist skipping r nNOTICE table pgbench history does not exist skipping r nNOTICE table pgbench tellers does not exist skipping r ncreating tables r ncreating partitions r ngenerating data client side r n of tuples done elapsed s remaining s r nvacuuming r ncreating primary keys r ndone in s drop tables s create tables s client side generate s vacuum s primary keys s u language u u caption lt wagtail wagtailcore rich text RichText object at xebcd gt Generate pgBadger reportspgBadger a tool that processes database log files to generate HTML reports includes information about connection session vacuum temporary files and top queries We have already configured the relevant database flags to log information about each database connection and queries taking more than milliseconds We will configure Cloud SQL for PostgreSQL logs to be stored in a Cloud Storage bucket and then download them to Cloud Shell to process them using pgBadger to generate HTML reports As the first step we will install and set up pgBadger on a cloud shell Setting up pgBadger on a Cloud Shell or Compute Instancecode block StructValue u code u git clone r n r ncd pgbadger r n r nperl Makefile PL r nmake amp amp sudo make install r ndeepakmahto pgbadger pgbadger pgbadger V r npgBadger version u language u u caption lt wagtail wagtailcore rich text RichText object at xebca gt Configure Cloud SQL logs routing sink to Cloud StorageCloud SQL uses Cloud logging to store all instance logs Cloud logging can be used to view and query database instance logs We will create log routing sinks to send all required Cloud SQL instance logs to a Google Cloud Storage GCS destination The logs router is a part of Cloud logging The sink destination is defined as a Google Cloud storage bucket We have set up the GCS bucket to be the destination for Cloud SQL logs and we have filtered the logs to only include those from Cloud SQL databases with the specified ID label We have provided the required sink information and set up a new Cloud Storage bucket to route all logs to as an hourly batch process We can also provide additional filters to include only specific Cloud SQL instances in the logs that are included in the sink Inclusion filter for our sample instance is code block StructValue u code u resource type cloudsql database r nresource labels database id deepakmahto pgbadgersample u language u u caption lt wagtail wagtailcore rich text RichText object at xebd gt Cloud SQL execution logs will be available in hourly batches for generating reports using pgBadger by analyzing logs We can always use Cloud SQL insights for real time insight to understand load and SQL details Run mock benchmark test using pgbenchWe have already initialized the pgbench sample database and will now simulate client connections in threads as a benchmark test to generate load on our Cloud SQL database code block StructValue u code u deepakmahto PGPASSWORD pgbench c j t h localhost p U postgres pgbench r n r npgbench r nstarting vacuum end r ntransaction type lt builtin TPC B sort of gt r nscaling factor r npartition method range r npartitions r nquery mode simple r nnumber of clients r nnumber of threads r nnumber of transactions per client r nnumber of transactions actually processed r nlatency average ms r ninitial connection time ms r ntps without initial connection time u language u u caption lt wagtail wagtailcore rich text RichText object at xebd gt Run pgBadger to generate html reports We will download Cloud SQL for PostgreSQL logs from Cloud Storage to our cloud shell environment and run pgBadger to generate an HTML report for the mock benchmark run We can also automate the process of downloading logs from Cloud Storage and executing pgBadger to generate reports on a variety of intervals from hourly to weekly The Compute Engine service account must be granted the necessary roles in order to download logs from Cloud Storage code block StructValue u code u deepakmahto pgbadger gsutil cp gs cloudsqlpostgresqllogs cloudsql googleapis com postgres log json u language u u caption lt wagtail wagtailcore rich text RichText object at xebcdb gt Once Cloud SQL logs are downloaded you can use the pgBadger tool to generate HTML reports from the JSON based logs code block StructValue u code u deepakmahto pgbadger pgbadger f jsonlog o outputReport html O S json S json r n r n gt r nParsed bytes of queries events r nLOG Ok generating html report u language u u caption lt wagtail wagtailcore rich text RichText object at xebcdd gt Initial look on the HTML report will look like the screenshot below The HTML report includes information on connections temp files usage SQL execution statistics and more For example we can check the slowest queries and the most resource intensive queries under the TOP sections pg stat statements ExtensionThepg stat statements extension provides a convenient way to view cumulative query execution statistics which are displayed as a database view It is preloaded in shared libraries and can be used in databases with the Create extension command code block StructValue u code u pgbench gt show shared preload libraries r n shared preload libraries r n r n google insights pg stat statements password validation r n row r n r npgbench gt create extension pg stat statements r nCREATE EXTENSION r n r npgbench gt dx pg stat statements r nList of installed extensions r n Name Version Schema Description r n r npg stat statements public track planning and execution statistics of all SQL statements executed u language u u caption lt wagtail wagtailcore rich text RichText object at xebcd gt The official documentation for PostgreSQL covers the pg stat statements extension in great detail In this blog we will discuss how to track nested calls as part of procedural calls using the flag pg stat statements track During performance investigation we might encounter a procedural call labelled as problematic or consuming considerable time in terms of execution It becomes difficult to debug problematic statements or nested statements within procedural code causing or impacting overall performance When pg stat statements track is set to all nested queries executed within a procedural statement can be captured as part of the pg stat statements view itself Let s create faulty procedural calls and run it as part of SQL in a loop code block StructValue u code u CREATE OR REPLACE FUNCTION public sampleproceduralblock id integer RETURNS boolean r n LANGUAGE plpgsql r n AS r nDECLARE r ncnt bigint r nBEGIN r n select count into cnt from pgbench accounts where bid id r n if cnt gt then r n return true r n else r n return false r n end if r nEND u language u u caption lt wagtail wagtailcore rich text RichText object at xebb gt The procedure for checking the existence of records uses count aggregation on an unindexed filter column bid If the procedure is called multiple times it will add overhead to the overall performance of the procedure To get a clean result we will reset pg stat statements to capture all SQL as fresh runs code block StructValue u code u pgbench gt select pg stat statements reset r n pg stat statements reset r n r n r n row u language u u caption lt wagtail wagtailcore rich text RichText object at xebde gt Let s execute the faulty procedural block repeatedly and query the pg stat statements extension to get the runtime execution time code block StructValue u code u pgbench gt select public sampleproceduralblock col from generate series col r n r npgbench gt select query total exec time toplevel from pg stat statements where query like sampleproceduralblock r nquery total exec time toplevel r n r nselect public sampleproceduralblock col from generate series col t r n row r nProcedural calls are recorded as top level calls and take a total of seconds If we need to check if any nested calls are included in the top procedure call we can use queries similar to the following r npgbench gt select query total exec time toplevel from pg stat statements where toplevel false r nquery total exec time toplevel r n r nselect count from pgbench accounts where bid id f r n row u language u u caption lt wagtail wagtailcore rich text RichText object at xebde gt It highlights nested SQL calls within faulty procedural calls as a problematic statement Now that we know which nested calls are problematic we can provide recommendations and fix the overall procedural executions pg stat statements track setting needs to change only for testing and finding problematic nested calls during the quality assurance phase changing in a high workload environment may have additional overhead What s next PostgreSQL native observability options such as pgBadger and the pg stat statements extension enable database developers and administrators to continue leveraging tools they are familiar with when using Cloud SQL for PostgreSQL  Unlike Cloud SQL insights pgBadger requires all necessary logging to be enabled in order to generate a complete report A partial report will be generated if this is not done Additionally a server or GCE instance is required to download and generate a report with pgBadger Cloud SQL for PostgreSQL gives customers the best of both worlds native PostgreSQL features and Cloud SQL insights Cloud SQL insights provide intuitive monitoring and root cause analysis for performance issues We will cover Cloud Insights in the next part of this Database Observability series In the meantime you can learn more about this topic in our documentation	2023-08-02 16:30:00