3 Likes
#mysql
I kept getting CPU alerts for my #Ubuntu web server.
htop says that #MySQL was using the most CPU time - despite it not doing anything as I haven't fully set it up yet and it has nothing to do. htop reported it using about 15% of the CPU, but it shows up as almost 100% on the Akamai control panel. I'm not sure how to interpret this yet.
You can see when I turned the service off the CPU and disk dropped to almost nothing, which I would expect to be the case normally with all the services on. The server literally just hosts the LAMP stack with a single static HTML page. No big ask there. I'm still planning out the pages that will use PHP and MySQL, those are still on the drawing board.
Is there anywhere I can look for speeding up my pod? I know that I should be using Postegresql, but I did not know that in 2016! Is there any other "tweaks" I can make in the diaspora.yml
config file to "increase speed"?
Thank you in advance...
2 Comments
1 Shares
1 Comments
♲ Hypolite Petovan - 2022-11-16 16:46:53 GMT
#Friendica needs new contributors!
I'm not used to do this, but with the large influx of new users and node admins recently coming from #Twitter, our small team is now behind the curve for handling support requests, bug reports and bring about much-needed features.
The project is built on a #PHP / #MySQL platform, but we also need people to be able to assist others just using the software to give developers some space.
If you're willing and able to help, please follow @Friendica Support and the project on Github: https://github.com/friendica/friendica
Thank you!
One person like that
1 Shares
I rebuilt a system for keeping electronic notes for other programs, and moved that from a flat text file to a MySql database table, fixing the script and the 2 programs that use that information.
The name, in English, is a bit like ‘rubbish’, which holds dear memories of my first job, where we had a similar system to keep pointers, last-used-dates and other unrelated stuff together.
One person like that
MySQL: Boiling JFrogs | Die wunderbare Welt von Isotopp
https://blog.koehntopp.info/2022/08/25/mysql-boiling-jfrogs.html
3 Likes
● NEWS ● #Geshan ☞ How to use #MySQL with #Docker and Docker compose a beginners guide https://geshan.com.np/blog/2022/02/mysql-docker-compose/
#microsoft PR sites are twisting #mysql as a Microsoft #windows thing even though you should never deploy a database on such back-doored Swiss cheese with nasty performance overhead https://www.sitepoint.com/introducing-mysql-a-beginners-guide/
One person like that
[Blog] Spaß mit Python3 und InnoDB
#Python3 #MySQL #MariaDB #InnoDB #MyISAM #pymysql
(Woran man merkt, daß man zu oft zwischen HTML und Diaspora wechselt? Daß man im Blog Links mit eckigen Klammern und dem Linktext einleitet und den Link in Klammern setzt. Hab's zum Glück noch rechtzeitig vor Veröffentlichung gemerkt. 🤓)
One person like that
2 Comments
#MySQL vs. #MongoDB • Tux Machines ⇨ http://www.tuxmachines.org/node/160161 #GNU #Linux #TuxMachines
Database Management Service Uncomplicated: #MongoDB V/s #MySQL http://www.tuxmachines.org/node/159570#comment-32297
#PostgreSQL vs #MySQL : Compare #Database Management Systems • Tux Machines ⇨ http://www.tuxmachines.org/node/159570 #db #TuxMachines
List of Best #MySQL Workbench Alternatives ⚓ https://linuxhint.com/mysql-workbench-alternatives/ ䷉ #LinuxHint #GNU #Linux #FreeSW
● NEWS ● #SteinarHGunderson #MySQL ☞ Leaving MySQL https://blog.sesse.net/blog/tech/2021-12-05-16-41_leaving_mysql.html
#MySQL a 'pretty poor database' says departing Oracle engineer http://www.tuxmachines.org/node/158755#comment-31994
Steinar H. Gunderson Leaving MySQL • Tux Machines ⇨ http://www.tuxmachines.org/node/158755 #mysql #oracle #psql #db
Remote volunteer opportunity:
Smart AI Testing System
We are supporting millions of students from underdeveloped countries and improving their #English skills. You are enhancing their lives and the opportunities available to them, as well as exercising their brain!
Purpose
Ai Smart Quiz is based on #PHP or #Python and #MYSQL to detect our student's #grammar weaknesses.
We are looking for kind heart developers to help and build a smart #AI quiz program to help our students to identify their grammar weaknesses.
#SoftwareDevelopment #WebDevelopment #php #python #ai #volunteering #english #grammar
2 Likes
4 Comments
Pourquoi MYSQL n’est-il pas un moteur de recherche ?
https://developpeur-freelance.io/blog/developpement-web/pourquoi-mysql-nest-il-pas-un-moteur-de-recherche/
#mysql #php