Can i rank my keyword on Amazon Search engine ?

Hello everyone,

how can i rank my keyword on Amazon Search engine

mysql – MariaDB crashed: Unknown/unsupported storage engine: InnoDB

I’ve a Debian GNU/Linux 9 (4GB, 2 CPUs) on Digitalocean. Tonight (I’ve done nothing) my DB (mariaDB) crashed with this errors. I ran a wordpress with InnoDB and myISAM tables:

2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Using mutexes to ref count buffer pool pages
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: The InnoDB memory heap is disabled
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Compressed tables use zlib 1.2.8
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Using Linux native AIO
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Using SSE crc32 instructions
2020-10-17  0:51:18 140430430813568 (Note) InnoDB: Initializing buffer pool, size = 500.0M
InnoDB: mmap(549126144 bytes) failed; errno 12
2020-10-17  0:51:18 140430430813568 (ERROR) InnoDB: Cannot allocate memory for the buffer pool
2020-10-17  0:51:18 140430430813568 (ERROR) Plugin 'InnoDB' init function returned error.
2020-10-17  0:51:18 140430430813568 (ERROR) Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-10-17  0:51:18 140430430813568 (Note) Plugin 'FEEDBACK' is disabled.
2020-10-17  0:51:18 140430430813568 (ERROR) **Unknown/unsupported storage engine: InnoDB**
2020-10-17  0:51:18 140430430813568 (ERROR) Aborting


My full DB conf:

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
(server)

# this is only for the mysqld standalone daemon
(mysqld)

#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 127.0.0.1

#
# * Fine Tuning
#
key_buffer_size     = 16M
max_allowed_packet  = 16M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam_recover_options  = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10

innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 500M
max_heap_table_size     = 25M
tmp_table_size          = 25M
#log_slow_queries        = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

#
# * Query Cache Configuration
#
query_cache_limit   = 2M
query_cache_size        = 50M

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Enable the slow query log to see queries with especially long duration
#slow_query_log_file    = /var/log/mysql/mariadb-slow.log
#long_query_time = 10
#log_slow_rate_limit    = 1000
#log_slow_verbosity = query_plan
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id      = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size   = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = exclude_database_name

#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!

#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates you can use for example the GUI tool "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
#
# Accept only connections using the latest and most secure TLS protocol version.
# ..when MariaDB is compiled with OpenSSL:
# ssl-cipher=TLSv1.2
# ..when MariaDB is compiled with YaSSL (default in Debian):
# ssl=on

#
# * Character sets
#
# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
# utf8 4-byte character set. See also client.cnf
#
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci

#
# * Unix socket authentication plugin is built-in since 10.0.22-6
#
# Needed so the root database user can authenticate without a password but
# only when running as the unix root user.
#
# Also available for other users if required.
# See https://mariadb.com/kb/en/unix_socket-authentication-plugin/

# this is only for embedded server
(embedded)

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
(mariadb)

# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
(mariadb-10.1)

Here my first page of htop
htop result after some minutes
Could not export/copy htop result.

I would be happy if you could help me out!!

Thanks a lot
M

architecture – Instantiating GameObjects in Custom Game Engine

So,i’m having a bit of an issue with instantiating my gameobjects into to universe(My Scene object).

I can create an empty object from scratch and populate it from there with ease,my problem starts when i try to clone the gameobject which i just created.

My steps are

  1. I create an empty gameobject (GAMEOBJECT A)
  2. I add an component to it (COMPONENT A)
  3. Now i create a gameobject B from A
  4. GameObject B created,and the component A is in the component list of the gameobject B
  5. I try to get the component using inheritance but nullptr returns

It seems when i try to clone components,it returns only the base class pointer.There i try to recreate the derived class and add it to new gameobject’s component list but obviously i fail.

  • If i cant solve this with inheritance how can i solve it ?
  • is there better way to implement such a desing ?
  • or i just fail to use inheritance in c++.If it’s, can you guys point out what am i doing wrong here

This is my GameObject AKA RGameElement

enter image description here

This is my Component AKA RElementComponent

enter image description here

and this my Instantiate via gameobject ref function

enter image description here

storage engine – Non RAM based in-browser database solutions?

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based in-browser SQL engines (MiniSearch, AlaSQL, etc) are limited.

Yeaterday I made a demo: I sorted and partitioned my key-value database into 1000 line files and I made an index for the files also. You can try out my demo here, or check it out on GitHub

So my question is that are there any better solutions for large-in-browser databases? (I don’t really want to reinvent the wheel 😆)

physics engine – Retractable object in unity

I’m trying to get the physics of a retractable object in unity,
So I will be able to “launch” an elastic cable (similar to rope physics) out of an object (e.g. A gun),
And the cable will gradually/exponentially “roll back” into the object.
A good reference would be Batman’s grapple gun.

I thought of utilizing it using a spring joint, but I can’t really get the exact mechanics I’m trying to achieve.

Any ideas?

Thank you in advance.

Unreal Engine 4 Animation Tutorials

I am trying to find a really good animation tutorial for Unreal Engine 4 that covers how to do things like have the character react to where objects are and what is happening like when falling, picking items up, uneven ground, and other more complicated aspects to animations in games. I mostly make shooters and have I think a good grasp of animation blueprints. I’ve looked all over for tutorials on YouTube and Udemy but all of them simply cover blend spaces, anim offsets, and the event graph and animation blueprint. I have all of this down and have created a fully fledged blueprint that works for a third person shooter, it looks decent but looks really basic and not dynamic. Here’s an example of what I want to learn to do: Example. It looks dynamic with things like the body bending as he runs, grabbing ledges, vaulting, and ragdoll physics when he fell into a truck. It all looks fluid and not like a bunch of free looping animations from the marketplace which is what my game looks like. The feel of a game I’m going for is something like Squad incase that helps with any answers but I mostly just want to learn more about animation in UE4 so if you could recommend a tutorial to help with this that would be awesome, thanks!

physics engine – Collision response using the Minimum Translation Vector

I am trying to use the Minimum Translation Vector (MTV) returned from the SAT algorithm for simple collision response. Please see the example below.

enter image description here

By separating the colliding boxes by moving the black box along the MTV, the box is now colliding with the other green box below. Moving the black box along the MTV for the collision with this new box then brings the box back to colliding with the first box, and an infinite cycle of trying to separate the boxes begins.

Am I missing something, or is collision response not possible using the MTV?

How to enable bash completion on Google Compute Engine?

The compute instances I’m running is a Debian Buster. Normally there’s exists a /etc/bash_completion file. However for GCE, it’s missing. There’s even a section they’ve added in the default ~/.bashrc to refer to the bash completion files which none of them exists.

if ! shopt -oq posix; then
  if [ -f /usr/share/bash-completion/bash_completion ]; then
    . /usr/share/bash-completion/bash_completion
  elif [ -f /etc/bash_completion ]; then
    . /etc/bash_completion
  fi
fi

search engine indexing – Google does not index pages and defines wrong canonical

I have a domain, andrasnovoszath.com which previously I redirected to another one bcdataanalytics.com. About a month ago I stopped the redirect and started to write posts on it as on a separate site.

Google does not index the pages, save a few early ones, and only one later one. Even more, in the search results, it shows a page from bcdataanalytics.com, that is, from the page to where I redirected this page previously.

I checked and the google search console seems to believe that the canonical page is the one I was redirecting to (even though there is no overlapping content at all):

User-declared canonical: https://andrasnovoszath.com/andrasnovoszath.com/

Google-selected canonical: https://www.bcdataanalytics.com/

I requested reindex multiple times but that did not help.

I reviewed this StackExchange for similar issues but most of the canonical problems were about actual duplicate content or slight variations of the same URL (e.g. translations). The closest thing I found was this but there is no solution.

I would appreciate any tips, ideas on how to approach the problem. Thanks!

seo – How to diagnose a search engine ranking drop?

Some possibilities:

  • The sites who moved up in the rankings may have gotten quality links that boosted their relevancy (as opposed to you losing relevancy).

  • You may have lost quality links

  • The sites that leaped ahead of you made big improvements in their SEO and now are reaping the rewards

  • There was a small algorithm change that played to the other sites’ strengths

  • There was a small algorithm change that played against your weaknesses

Also keep in mind that rankings naturally fluctuate. It’s very possible you will return to your previous rankings soon without having to change anything on your site.

One thing you should do is check to see if any of the sites that moved ahead of you are new or if they made any changes (if you don’t check out the competition regularly you may not be able to do this). If so, you may want to make similar changes and see if it helps you. Be prepared to roll the changes back if they do not help or hurt your rankings.

My advice whenever someone has this occur is always don’t panic and don’t change anything. This is a perfect opportunity for you to make changes that you really don’t need to make and they end up hurting you in the end.

If your content is still strong then wait it out. Keep getting links to your pages. Don’t panic. Be patient.

update

To diagnose a drop you need to:

  1. Undo any recent changes and wait to see if your rankings revert back.

  2. Make sure you are up to date on Google’s latest changes to their algorithm and see if any of them apply to you. If so, make changes that should affect that algorithm change and wait to see what happens. If nothing changes then rollback your content as that was the last known well-ranking format for your content.

That’s about it. If you didn’t change anything and Google hasn’t made any announced changes then you have to assume your competitors got better either through better content/SEO or minor tweaks at Google that were unannounced and difficult to test for. In this case just keep plugging away. If your content is strong, you will regain your old positioning at some point.