Tag Info

New answers tagged

0

Je hebt een noodkrediet om schulden te betalen? Heeft u een lening nodig om een nieuw bedrijf te starten? Heeft u een persoonlijke lening nodig? Wij bieden geen leningen op 3%. Contacteer ons vandaag nog per e-mail op het volgende adres: finev@webadictos.net


0

Try this: MySQLTuner-perl by major PHP: APC - Manual


0

Typically you do NOT patch your MySQL binaries any more. But you also do NOT have to de-install the instance. You just have to replace the MySQL Binaries with the Galera-MySQL Binaries and install the Galera Plug-in. You best do this with the Galera Repository for Ubuntu: http://galeracluster.com/documentation-webpages/installmysql.html For the further ...


0

This is most probably caused by a memory issue. Swapped out memory to be precise. There must be some sort of a memory intensive task running in the idle period, and all your Apaches, phps, and others get swapped out. Once you try to connect, they get swapped in, but it takes a long time. Once they are back in memory, everything works fine. Solution: Add ...


0

I would suggest using established management systems like cpanel, interworx, and plesk, in conjunction with Cloudlinux w/db-governer and mariadb10 or newer. Cloudlinux will provide you with the separation you want and works with any of the above hosting panels. Attempting to do this manually is painful, but you could do it. I would start with cloudlinux. ...


0

Big cpu usage on insert/update into mysql without disk wait ? If it is insert - you have so many indexes. It's rebuild takes so many CPU. But i think, you run an update statement. If yes, look at "show full processlist" on your mysql server and post it there. I think, you have to add an index on some fields. look there: ...


2

You might have the wrong password for baduser - try resetting the password for that user and try again to see if that solves the issue. I tested and I get the exact same error message and error code when using an incorrect password. Note that you can have a different password for a user depending on what host it's connecting from. If that doesn't work, ...


1

I suppose that you are doing this as a testing purpose? I don't see any advantage doing this on the same host at all. I advise you to let go keepalived and use Corosync/Pacemaker. This is more reliable for HA. Give it a try.


2

The sql plugin provides configuration details but also credentials stored in a database. It's not required to store everything in the database and the data can be combined with that provided by other plugins. So it is possible to use the stroke plugin to provide configurations from ipsec.conf and certificates from /etc/ipsec.d/ but define the username and ...


0

If you have an app connected to it, the password should be stored in a config file. Usually other parts of the system depending on what you are running will store the password in plain text. I would also try opening phpmyadmin possibly your browser saved the password and you can export the data that way.


2

Okay. This is a long question, but will get a short answer: If you see "Predictive Failure" or "Failed", replace the disk. Both of those conditions are valid for the purpose of establishing a support ticket and/or warranty parts replacement from HP. "Predictive Failure" incorporates S.M.A.R.T. data as well as other heuristics to determine drive health. ...


1

Are you using HP hard drives? Or normal consumer drives? Do the drives have Time Limited Error Recovery? If not, the drive could lockup the controller while it tries to read a bad sector. It will take a long time for the drive to give up, so the read fails. The raid controller doesn't get a chance to try the other drive because it is stuck waiting for ...


1

Yes, if one drive in RAID is failed, RAID controller mark it as failed and will be read with other healthy hdd. Predictive failure means, that disk still work, but controlled notice you, that soon it will fails. If you receive read error, in your test, than you should replace your drive by another. Just buy spare drive in your local store/vendor support, ...


0

Given that it works when you disable reading the defaults (--no-defaults) then the problem is located somewhere in the default files, their permissions or the permissions of the directories containing them. Carefully examine the permissions on /etc, /etc/my.cnf, /etc/my.cnf.d, the files inside /etc/my.cnf.d as well as for good measure ~/.my.cnf. Check the ...


2

This is the reason it isn't starting: 150824 14:42:58 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied") 150824 14:42:58 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control' Double-check permissions on /var/lib/mysql. Also, check your system log ...


1

I had this kind of problem while configuring Apache Tomcat and solved it by using the under given link: http://www.windowstechupdates.com/error-1067-the-process-terminated-unexpectedly-apache-tomcat-6/ In my case the Java was not installed and registered in the system where I was trying to install and configure the tomcat. I hope it will helpsome


2

To configure percona-nrpe plugins for mysql you will have to do 3 things viz : 1. define commands 2. Define service 3. Add commands on client to nrpe.cfg First 2 can be easily done for help refer http://kedar.nitty-witty.com/blog/install-percona-monitoring-tools-for-nagios-mysql-plugins#comment-43181 I found less help available for 3rd point ie to add ...


2

You should be able to find out how often a specific PHP file is being called by looking through the web server logs. There are a couple of other hacks - for example Using Google Analytics (which will be less accurate), or updating a file / counter (more resource intensive). As @ma.tome said, monitoring your utilisation gives you a good place to start, and ...


1

Your hint as to what is going on is in the "Freeable Memory" chart. If your database was holding a lot of table-data and index-data in the process memory, that number would be a lot smaller than it is. As it stands, Freeable is almost as large as Total. Working as designed, nothing to see here. Please set PANIC = FALSE.


1

From : http://ushastry.blogspot.in/2011/02/mysql-bulk-import-and-logging-warnings.html /path/to/mysql --show-warnings –uUserName –pPassword DBNAME < /path/to/dump_file.sql >> /path/to/load_warnings.log 2>&1


0

Run the command show global status;, look for the Aborted_connections and Threads_created, if both values are high increase the thread_cache_size variable.


2

I haven't tried this, but my reading of the manual for LOAD DATA INFILE is that interpretation of "\N" sequences is controlled by the ESCAPED BY clause, and that the default is not to perform escape sequence processing. If this is right, adding "ESCAPED BY '\\'" to your query should have the results you desire.


1

I suspect that the data that is being imported is malformed. Specifically \N is missing \ in some or all cases. Verify the data is correct. You can do something like this: $ awk -F, '$3=="\\N"{print $0}' moo.csv 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N $ awk -F, '$3=="N"{print $0}' moo.csv 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,N Also, the ...


0

Not an answer to this specific problem, but this was the page I kept finding when I was trying to solve a similar problem. So hoping to help another lamp administrator.... In my case, my problem was PHP's get_browser() command. After I installed browscap.ini (standard version) my apache process's memory usage went from 10Mb to 170Mb. This ran fine until I ...


1

According to https://bugs.mysql.com/bug.php?id=74658 the issue presents itself when using openssh 6.7 the python libraries shipped with MySql workbench. While adding the "KexAlgorithms" to the sshd config works, you can update the python libraries that come with MySql Workbench. This may be handy if you don't have control over the sshd config... If you ...


3

You could run those commands before MySQL startup by editing the mysql startup scripts. But it would be better to make those settings persistent by editing your /etc/sysfs.conf. If you want to disable transparent hugepage you should add: kernel/mm/transparent_hugepage/enabled = never to your sysctl configuration. After you edited your sysctl ...


0

As long as you don't use GTID's this is possible.


0

Sure you can! The only thing you have to avare that your mysql servers has to 'see' eachother, and your network bandwidth should be enough for replicating all your changes. You should install percona-xtrabackup, take a backup from your current running mysql instance, copy all the files to the other hosting's mysql server's datadir, bring up instance, set up ...


1

The MySQL replication happens through binlog. To the binlog only successful transactions will be written, so if a query fails on a master it won't appear in binlog. That means this kind of queries will not appear on replicas. If you have errors like replication stops on slave1 because there is no column for update (etc.) then that means your master and ...


0

I had the same problem. I used strace to see what's going on. For me it was in ... /root/.my.cnf. mysql also tried to open ... /root/.mylogin.cnf ... so that's also a candidate.


0

RAID 1 just mirrors the drives which will only slow you down vs just 1 drive non raid. If you meant RAID 0 (Striping) then that would be your fastest option, but there would be no fault tolerance so if 1 drive goes the whole array is dead. RAID 5 will give the best of both worlds, it wouldn't be quite as fast, but with SSD's performance should not be an ...


1

Since you are using SSD's performance should already be excellent. However you should be aware of the write penalty RAID5 incurs, but since you have specified a read heavy load then a 3 disk RAID5 will be faster on reads than a 2 disk RAID 1. I believe softRaid allows for a 3 disk mirror and I have never used softRaid so I am unable to comment on whether or ...


1

The answer from Query to compare the structure of two tables in MySQL would be a good try. There a paste from it: TWO TABLES IN TWO DIFFERENT DATABASES If you want to know if db1.tb1 and db2.tb2 are different, run this SELECT IF(COUNT(1)>0,'Differences','No Differences') Comparison FROM ( SELECT column_name,ordinal_position, ...


0

According to the HAProxy manual, you can use the source keyword to force a backend or listen block to use a particular IP when connecting to servers. Your listen block would then look like: listen mysql-cluster bind 10.0.0.10:3306 mode tcp option mysql-check user haproxy_check balance roundrobin source 10.0.0.10 server db1 10.0.0.120:3307 check ...


1

Given that the output is programmatically generated, I assume that the syntax error is entirely regular. In that case, you can almost certainly solve the problem by replacing the string ,\n) with ), using a scripting solution of your choice (sed, perl, or whatever else butters your muffin).


1

For me, OSX's builtin php is configured to use a different unix-socket than homebrew's mysql. Thus it can't connect via localhost which utilizes that socket. I fixed it with a quick hack by symlinking php's configured socket-path to point to the one mysql actually uses. sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock The following diagnostic commands ...


-1

"web-searching revealed that mysql connects to 'localhost' via a unix socket" Because PHP is attempting some optimization that is causing unintended effects. Your instance of MySQL is listening for connections on tcp port 3306. PHP is trying to connect to a UNIX socket on the file system.


1

You have exhausted a resource related to a connection session(?) Take a look at your file descriptors/donnection handles in use and start working your way back from there. BE aggressive in your session timeout and recovery of resources or you can start stacking up sessions in use over multiple iterations of your virtual user, exhausting your stack and ...


2

Is ALTER TABLE `a` REORGANIZE PARTITION p0 INTO (PARTITION p0 DATA DIRECTORY='/media/p666/mysql_table_a'); what you're looking for? Docs suggest it should be safe to run on existing partitions, meaning it won't repartition the whole table. ALTER TABLE with ADD PARTITION, DROP PARTITION, COALESCE PARTITION, REBUILD PARTITION, or REORGANIZE ...


0

Solved! It was an error with the config. The correct path to MYSQL socket in Directadmin my.conf is: /tmp/mysql.sock Also bind-address is: 127.0.0.1 It's working now!!!


0

The file is not there, I didn't change the config, so it should be fine. I googled this topic before and tried to copy this file from the "english" directory, then it wasn't solving anything, just the error message was gone. Now I tried to add the directory to the config file and it started up, but the website still doesn't start and phpMyAdmin throws ...


0

I got it, I had to create a MySQL user to be able to connect mysql> use mysql; mysql> CREATE USER 'web'@'10.6.6.6' IDENTIFIED BY 'password'; mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO 'web'@'10.6.6.6'; mysql> FLUSH PRIVILEGES; then from the web jail: # ezjail-admin console www root@www:~ # vi ...


1

You can start here: https://github.com/banyek/Utilities/tree/master/monitor_space This will give you the actual table sizes, so you only have to know how big they are. If you know the free space you have you can add the missing functionality here :)


0

I had a similar problem trying to start the mariadb service ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' I figured the issue was in non-matching yum packages - some were installed from the special mariadb repo and others from the centos official repo. Thus I had to drop the custom yum repo entry, ...


0

Yep, you're doomed to creating a MariaDB user for each user you wish to connect to the server, with a REQUIRE SUBJECT '/CN=foo/emailAddress=foo@example.com/'. It's a hideous, error-prone syntax. MySQL's user management is fairly pants in a great many ways.


0

I'm going to guess at 2 issues: Your system is set to limit your mysqld user daemon process to the default 1024 open files. Set this to a much larger value and then restart mysqld: echo "mysql soft nofile 65536" >> /etc/security/limits.conf echo "mysql hard nofile 102400" >> /etc/security/limits.conf Your innodb_buffer_pool_size is too large ...


1

If the xydb could have a different mysql password on the production and test DB servers, then you can give the mysql user a "wrong" password on the live server mysql> SELECT VERSION(); +-------------------------+ | VERSION() | +-------------------------+ | 5.1.73-0ubuntu0.10.04.1 | +-------------------------+ To recreate your situation: ...


0

One instance on a high spec machine, fast disk array (SSD's maybe, LACP network) and create separate DB's and login's for each application. This is a typical deployment for most database systems, especially SQL. You must consider availability however when centralising your database server. Therefore in most production environments you will see an SQL ...


0

You always have to consider when you put multiple databases in one instance of MySQL, they can also corrupt each other if they share the same user. Additionally you can only use one mysqld version. Maybe one of your databases need a different version.


1

I'm not sure if you can do it using REVOKE, but you can definitely do it by inserting an entry into the relevant table in the mysql schema: INSERT INTO mysql.db (Host,Db) VALUES ('192.0.2.42','xydb'); INSERT INTO mysql.db (Host,Db) VALUES ('host.example.com','xydb'); FLUSH PRIVILEGES; The first two lines do the heavy lifting of inserting into the DB; it's ...



Top 50 recent answers are included