datenbank probleme

    Hallo,
    bringen tut das Auslagern der DB i.d.R. nur was, wenn du die (wenige) [lexicon]Performance[/lexicon] sparen willst.
    Hoste die DB lieber auf deinem Server.

    Poste doch hier bitte deine Logs ([lexicon]extDB[/lexicon], Server- und Client-RPT). Ohne die läuft hier nichts.

    Wenn ich etwas missverstanden habe, hoppala

    Hallo,

    Die Datenbank auszulagern ist nicht empfehlenswert und ist meist ein Sicherheitsrisiko. Bitte poste deine logs. (extDB2- und Serverlog)

    Mit freundliche Grüßen

    Lukas B.

    _______________________________________________
    Scripting | Mapping | Designing

    Ich verlinke dir hier einmal eine hilfreiche Informationsseite, die dich über sowas aufklärt. Außerdem solltest du - wie zehntausend mal bereits erwähnt - Logs anhängen und das Problem genauer beschreiben.

    Spoiler anzeigen


    2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
    2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
    2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
    2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
    2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
    2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
    2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.26-74.0 started; log sequence number 1835027
    2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
    2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
    2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
    2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
    2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


    2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
    2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
    2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
    2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
    2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


    2017-01-03 16:23:36 10c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
    2017-01-03 16:23:36 268 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


    2017-01-03 16:23:36 268 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2017-01-03 16:23:36 268 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-01-03 16:23:36 268 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2017-01-03 16:23:36 268 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2017-01-03 16:23:36 268 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2017-01-03 16:23:36 268 [Note] InnoDB: Using generic crc32 instructions
    2017-01-03 16:23:36 268 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    2017-01-03 16:23:36 268 [Note] InnoDB: Completed initialization of buffer pool
    2017-01-03 16:23:36 268 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-01-03 16:23:36 268 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-01-03 16:23:36 268 [Note] InnoDB: Creating zip_dict and zip_dict_cols system tables.
    2017-01-03 16:23:37 268 [Note] InnoDB: zip_dict and zip_dict_cols system tables created.
    2017-01-03 16:23:37 268 [Note] InnoDB: Waiting for purge to start
    2017-01-03 16:23:38 268 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 1835037
    2017-01-03 16:23:38 5824 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2017-01-03 16:23:38 268 [Note] Plugin 'FEEDBACK' is disabled.
    2017-01-03 16:23:38 268 [Note] Server socket created on IP: '::'.
    2017-01-03 16:23:38 268 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
    2017-01-03 18:40:47 5188 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


    2017-01-03 18:40:47 5188 [Note] Event Scheduler: Purging the queue. 0 events
    2017-01-03 18:40:47 4404 [Note] InnoDB: FTS optimize thread exiting.
    2017-01-03 18:40:47 5188 [Note] InnoDB: Starting shutdown...
    2017-01-03 18:40:48 5188 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
    2017-01-03 18:40:49 5188 [Note] InnoDB: Shutdown completed; log sequence number 2142604
    2017-01-03 18:40:49 5188 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


    2017-01-04 15:38:10 9b4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
    2017-01-04 15:38:10 2484 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


    2017-01-04 15:38:10 2484 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2017-01-04 15:38:10 2484 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-01-04 15:38:10 2484 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2017-01-04 15:38:10 2484 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2017-01-04 15:38:10 2484 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2017-01-04 15:38:10 2484 [Note] InnoDB: Using generic crc32 instructions
    2017-01-04 15:38:10 2484 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    2017-01-04 15:38:10 2484 [Note] InnoDB: Completed initialization of buffer pool
    2017-01-04 15:38:11 2484 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-01-04 15:38:24 2484 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-01-04 15:38:24 2484 [Note] InnoDB: Waiting for purge to start
    2017-01-04 15:38:24 2484 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 2142604
    2017-01-04 15:38:24 2440 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2017-01-04 15:38:25 2484 [Note] Plugin 'FEEDBACK' is disabled.
    2017-01-04 15:38:25 2484 [Note] Server socket created on IP: '::'.
    2017-01-04 15:38:26 2484 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
    2017-01-06 16:31:49 3152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


    2017-01-06 16:31:49 3152 [Note] Event Scheduler: Purging the queue. 0 events
    2017-01-06 16:31:49 1880 [Note] InnoDB: FTS optimize thread exiting.
    2017-01-06 16:31:49 3152 [Note] InnoDB: Starting shutdown...
    2017-01-06 16:31:49 3152 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
    2017-01-06 16:31:51 3152 [Note] InnoDB: Shutdown completed; log sequence number 2142614
    2017-01-06 16:31:51 3152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


    2017-01-06 16:31:56 de4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
    2017-01-06 16:31:56 3556 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


    2017-01-06 16:31:56 3556 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2017-01-06 16:31:56 3556 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-01-06 16:31:56 3556 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2017-01-06 16:31:56 3556 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2017-01-06 16:31:56 3556 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2017-01-06 16:31:56 3556 [Note] InnoDB: Using generic crc32 instructions
    2017-01-06 16:31:56 3556 [Note] InnoDB: Initializing buffer pool, size = 16.0M
    2017-01-06 16:31:56 3556 [Note] InnoDB: Completed initialization of buffer pool
    2017-01-06 16:31:57 3556 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-01-06 16:31:58 3556 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-01-06 16:31:58 3556 [Note] InnoDB: Waiting for purge to start
    2017-01-06 16:31:58 3556 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 2142614
    2017-01-06 16:31:59 3656 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2017-01-06 16:31:59 3556 [Note] Plugin 'FEEDBACK' is disabled.
    2017-01-06 16:31:59 3556 [Note] Server socket created on IP: '::'.
    2017-01-06 16:31:59 3556 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

    Das sieht so aus als erstellt er den MySQL Server nicht richtig

    Zitat von SmokeTV

    2017-01-06 16:31:56 3556 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

    Also Du solltest auf jeden Fall mal die Konfig der DB anpassen und den Speicher von 16MB auf 20 erhöhen. Dann sieht es für mich erstmal auch so aus als ob da noch ein Fehler in der DB Konfig ist. Du startest die DB ohne IP und Port. Hast Du schon mal versucht mit einen DB-Tool an die DB ranzukommen? Normalerweise ist bei der Installation ein PHPMyAdmin dabei zum anlegen von DBs.

    Hallo,

    @moeck hat recht. Wenn alles nicht geht und du noch keine daten auf der DB hast, würde ich den DB Server mal komplet runterwerfen und neu installieren den für mich sieht es so aus, als wenn etwas bei der installation schief gelaufen ist.

    Mit freundliche Grüßen

    Lukas B.

    _______________________________________________
    Scripting | Mapping | Designing