is it possible to overload the xampp and mysql server

[mbenic]

hi im using xampp on my windows computer to run my websites
i have 13 wordpress websites at the moment all with their own installation of wordpress
i notice that the websites are sometimes slow to load
why is this so??
is it possible to overload xampp (and mysql server) with too many websites
thanks for help

[Altrea]

hi,

xampp is not configured with performance in mind. on fact xampp can run on very old slow computers.
besides that it is of course a matter of count of simultanious requests and hardware consumption.

[Nobbie]

is it possible to overload xampp (and mysql server) with too many websites

Yes, of course.

[mbenic]

can someone tell me what these error messages mean
they are from the mysql server log file


2021-07-12 18:41:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-12 18:41:22 0 [Note] InnoDB: Uses event mutexes
2021-07-12 18:41:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-12 18:41:22 0 [Note] InnoDB: Number of pools: 1
2021-07-12 18:41:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-12 18:41:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-12 18:41:22 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-12 18:41:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=52812524
2021-07-12 18:41:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-12 18:41:50 0 [Note] InnoDB: Uses event mutexes
2021-07-12 18:41:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-12 18:41:50 0 [Note] InnoDB: Number of pools: 1
2021-07-12 18:41:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-12 18:41:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-12 18:41:50 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-12 18:41:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=52812524
2021-07-12 18:41:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-12 18:41:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-12 18:41:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-12 18:41:52 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-12 18:41:52 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-12 18:41:52 0 [Note] InnoDB: Waiting for purge to start
2021-07-12 18:41:52 0 [Note] InnoDB: 10.4.19 started; log sequence number 52812533; transaction id 2974
2021-07-12 18:41:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-12 18:41:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-12 18:41:53 0 [Note] InnoDB: Buffer pool(s) load completed at 210712 18:41:53
2021-07-12 18:41:53 0 [Note] Server socket created on IP: '::'.

thanks for help

[Altrea]

these are normal starting stopping messages. nothing to worry about. especially this are not error messages at all.

[mbenic]

why are the messages in the error log if they are nothing to worry about
are these errors or 'notes' , and what is a note?
i ask because my mysql server is slow to start
and the websites are slow to load initially

[Nobbie]

As you can see, these are "Notes". A note is less than a warning and warning is less than an error. A note is only a remark.

In my.ini (or my.cnf - i dont know which one is on your installation) you can specify different values for the size of the data. There should be example configurations like my-large.cnf or even my-huge.cnf for system with large/huge amount of data. You also can google for these, you should try these (Xampps default is my-small.cnf or similar).

WordPress is well known for several runtime problems, as for slow databases etc.pp. You should ask WordPress support, we do not support WordPress here.

[mbenic]

ok thank you

[Altrea]

There should be example configurations like my-large.cnf or even my-huge.cnf for system with large/huge amount of data.

If still shipped with xampp i don't think they are so useful any more.
starting with MariaDB 10.3 the config has been slim lined very much so that a good working configuration just needs very few lines.

more to read about MariaDB performance optimization here:
https://mariadb.com/kb/en/configuring-m ... rformance/