MariaDB [teeworlds]> SELECT COUNT(*) FROM record_race;
+----------+
| COUNT(*) |
+----------+
| 44112090 |
+----------+
1 row in set (4 min 48.738 sec)
Row counts are surprisingly expensiveMariaDB [teeworlds]> SELECT COUNT(*) FROM record_race;
+----------+
| COUNT(*) |
+----------+
| 44112090 |
+----------+
1 row in set (4 min 48.738 sec)
Row counts are surprisingly expensive EXPLAIN SELECT COUNT(*) FROM record_race;
SELECT table_rows FROM information_schema.tables WHERE table_name = 'record_race';
SELECT table_rows FROM information_schema.tables WHERE table_name = 'record_race';
MariaDB [teeworlds]> EXPLAIN SELECT COUNT(*) FROM record_race;
+------+-------------+-------------+-------+---------------+-----------+---------+------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------------+-------+---------------+-----------+---------+------+----------+-------------+
| 1 | SIMPLE | record_race | index | NULL | Timestamp | 4 | NULL | 27346608 | Using index |
+------+-------------+-------------+-------+---------------+-----------+---------+------+----------+-------------+
MariaDB [teeworlds]> SELECT COUNT(*) FROM record_race;
+----------+
| COUNT(*) |
+----------+
| 44117349 |
+----------+
1 row in set (9.443 sec)
sudo apt update
a bad command to run in a github action?- name: Install dependencies
run: sudo apt update && sudo apt install libavutil-dev libavformat-dev libavfilter-dev libavdevice-dev
(edited)Thread 83 "DDNet" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7ffe7ffff6c0 (LWP 15478)]
0x00007ffff3d87f46 in __memmove_avx512_unaligned_erms ()
from /nix/store/sl141d1g77wvhr050ah87lcyz2czdxa3-glibc-2.40-36/lib/libc.so.6
happens on ddnet master and steam beta, didnt happen before
❯ ldd --version
ldd (GNU libc) 2.40
Thread 83 "DDNet" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7ffe7ffff6c0 (LWP 15478)]
0x00007ffff3d87f46 in __memmove_avx512_unaligned_erms ()
from /nix/store/sl141d1g77wvhr050ah87lcyz2czdxa3-glibc-2.40-36/lib/libc.so.6
happens on ddnet master and steam beta, didnt happen before
❯ ldd --version
ldd (GNU libc) 2.40
-1
was considered non-textured whereas all invalid values should be.
m_pClient->m_aClients[ClientId].m_PrevPredicted.m_Tuning.m_LaserUnDeep
xyz