Tag Info

Hot answers tagged

4

MyISAM For a MyISAM table mydb.mytable, you should have three files \bin\mysql\mysql5.6.12\data\mydb\mytable.frm \bin\mysql\mysql5.6.12\data\mydb\mytable.MYD \bin\mysql\mysql5.6.12\data\mydb\mytable.MYI They should already be accessible as a table since each file contains needed data, metadata, and index info. Collectively, they form the table. There ...


3

Yes, if you use phpMyAdmin on your WAMP server, you can use the Export tab to dump your database and all the data in it. On the Export tab, choose the Custom export method. This opens a bunch of options. Under Save Output to a File, choose Compression and you get to choose zipped from a drop-down. Then you can Import that zip to another MySQL instance on ...


3

The differences have to do with the expected capacity mysqld is requested to handle my_huge.ini does not have max_connections set has innodb settings commented out values preset sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M my-innodb-heavy-4G.ini has max_connections set at 100 has innodb settings ...


2

In your Error Log : [ERROR] Slave I/O: error connecting to master 'master@192.168.1.100:3306' - retry-time: 60 retries: 86400, Error_code: 2003 Error_code: 2003 : The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has ...


2

The most common cause of this is virus scanning, as virus scanners tend to lock files. Try excluding the directory from scanning.


2

In a WAMP environment, a developer is probably more focused on Coping PHP/Perl/Python Configuring Apache to get the WebServer going Using MySQL to store data, far less concern for the MySQL Utilities and other Bells and Whistles Getting Windows to coordinate the use of Apache, PHP, and MySQL (If you use IIS instead of Apache, that means the environment is ...


1

Even with all the changes you have implemented in my.ini, I would like to suggest just one more: I noticed you did not set innodb_buffer_pool_instances. According to the MySQL Documentation, this is what innodb_buffer_pool_instances is for: The number of regions that the InnoDB buffer pool is divided into. For systems with buffer pools in the ...


1

For something like this, you may want to think about a unique architecture known as a Star Topology. Picture the following: Server HQDB with 25 databases (1 for each branch) Server BranchDB001 with database `branch001`` Server BranchDB002 with database branch002 ... Server BranchDB025 with database branch025 Setup Data for HQDB On HQDB, create the 25 ...


1

The authors of High Performance MySQL describe part of your problem fairly succinctly (p. 234): MySQL can’t execute a single query in parallel on many CPUs. This is a feature offered by some other database servers, but not MySQL. Running a single stored procedure will use no more than 1 of your CPU cores for executing queries, with a little extra on ...


1

Here is the only thing I can advise for now: Open a DOS Window and run the following C:\> dir mysql.user /s If you see two mysql.user files, then you may have two DB setups. You would just have to point datadir in my.cnf back to the old setup. Please find out and let me know ...


1

You forgot one thing binlog-do-db=our_database binlog-ignore-db=mysql binlog-ignore-db=test replicate-do-db=our_database log-slave-updates The option log-slave-updates takes SQL that was read from relay logs and records them in the Slave Binary Logs when the SQL is completed. Please be very careful. You should never use binlog-do-db and ...


1

Whether you have Server configured with WAMP or as a Dedicated DB, the concepts for setting up multimaster replication is identical. Before I go on, let me clarify the phrase multimaster replication. True multimaster replication would have a Slave with Multiple Masters. It is not possible at present. MySQL 5.6 is approaching this. I think MariaDB as well. ...


1

When MySQL is really slow on windows (not 30ms slower) is nearly always a matter of a forgotten localhost instead of 127.0.0.1 in settings or URL. Very few times it is due to a very slow fragmented hard drive (acting slower due to windows complex ACL and parallel processes using it). MySQL is slower in some benchmarks on windows but the difference is so ...


1

I have a suggestion On the Slave run the following: STOP SLAVE; CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=95849; START SLAVE; SELECT SLEEP(15); SHOW SLAVE STATUS\G This will reset all relay logs and attempt to connect from the log file and position from the error message. If you get Slave_IO_Running: Connecting, there are two ...



Only top voted, non community-wiki answers of a minimum length are eligible