i'm not sure if this is because i'm having problems with my Raid setup, which mysql is running on, or if it is unrelated, but is anyone else noticing that mysql is VERY slow on Fedora 15?
View 5 RepliesI have installed BIND 9.6.1-P3-RedHat-9.6.1-16.P3.fc12 on Fedora Core 12.
I found out that when i perform i DNS lookup to a some record that is not in the DNS cache or zones(means...recursive) it takes about 4 sec to give the IP results.
I dig a little bit on the internet and found out that it is a known issue but all places says that it is fixed on newer version of BIND (after version 9.3)
I tried:
1. start BIND with -4 argument ( named -4) - the server started but no changes on the delay.
2. disable IPV6 on the server - i tried the articles on the web but still i get IPV6 address.
At work, we use two very powerful servers to host a series of VMs to do some heavy-lifting analytical work. Part of my job has been to evaluate a variety of different virtualization environments, including changing the host OS (or dom0 kernel for Xen), changing the platform (KVM, Xen, ESXI, etc.), and changing the guest OS types.
I noticed a number of behaviors that Ubuntu exhibited that set it apart (almost always in a positive way) from the other OSes. Most astounding though was that when an Ubuntu 10.04 AMD64 server VM was booted from an Ubuntu 10.04 AMD64 server host (that is, same version of Host OS and Guest OS) in KVM, the guest boots in roughly 2 seconds. At least, the guest boots faster than the VNC connection can initialize.
I'm certainly not complaining, but I can't for the life of me figure out how this could be possible. I understand that the Upstart init daemon is very good about startup times.
I've got Ubuntu Server 10.04 on a fairly beefy box (quad-core xeon 2.67ghz, 2gb ram) Standard mysql-server installed, with many databases.Lately, mysql has been extremely slow and almost non-responsive. Server loads are low.Running mtop reveals many, many processes from the user: debian-sys-maint querying the information_schema table with the exact same query, over and over."Select count(*) from tables where engine = 'innodb'"
This is adversely affecting my database server, and thus my websites which rely on mysql. Every search I've done looking for more information about the debian-sys-maint user shows problems where that users was deleted. The user isn't deleted.
I have a daily routine task of checking the size of mysql tables in a database in Mysql Database Server.
I want to achieve this task through a bash script that runs daily and calculate the size of mysql tables and finally mail it to DBA email-id fore.g adarsh.sharma@orkash.com
I try a simple script to mail but it fails .
#!/bin/bash
SUBJECT="Automated Security Alert"
TO="adarsh.sharma@orkash.com"
MESSAGE="/tmp/message.txt"
echo "Security breached!" >> $MESSAGE
echo "Time: `date`" >> $MESSAGE
/bin/mail -s "$SUBJECT" "$TO"
It hangs when I run bash a.sh command. However it creates file in /tmp folder and have all contents.
I have prepared a simple script that shows the database, tables size in the Database server as :-
check the attachment for the script & output.
Now I just want to mail the output of my script to some persons e-mail-ID
Also, I want to do some calculations and provide the information of how much increase data after 1 day daily.
I would like some help to run sql queries in Ubuntu. For a school IT project, we must write a Java program that runs queries. Seeing that I'm going away on holiday and will be away from my Win7 desktop, I will have to work on my Ubuntu laptop. When I run my program, I get these two sql exceptions:
Code:
sun.jdbc.odbc.JdbcOdbcDriver
No suitable driver found for jdbc:odbc:ITPAT2010
Note: it is not my program that is causing the problem, since it works fine on Win7. But here's my code anyway:
Code:
void OpenDB()
{
System.out.println("INTO BRIDGE");
String url = "jdbc:odbc:ITPAT2010"; //JOU BRUG SE NAAM
[code]....
I believe the drivers that handles the connection to the database aren't installed. The format of my database is: *.accdb (was created on Win7 using Office 2010). I can't open this file, probably because I have no database programs installed?
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
Currently I have a huge issue with Mysql on a basic Fedora 12 installation (no update strait from dvd). Only a console.
Mono JIT compiler version 2.4.3.1 (tarball Thu Jan 14 10:27:43 UTC 2010) Mysql Server version: 5.1.44 Source distribution
When I what to connect with the mysql database using the 6.2.2 Mysql.Data.dll using the socket (/var/lib/mysql/myqsl.sock) I get the error:
If I connect with localhost it is very slow: Query time(0 logitem(s)): 0.805234 seconds
When I connect to that shame version using the same application from a window machine over a network the result are: Query time(0 logitem(s)): 0.23646 seconds
However I just built a 10.10 server, installed webmin, vmware, and the server is working perfectly. I configured my bind 9 server using the latest webmin and on the server everything resolves perfectly to both the internet and lan. I have it set to 127.0.0.1, the server ip address is 10.1.50.25. However, it will not accept dns client queries in which they cannot resolve to the lan or internet. I have the dhcp giving out the dns server 10.1.50.25. NSLOOKUPS from the client show query refused. I know there has to be some setting or config that will allow clients to query but I am not able to locate it, and I am not totally knowledgeable of named.conf and been all through the webmin module and configuration settings.
View 6 Replies View RelatedI've successfully installed mysql using yum on the latest fedora; and started it like so:
What do I do from here!
I used the command: whereis mysql
I found out it was in /usr/bin/mysql /usr/lib/mysql /usr/share/mysql ../man/man1/.gz
I attempted to execute it from root.. bin and I get the following error message:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock'
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
I'm running 12 (x64) on my dell inspiron 1525. It's been fine for 6months. Just updated it and now it is running incredible slow, I can't really use it, typing is delayed, opening prgrammes delayed, scrolling etc. The updates were just those that were flagged up on my desktop so I have no idea which particular update has caused this.
View 6 Replies View RelatedI have recently replaced an older server with a new Intel Xeon quad-core processor. The old machine was running FC6, the new machine is running FC11 64Bit. The problem that I am having is that printing to networked printers prints 2-3 pages, then waits 8-10 seconds and then prints 2-3 more pages. This repeats until the printout is completed. My first thought is that FC11 (or somewhere between FC6 and FC11) introduced some way to limit activity to devices? The confusing thing to me is that I went from a single CPU to a quad core machine, increased the memory from 1Gb to 3Gb, moved from a 32 bit machine to a 64 bit machine and I am running the same applications... they just run slower now...
View 10 Replies View RelatedFirst off, I want to say that I'm loving Fedora 13. The problem is, I have run Windows 7, Vista, OS X and Ubuntu on this custom set-up. They've all run very fast, without a hiccup, but for some reason Fedora 13 seems to be running very slow. Symptoms include, but are not limited to apps like 'System>Administration>Services' make my CPU run at 100%Is there anything I can do to troubleshoot why it's running slowly?I'm running 8GBs RAM, an E6600 Intel Processor, on a Gigabyte ga-ep45-ud3p, rev1.1
View 2 Replies View Relatedeverything in the computer is running snail slow. So slow, that it wouldn't install Fedora 12.
View 9 Replies View RelatedI am having a problem with my Fedora11, I am not sure wether it is software or hardware but this looks serious. My computer is running very slow and freezes up every few seconds. Every time I reboot I would get a kernel failure pop-up.
This is what the message says:
Kernel failure message 1:
Kernel failure message 2:
Call Trace:
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
I've setup a fedora core 13 server and I am running mysql on it. I wanted to use MySQL Workbench on my Windows 7 computer on the same LAN to connect to the database. Currently I am unable to connect to the database except if I go through ssh. What ports do I need to open on my firewall? Is there any specific configuration that I need to do to my MySQL database to get it working?
View 3 Replies View Relatedlong time user of redhat, first time user of fedora...
Installed fedora 10 to the hard drive (building a new web server, switched from RHEL5)
Started to install everything I need, apache, php, mysql, odbc, iseries access for linux, etc...
Got to the php modules, installed php-odbc, php-mysql, etc... but php doesn't see the mysql module
doing a phpinfo() produces -without-mysql
uninstalled it, reinstalled it (this is all done through kpackagekit so far) - no good
uninstalled and tried to reinstall via yum, no good
all the config files are fine - copied my php.ini from the old server and let the installs create the new mysql ini files
how to get it in ? this is my last step before i can begin pen and vulnerability testing it.
Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:
1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)
[Code]...
I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.
View 1 Replies View RelatedHaving major problems with mysqld causing CPU usage to rocket to 100% on one core for a short time, which usually drops back down again to 1-7%, though sometimes it can last an extended period of time. This is a problem because things using mysql become unresponsive in this time.
[Code]...
I have a server (fedora 11 , LAMP). I want to know if I can upload something to my server via http (I mean from WAN),and this data stream can directly run into MySQL database . Do I need to write some special codes on my web page , or just change apache's configure file
View 7 Replies View RelatedI installed Fedora 12 with package standard of the MYSQL, configured this the same twirling in such a way localhost as in one it schemes with windows VISTA, to put I have others 4 you scheme with windows XP that I do not obtain to have access in the MYSQL. What I have to make pra these you scheme with XP to have access?
View 2 Replies View RelatedLet me show you the Details:
[code]...
So that means the User Test can connect from any host without password and with the named privileges, but he has no right to grant any privileges. CONSOLE:
[code]...
This is my first post. After executing /usr/bin/mysqladmin -u root password 'thepass' as a root, I get this:
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
SELinux is off.
After securing webmin on my web server, with a custom SSL connection.I wanted to do the same with phpMyAdmin. But I am unsure of where to look for the best tutorial(s) to do this, can anyone help?Plus I saw once at work our network tech adding in accounts but then allocating that to the login itself.For example, when your brought up with a .htaccess prompt in the browser, thats assigned to you login within phpMyAdmin, taken from the db server no doubt, is it possible to do this?Should there be anything else I need to know in securing mysql?I have limited all services to a set number of IPs so non of its publically functional at the moment so I can take as long as possible, but naturally I'd like to be able to be as speedy as possible about getting this sorted.
View 7 Replies View Relatedis this command exact or do I replace anything with my own setu
" yum install mysql mysql-devel mysql-server "
who can't tell what has to be changed for "My server name" and "my setup"