Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5]

137 questions
0
votes
1 answer

Optimize server for faster processing of requests

Possible Duplicate: LAMP Server Performance Tips I am running a web directory using WordPress which has a lot of categories, and I mean a lot. Around 26,000 to be precise. And it takes WordPress forever to finish processing certain requests. The…
Naif Amoodi
  • 1
0
votes
1 answer

What is the use of ibdata1 file in mysql

I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions. Solution 1: innodb_file_per_table Solution…
loganathan
  • 240
  • 2
  • 13
0
votes
3 answers

Pid file for mysql on Oneiric

I cannot locate pid file for mysql server on oneiric. Opened /etc/mysql/my.cnf and /etc/mysql/debian.cnf but see no settings about pid file. I need this pid file to have monit monitor mysql. Any clue?
Phuong Nguyen
  • 703
  • 1
  • 12
  • 27
0
votes
1 answer

Relocating MySQL data files

I would like to move everything that is related to my current MySQL database(s) into a subdirectory of /home/mysql. I don't need to move log files or my.cnf, only data. I don't know where the actual database files are stored and how to tell MySQL to…
usr-local-ΕΨΗΕΛΩΝ
  • 2,359
  • 7
  • 34
  • 52
0
votes
1 answer

MySql not starting during startup even after adding symlink to rc5.d

I recently added mysql.server to start during the start up by doing this: cd /etc/rc.d/rc5.d/ ln -s /etc/init.d/mysql.server S98mysql I have perhaps not correctly understood the part of sscript / kscript naming convention…
ThinkingMonkey
  • 476
  • 1
  • 9
  • 18
0
votes
1 answer

Detect mysql password changes from logs

How can I find out who last changed the MySQL database password for the "root" user. I'm using Ubuntu.
Rossi
  • 21
  • 1
0
votes
2 answers

Conflict with Yum install php and mysql

I'm trying to install a php extension. --> Running transaction check ---> Package mysql.x86_64 0:5.5.18-1.el5.art set to be updated ---> Package mysql-devel.x86_64 0:5.5.18-1.el5.art set to be updated ---> Package mysql-server.x86_64…
Poe
  • 321
  • 1
  • 5
  • 18
0
votes
1 answer

Determine the right my.cnf file to tune

In a Centos VPS i want to tune Mysql Server: find -name…
Michele
  • 169
  • 10
0
votes
1 answer

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same database on the centralised server, essentially…
Richard Keller
  • 2,040
  • 2
  • 19
  • 31
0
votes
2 answers

Can I choose which CPUs / Cores to be used by MySQL?

I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example). With ASP.NET, in such situation, I usually set the app pool to use one CPU / Core, and SQL Server to use…
Meligy
  • 123
  • 1
  • 1
  • 7
0
votes
2 answers

Memory requirements for PHP + MySQL on Windows platform

I have cloud server at RackSpace that has 2GB of memory. OS is Windows Server 2008 R2 x64. As of now server is pretty fast. I plan to configure IIS and install SQL Server Express 2008 R2 x64, so memory is somewhat at a premium. There will be no…
Joe Schmoe
  • 315
  • 7
  • 15
0
votes
1 answer

mysql performance optimization after enabling replication

Over the weekend I upgrade my Ubuntu server from 9.10 to 10.04 which also updated my MySQL server. I also enabled MySQL replication over to another server as slave. I have not yet moved any application logic to use slave but I started seeing some…
Sparsh Gupta
  • 1,127
  • 7
  • 21
  • 31
0
votes
1 answer

How to prevent InnoDB log files from getting corrupted?

We run a MySQL server using 600GB of storage over 4 EBS volumes on Amazon EC2. About every 2-3 weeks, the active InnoDB log file gets corrupted, and MySQL won't allow any access on those tables (saying that the InnoDB engine is disabled) until we…
joemastersemison
  • 33
  • 6
0
votes
2 answers

MySQL Privileges required to GRANT EVENT, EXECUTE, LOCK TABLES, and TRIGGER

I have an account, user_a, and I would like to grant all available permissions on some_db to user_b. I have tried the following query: GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE,…
Brad
  • 1,419
  • 22
  • 43
0
votes
3 answers

MySQL starting up fine, but can't connect to it

MySQL version mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1 Restarted the machine. Then tried... $ ps aux | grep mysql mysql 3298 0.0 0.8 136772 17216 ? Rl 12:13 0:00 /usr/libexec/mysqld…
Agvorth
  • 2,459
  • 4
  • 29
  • 29
1 2 3
…
9 10