Skip to main content

Search

Items tagged with: mysql


 
Critical Patch Update: Oracle veröffentlicht Paket mit 297 Sicherheitsupdates #CriticalPatchUpdate #FusionMiddleware #JavaSE #MySQL #Oracle #Patchday #Sicherheitslücken #Updates


 
Looks like I'm going to have to transfer my Wordpress site from Mariadb to MySQL. It seems as though MariaDB still lacks the GIS function ST_Distance_Sphere() which I'm going to need for future work. #mariadb #mysql


 
Looks like I'm going to have to transfer my Wordpress site from Mariadb to MySQL. It seems as though MariaDB still lacks the GIS function ST_Distance_Sphere() which I'm going to need for future work. #mariadb #mysql


 
[url= [url]https://www.kitaadmin.com/2019/03/pengertian-easyengine.html]easyengine[/url] adalah[/url]

#server #nginx #php #mysql #linux #easy #engine # Debian #ubuntu


 
Datenschutz: Facebook speicherte Millionen Passwörter im Klartext #Passwort #BrianKrebs #Cookies #DSGVO #Datenschutz #Datensicherheit #Git #Microblogging #MySQL #PHP


 
There will be some downtime today as we attempt to migrate the database from MariaDB to Postgresql to improve performance. Thanks for your patience.

#gibberfish #database #mariadb #mysql #postgresql #maintenance #downtime


 

MariaDB startup chush


I'm not sure what else to try. Every time I get this lousy mariadb crush on my server startup. Like every time I reboot - mariadb crushes. Then some timeout expires, the system boots degraded, i simply start mariadb and it works like nothing had happened. Restarting it doesnt cause this trouble, it doesn't crush for months but every time i reboot the server it down.
I tried to do those table checkups, restore, optimize but nothing seems to change it. It doesnt bother me much but it doesn't seem right.

Does anyone have any idea what can posibly go wrong there?

@Rоссийская Fедерация Добавлю бота для расшире... show more


 
MySQL-Fork: MariaDB kündigt Enterprise-Server an #MariaDB #Datenbank #Ende-zu-Ende-Verschlüsselung #Linux #MySQL #SQL #Server-Applikationen #Unternehmenssoftware #Server #Applikationen


 

MySQL Challenge: 100k Connections


HN Discussion: https://news.ycombinator.com/item?id=19248104
Posted by PeterZaitsev (karma: 252)
Post stats: Points: 133 - Comments: 36 - 2019-02-25T18:37:40Z

#HackerNews #100k #challenge #connections #mysql
HackerNewsBot debug: Calculated post rank: 100 - Loop: 368 - Rank min: 100 - Author rank: 39


 

Hubzilla VM lebt noch


Wie es aussieht konnte ich meine Hubzilla VM retten.
Ich habe die MySQL DB optimiert mit: mysqlcheck --all-databases --optimize
Und dann habe ich einen USB 3.0 Stick als SSD Cache genommen.
Tja, es hat wohl geholfen, die I/O Auslastung ist erträglich und alles läuft wieder rund.

Keine Ahnung wieso Mysql ständig am lesen und schreiben ist. Außer mir nutzt diese Instanz niemand und pro Minute werden mehr Daten gelesen/geschrieben als über das Netzwerk rein kommen.

#Hubzilla #Mysql


 
Just doing a bit of reading at the moment on Mariadb transactional isolation levels, and wondered what the recommended choice is for a Friendica system? It seems that most popular database systems are set to READ COMMITED by default, but not mysql which is set to READ REPEATABLE.

#friendica #mysql #mariadb


 

Hubzilla


Meine Hubzilla VM verlangsamt mein ganzes System. Eigentlich ist es die Hubzilla Datenbank. Meine Festplatte ist die ganze Zeit beschäftigt und der io wait daher immer über 50%.
Mysql tunen hat auch nichts gebracht.
Am Anfang lief alles gut mit 256-512MB Ram. Jetzt werden teilweise schon über 2GB gebraucht und alles läuft wie ein Sack Nüße.
Ich werde wohl die VM noch mal aufsetzen und dieses mal eine Postgres DB nehmen.
Hat jemand mit Hubzilla und Postgres erfahrung? (Anleitung oder Tipps?)

#Hubzilla #DB #Postgres #Mariadb #Mysql


 
!Friendica Support

I get this #MariaDB / #MySQL faults in the applications log:
mysqld[446]: 2019-02-07 12:12:30 65844 [Warning]Aborted connection 65844 to db: 'friendica' user: 'friendica' host: 'localhost' (Got an error writing communication packets)

I would like to find out the reason for this warning and found that it is one of this possibilities:
In this case, MySQL increments the status counter for Aborted_clients, which could mean:

The client connected successfully but terminated improperly (and may relate to not closing the connection properly)
The client slept for longer than the defined wait_timeout or interactive_timeout seconds (which ends up causing the connection to sleep for wait_timeout seconds and then the connection gets forcibly closed by the MySQL server)
The client terminated abnormally or exceeded the max_allowed_packet for queries

According to: https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/

Does #Friendica write anything in the log and if so, how can I find these snipplets?


 

Cronjob mysql password error


I set up a #hubzilla server for the first time. Setting it up worked so far, hubzilla is running.

I also created the #cronjob as stated in the installation instructions, with */10 * * * * cd /var/www/html; /usr/bin/php Zotlabs/Daemon/Master.php Cron > /dev/null 2>&1

But now cron executed the job for the first time, and I got following error

Cron <root@Debian-95-stretch-64-minimal> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
/etc/cron.daily/logrotate:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate ex
... show more


 
DSGVO: Mehr als 12.000 Datenpannen in Deutschland gemeldet #Passwort #Cookies #DSGVO #Datenschutz #Datensicherheit #Git #Microblogging #MySQL #PHP #Programmiersprache


 
Datenbank: Lange bekannte MySQL-Lücke führt zu Angriffen #MySQL #Datenbank #Datensicherheit #Magento #Malware #MariaDB #PHP #Programmiersprache #Server-Applikationen #Sicherheitslücke


 
My #MySQL data directory is on a #btrfs formated drive, I want to do a backup, so the best way would be to do a snapshot with btrfs and then after a backup.
Any tips how to do this with #Linux? I am considering to start a second instance of MySQL and do a dump then, but there surely is better ways to accomplish this.

#Help for this #question is welcome!


 
My #MySQL data directory is on a #btrfs formated drive, I want to do a backup, so the best way would be to do a snapshot with btrfs and then after a backup.
Any tips how to do this with #Linux? I am considering to start a second instance of MySQL and do a dump then, but there surely is better ways to accomplish this.

#Help for this #question is welcome!


 
My #MySQL data directory is on a #btrfs formated drive, I want to do a backup, so the best way would be to do a snapshot with btrfs and then after a backup.
Any tips how to do this with #Linux? I am considering to start a second instance of MySQL and do a dump then, but there surely is better ways to accomplish this.

#Help for this #question is welcome!


 
Magento: Webserver über Schwachstelle im MySQL-Protokoll gehackt #Magecart #Magento #MySQL #Sicherheitslücken


 
#Pixelfed does not support #MariaDB yet? I thought MariaDB is compatible to #MySQL?


 
Urgent ! #JeRecrute ! Urgent !

On cherche un DBA pour 3 mois : démarrage de suite ! (le notre est Hors d'usage, faut lui changer un tendon à la patte)

#Postgresql #Oracle #Mysql

Poste sur Paris (Saint Lazarre) ou Nancy

me contacter par MP
#Boost #Aide #Emploi


 

postgreSQL or MySQL ?


#PostgreSQL #MySQL

@Mark Nowiasz a while ago (too lazy to dig up the quote) the difference, or lack thereof, between postgreSQL and MySQL came up in a discussion between us, but at the time i didn't want to dig into it. now this post by @Fla on D\* brought things back:
Podmins, which database are you running? Please answer the poll below.

PostgreSQL is faster than MariaDB / MySQL although it uses a bit more memory. The current diaspora* code base could be improved to reach better performance. Some queries could be optimized, but it's harder to do it with two database engines mainta
... show more


 

Podmins, which database are you running? Please answer the poll below.


PostgreSQL is faster than MariaDB / MySQL although it uses a bit more memory.
The current diaspora* code base could be improved to reach better performance. Some queries could be optimized, but it's harder to do it with two database engines maintained at the same time. So I'm wondering what would be the impact on the community if diaspora* stops supporting MySQL. Of course, this would come with a detailed migration guide and plenty of time to upgrade, with full support of the community. Remember: this is just a poll to know your opinion, no decision has been taken at the moment.

#diaspora #podmin #podmins #diaspora-dev #mysql #mariadb #postgresql


 

Datenbank Kompression


Ich hatte die letzten Tage gezeigt, dass es möglich ist eine Datenbank Kompression bei Mysql / MariaDB einzuschalten.
Damit bleibt die Datenbank schön klein aber wie es aussieht wird die CPU stärker belastet als gedacht.
Achso und natürlich werden die Schreib/Lese Zugriffe geringer, da weniger Daten geschrieben / gelesen werden müssen.
Eure SSD wird es auch danken 😛

\#Datenbank #Mysql #MariaDB #Hubzilla #Diaspora #Frendica #Mastodon #IT #Computer #Linux #Opensource


 

MySQL oder MariaDB


In kürze wechsle ich auf einen neuen Server. Im Moment mache ich mir Gedanken über die Datenbank. Ich betreibe neben Friendica noch einige Webseiten mit Joomla und WordPress. Bis jetzt habe ich #mysql eingesetzt. Vermehrt höre und lese ich, dass viele auf #mariadb wechseln. Lohnt sich das? Verändert sich da grossartig etwas bei der Administration? Was sind eure Meinungen und Erfahrungen? Vor allem auf #Friendica bezogen?

@Friendica Admins