Slow SQL #1

New issue

Closed

opened 2024-08-30 00:15:43 +02:00 by maplepy · 3 comments

maplepy commented

2024-08-30 00:15:43 +02:00

Not an issue per se I think but I have this popping up a lot

2024/08/30 00:04:43 /home/simon/www/repo/freetube-sync/web/controller/history/controller.go:23 SLOW SQL >= 200ms
[221.802ms] [rows:1] INSERT INTO `watched_videos` (`deleted_at`,`video_id`,`title`,`author`,`author_id`,`published`,`description`,`view_count`,`length_seconds`,`watch_progress`,`time_watched`,`is_live`,`type`,`remote_id`,`last_viewed_playlist_type`,`last_viewed_playlist_item_id`) VALUES (NULL,"nSBQyFMx5E4","Dead Game. Just ask Reddit.  - Dark and Darker","Onepeg","UCFyX27M0e8NW0kysAsY1Grg",1699311131000,"playing the game that others won&apos;t. someone has to do it.

Seeing /home/simon is a bit weird when there is no simon at my /home. I know this is your name but I don't know why I have this in my logs when I am hosting the sync server on my own server?

Also I'm not sure if you'll get a lot of feedback on the app because it was very tedious to register to gitnet tbh. The sign up was down several times, then the login was down. So yeah just be aware of this.

Merci pour l'app je vais tester ca en tout cas dans les prochains jours :)

Not an issue per se I think but I have this popping up a lot ``` 2024/08/30 00:04:43 /home/simon/www/repo/freetube-sync/web/controller/history/controller.go:23 SLOW SQL >= 200ms [221.802ms] [rows:1] INSERT INTO `watched_videos` (`deleted_at`,`video_id`,`title`,`author`,`author_id`,`published`,`description`,`view_count`,`length_seconds`,`watch_progress`,`time_watched`,`is_live`,`type`,`remote_id`,`last_viewed_playlist_type`,`last_viewed_playlist_item_id`) VALUES (NULL,"nSBQyFMx5E4","Dead Game. Just ask Reddit. - Dark and Darker","Onepeg","UCFyX27M0e8NW0kysAsY1Grg",1699311131000,"playing the game that others won't. someone has to do it. ``` Seeing /home/simon is a bit weird when there is no simon at my /home. I know this is your name but I don't know why I have this in my logs when I am hosting the sync server on my own server? Also I'm not sure if you'll get a lot of feedback on the app because it was very tedious to register to gitnet tbh. The sign up was down several times, then the login was down. So yeah just be aware of this. Merci pour l'app je vais tester ca en tout cas dans les prochains jours :)

maplepy commented

2024-08-30 00:22:39 +02:00

Author

I got questions too:

Will you make a docker service for the server? If not or not interested, I could do one for you.
Will you make the client app (and maybe server) available on the AUR?
Just to make sure, it syncs everything as in: playlists, history, subscription and settings or only a few of those?

Thank you :)

I got questions too: 1. Will you make a docker service for the server? If not or not interested, I could do one for you. 2. Will you make the client app (and maybe server) available on the AUR? 3. Just to make sure, it syncs everything as in: playlists, history, subscription and settings or only a few of those? Thank you :)

maplepy started working

2024-08-30 00:22:46 +02:00

maplepy canceled time tracking

2024-08-30 00:22:51 +02:00

deblan commented

2024-08-30 09:40:41 +02:00

Owner

Hi,

The problem with /home/simon seems to be linked with the way I compile the server. I will have a look!

Also I'm not sure if you'll get a lot of feedback on the app because it was very tedious to register to gitnet tbh. The sign up was down several times, then the login was down. So yeah just be aware of this.

What do you mean with "The sign up was down several times"?

Will you make a docker service for the server? If not or not interested, I could do one for you.

It's on my todo list but of you want to help I appreciate.

Will you make the client app (and maybe server) available on the AUR?

I'm not a arch user to I don't kown how to package to AUR. But I could have a look too.

Just to make sure, it syncs everything as in: playlists, history, subscription and settings or only a few of those?

All playlists, profiles (containing subscriptions) and history are synced. The settings are not synced. However I noticed that deleting the history does not work. Deletion must be done manually on all clients.

Hi, The problem with `/home/simon` seems to be linked with the way I compile the server. I will have a look! > Also I'm not sure if you'll get a lot of feedback on the app because it was very tedious to register to gitnet tbh. The sign up was down several times, then the login was down. So yeah just be aware of this. What do you mean with "The sign up was down several times"? > Will you make a docker service for the server? If not or not interested, I could do one for you. It's on my todo list but of you want to help I appreciate. > Will you make the client app (and maybe server) available on the AUR? I'm not a arch user to I don't kown how to package to AUR. But I could have a look too. > Just to make sure, it syncs everything as in: playlists, history, subscription and settings or only a few of those? All playlists, profiles (containing subscriptions) and history are synced. The settings are not synced. However I noticed that deleting the history does not work. Deletion must be done manually on all clients.