giovedì 8 giugno 2023
AlphaDev Solves Algorithms Faster Than Humans
mercoledì 31 maggio 2023
Repair slave in MySQL GTID replication, after fatal error 1236 (slave has more GTIDs than the master)
For repairing a broken slave after fatal error 1236.
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave has more GTIDs than the master has, using the master's SERVER_UUID. This may indicate that the end of the binary log was truncated or that the last binary log file was lost, e.g., after a power or disk failure when sync_binlog != 1
slave# stop slave for channel 'mymaster';
slave# reset slave for channel 'mymaster';
slave# set gtid_next='automatic';
slave# change master to master_auto_position=1 for channel 'mymaster';
slave# start slave for channel 'mymaster';
slave# show slave status for channel 'mymaster'\G
lunedì 19 dicembre 2022
OpenAI ChatGPT
ChatGPT, which stands for Chat Generative Pre-trained Transformer, is a chatbot developed by OpenAI. ChatGPT is built on top of OpenAI's GPT-3.5 family of large language models, and is fine-tuned with both supervised and reinforcement learning techniques.
ChatGPT was launched as a prototype in November 2022, and quickly garnered attention for its detailed responses and articulate answers across many domains of knowledge.
It was fine-tuned on top of GPT-3.5 using supervised learning as well as reinforcement learning. Both approaches used human trainers to improve the model's performance. In the case of supervised learning, the model was provided with conversations in which the trainers played both sides: the user and the AI assistant. In the reinforcement step, human trainers first ranked responses that the model had created in a previous conversation. These rankings were used to create 'reward models' that the model was further fine-tuned on using several iterations of Proximal Policy Optimization (PPO). Proximal Policy Optimization algorithms present a cost-effective benefit to trust region policy optimization algorithms; they negate many of the computationally expensive operations with faster performance. The models were trained in collaboration with Microsoft on their Azure supercomputing infrastructure.
martedì 5 aprile 2022
Pathways Language Model (PaLM): Scaling to 540 Billion Parameters for Breakthrough Performance
Google AI introduced the 540 billion parameter Pathways Language Model. Trained on two Cloud #TPU v4 pods, it achieves state-of-the-art performance on benchmarks and shows exciting capabilities like mathematical reasoning, code writing, and even explaining jokes. https://goo.gle/3j6eMnK
PaLM demonstrates the scaling capability of the Pathways system to thousands of accelerator chips across two TPU v4 Pods by training a 540-billion parameter model efficiently with a well-studied, well-established recipe of a dense decoder-only Transformer model. Pushing the limits of model scale enables breakthrough few-shot performance of PaLM across a variety of natural language processing, reasoning, and code tasks.
PaLM paves the way for even more capable models by combining the scaling capabilities with novel architectural choices and training schemes, and brings us closer to the Pathways vision:
<<Enable a single AI system to generalize across thousands or millions of tasks, to understand different types of data, and to do so with remarkable efficiency.>>
giovedì 17 giugno 2021
How to Kill MySQL Queries
The command SHOW PROCESSLIST lists all the open connections to the server
mysql> SHOW PROCESSLIST;
In order to kill a thread completely, use the KILL command followed by the thread ID returned by SHOW PROCESSLIST:
mysql> KILL 1234;
martedì 20 aprile 2021
Repair slave in MySQL GTID replication, after fatal error 1236 (master has purged binary logs)
For repairing a broken slave after fatal error 1236.
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.'
slave# reset master;
slave# source /pathto/dump.sql;
slave# start slave for channel 'mymaster';
slave# show slave status for channel 'mymaster'\G
Here is another useful tutorial, if the problem persists