similar to: Tuning MySQL - what's the best place for mysqld parameters?

Hi,all I did some test about MySQL''s Insert performance on ZFS, and met a big performance problem,*i''m not sure what''s the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1 ~600 qps when sync_binlog=10

Hello, I've only had experience with PostgreSQL sofar, but have now to install MySQL (and WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin -u root password 'xxxxx' # /usr/bin/mysql_secure_installation Then I've noticed that

As a follow up from my previous post, I am pondering some changes to my env. I read that with AR I should change the verification timeout to be lower than the MySQL db Interactive_timeout. Now, I have done some performancing tuning to mysql in LAMP env''s but not RoR. MySQL typical set the default interactive_timeout to 8hrs (28800) this has bitten me a few times with sleeping processess

Dear R Developers, In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the innodb_buffer_pool_size or the key_buffer_size for setting the maximum amount of RAM which can be used by a Server Instance: ?Would it be possible to create an R Configuration Variable which fixes the maximum amount of RAM memory to be used as Commit / Dynamic Memory Allocation? Thank you. Juan

Hi, I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least 5-10 sec to connect to the database. I optimized all possible parameters in my.cnf: max_connection=1000 wait_timeout=60 query_cache_type=1 query_cache_limit=4M query_cache_size=512M interactive_timeout=120

I am working in a Dockerfile but there is a "secure" MariaDB server script I need to run which is interactive and I don't know how to deal with this. Basically this is the flow I have follow on the script at test environment and is the same I want to achieve in the Dockerfile without user interaction by just answering as you seen on the flow below: #

Hi! I just tried setting up Asterisk realtime database following the wiki article https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime on a Debian 9 machine (which switched from MyQSL to MariaDB). One has to install mariadb-plugin-connect, python-mysqldb and alembic packages (alembic does not work when installed via pip). Additionally - since MariaDB by default does not have a

Please open a Ticket (https://issues.asterisk.org), to let them know that they need to update the documentation in Wiki and also handle this situation when using Alembic in Debian 9 (could happens in other Distros too). Marcelo H. Terres <mhterres at gmail.com> IM: mhterres at jabber.mundoopensource.com.br https://www.mundoopensource.com.br https://twitter.com/mhterres

Hello, I discovered today that CentOS 7 has replaced MySQL with MariaDB. Which is fine, it's seems really similar. And I was already aware that it was written by the original team that wrote mysql. It's cool that the mysql command still gets you in! This is the version I have: [root at web1:~] #mysql --version mysql Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline

On Sun, Sep 17, 2017 at 12:39 AM, Juan Telleria <jtelleriar at gmail.com> wrote: > Dear R Developers, > > In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the > innodb_buffer_pool_size or the key_buffer_size for setting the maximum > amount of RAM which can be used by a Server Instance. Memory is not controlled by R itself because packages may

Dear All, I'm trying to connect to Asterisk CDR database using PHPMyAdmin but unfortunately all my trials and searches failed. So I'd be more than grateful if someone helped me with right steps to do this. Kindly note that I'm working on a remore server that I can connect to as a root using *ssh.* Asterisk Version: 11.3.0 MySQL Version: mysql-server.x86_64 0:5.1.69-1.el6_4

Send CentOS-announce mailing list submissions to centos-announce at centos.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.centos.org/mailman/listinfo/centos-announce or, via email, send a message with subject or body 'help' to centos-announce-request at centos.org You can reach the person managing the list at centos-announce-owner at centos.org When

Every now and then, mysqld (5.0.22) jumps to 95%+ cpu usage and stays there. Seems to be a common issue, as far as google can tell, but details are alarmingly vague, and some people seem to suggest that it''s a bad query causing it. How do I go about determining if it''s something my application is doing? martin

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I''ve seen a few posts about this over the past week or so, and I''m having a similar problem with apache / mysql / php. Mysqld seems to just die every few days. Has anyone got any ideas about fixes or workarounds? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird -

i keep getting this from my logs Version: '4.1.10a' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution my sql server works but im just worried about that message i don't know if its an error or something.

CentOS 4 - updated to current, rebooted to new kernel and now I can't get mysqld to start... # service mysqld start Timeout error occurred trying to start MySQL Daemon #tail -n 4 /var/log/messages Nov 12 00:48:56 srv1 kernel: audit(1131781736.221:4): avc: denied { write } for pid=4874 comm="mysqld" name="tmp" dev=dm-0 ino=2894305 scontext=root:system_r:mysqld_t

CentOS 4.2 [root at srv1 certs]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root at srv1 certs]# rm -fr /var/lib/mysql/* [root at srv1 certs]# service mysqld start Initializing MySQL database: [ OK ] Timeout error occurred trying to start MySQL Daemon. Starting

Hi; I installed mysql using yum, so I have an /etc/init.d/mysqld file. For some reason, however, mysqld doesn't boot on reboot of the machine. Please advise. TIA, Victor -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20091110/3a8a8747/attachment-0003.html>

Bug, explainable, or expected?? Checking the status of mysqld as root, then as a regular user: # /etc/init.d/mysqld status mysqld (pid 4806) is running... $ /etc/init.d/mysqld status mysqld dead but subsys locked

If you adjust the my.cnf file to make separate instances of mysql..... How would you go through the mysql secure installation? Is is possible or must it all be done manually for each one? is it possible to make each one of those instances a replicate/slave of a different master (thus a backup mysql server in a way?) working on this now, but having issues getting it to work. (centos 6)