[DiscordArchive] this is not rly support question but do u have any tips for optimizing mysql performance ?
[DiscordArchive] this is not rly support question but do u have any tips for optimizing mysql performance ?
Original source
this is not rly support question but do u have any tips for optimizing mysql performance ?
rektbyfaith
05-07-2023, 03:29 PM #1Archived author: Rymercyble • Posted: 2023-05-07T15:29:16.046000+00:00
Original source
this is not rly support question but do u have any tips for optimizing mysql performance ?
Original source
I would like to say use async
rektbyfaith
05-07-2023, 03:50 PM #2Archived author: Revision • Posted: 2023-05-07T15:50:12.693000+00:00
Original source
I would like to say use async
Original source
Loading data is obvious, load once and only once.
rektbyfaith
05-07-2023, 03:51 PM #3Archived author: Revision • Posted: 2023-05-07T15:51:33.245000+00:00
Original source
Loading data is obvious, load once and only once.
Original source
im not sure i understand
rektbyfaith
05-07-2023, 03:58 PM #4Archived author: Rymercyble • Posted: 2023-05-07T15:58:00.888000+00:00
Original source
im not sure i understand
Original source
Loading data you only do once, store it, and saving data depending on what it is you can look at how the core does it and only save every so often instead of constantly. If you only run one query to save there's no real need to optimize it though.
rektbyfaith
05-07-2023, 04:06 PM #5Archived author: Revision • Posted: 2023-05-07T16:06:22.061000+00:00
Original source
Loading data you only do once, store it, and saving data depending on what it is you can look at how the core does it and only save every so often instead of constantly. If you only run one query to save there's no real need to optimize it though.
Original source
but how is that related to optimizing mysql performance ? i meant actual mysql like config
rektbyfaith
05-07-2023, 04:08 PM #6Archived author: Rymercyble • Posted: 2023-05-07T16:08:36.119000+00:00
Original source
but how is that related to optimizing mysql performance ? i meant actual mysql like config
Original source
You weren't clear. I would just Google it.
rektbyfaith
05-07-2023, 04:09 PM #7Archived author: Revision • Posted: 2023-05-07T16:09:07.641000+00:00
Original source
You weren't clear. I would just Google it.
Original source
https://tenor.com/view/just-google-it-br...f-16817409
rektbyfaith
05-07-2023, 04:09 PM #8Archived author: Revision • Posted: 2023-05-07T16:09:52.682000+00:00
Original source
https://tenor.com/view/just-google-it-br...f-16817409
Original source
ye i tried i added like 10 config options and sql dump import still takes same time sooo
rektbyfaith
05-07-2023, 04:10 PM #9Archived author: Rymercyble • Posted: 2023-05-07T16:10:24.569000+00:00
Original source
ye i tried i added like 10 config options and sql dump import still takes same time sooo
Original source
why not to ask right ¯\_(ツ)_/¯
rektbyfaith
05-07-2023, 04:11 PM #10Archived author: Rymercyble • Posted: 2023-05-07T16:11:29.633000+00:00
Original source
why not to ask right ¯\_(ツ)_/¯