MYSQL :: Slow Performance After Falling Back To MySQL 3

Slow Performance
On my index.php page, I have a simple query that checks the session_id against a table where I store other session_id'. If it's not there, it records it (unique hit). If it's there, it doesn't record it (not a unique hit.) This usually goes off without a hitch, and every month or so I empty the table.

Right now I only have about 2500 rows, and it's taking forever to load the page. Is there something possibly server related that could be causing this? My host charges an arm and a leg just to see if there's something wrong if I bring up an issue, so I'd like some insight as to whether there's a commonly known server-side issue that can bog down performance.

View Replies !

Server Performance Slow
I have designed a service on my site which requires about 30 -40 SQL queries per page to run. Everything works without problems apart from the slowness. The page will load very quickly until it gets to the first query, then it pauses..... and carries on slowly producing the results. (When I say slowly, I mean relative slow compared to the speed this forum loads for instance)All the other web apps with mySQL work without slowing down, but they don't take up as much resources. Even the VB board is very fast.
I'm running a 2.8Ghz 1GB Win2003 server, so I doubt that is a problem.
Is there a guide to optimizing mySQL server or a key "setting" I should be changing?

View Replies !

Slow Performance While Mysqldump
i have a large database with many tables. I was using it fine on HP Proliant server (4gb ram). Now i did the same database to a mirror HP Proliant (2Gb ram).

After recovery the database, query is very very slower then Machine 1, does it damage the index while dumping? How do you recover indexes if some way it damage and cause the slow performance?

Machine 1:
>mysqldump --user=root --password=root -R --ignore-table=database.table0 --ignore-table=database.able1 database > pathsql.sql

Machine 2:
>mysql --user=root --password=root database < pathsql.sql

View Replies !

Memory Maxed Out And Slow Performance
We have two main query types running against a table of some 2 million
rows and have gotten query response down to well under a second by
using the right indexes.

Problem is that we are running an advertising campaign that brings a
concentrated block of users to the site. When this happens one of the
queries which relies on a particluar index comes severely of the rails
and can take up to 2 minutes filling the slow query log for 15 to 20
minutes. The other query type never appears in the slow log at these
times.

Can anyone explain why this is happening?

The server has 2Gb of ram and a key_buffer of 1Gb. When the problems
occur mysql uses all of the key_buffer but the total value of the MYI
files is under 250Mb. What is in memory - thread related buffers?

It seems as though the index required for the query is not in memory
and the disks are coming into play. Why is only one index affected?

I would really appreciate some pointers, what can I check to pinpoint
the problem and what settings should I implement to preserve
performance?

Front end is 4 cold fusion web servers using persistent connections.
max_connections is currently at 100.

View Replies !

ORDER BY Calculated_value Performance Is Slow
I have a query that is generating search results against a number of fields, with each of these fields having a relative importance.

I am currently using a fulltext index on each of these, and constructing the query thus:....

View Replies !

Slow Performance :: Navicat To Import Tables From An ODBC Connection
have been using Navicat to import tables from an ODBC connection I have. The import goes extremely fast but once the data is locally stored and I try to manipulate it by joining tables, the program goes slower and sometimes even crashes it.

If the same data is however imported into a table in MS Access, and a query is created it runs fine. I would like to know if there is a way to improve the performance of my MySQL database as the reason I was using it is because of its scalability. I was wondering if there was something I was doing wrong or could do better.

The Server the data is downloaded to right now is has the following specs:

Windows XP Pro
Intel Core 2 CPU 2.13 Ghz
2 GB RAM

View Replies !

Large Table Performance Problem With MYSQL Performance
I am doing some benchmarking of an application using MYSQL under Windows and I confused about the results.

Environment
Emachine 6417 with amd3200+ 64 bit processor 3.3GB ram

mysql 4.1 with odbc 3.51 MYISAM
windows 2003 server std edition
date, account and invoice number are indexed
Database size 18 million rows

I am querying (selecting) columns of a date and an account

our tester program that opens a socket to the Mysql database and does a select for the above n times
each time the date and the account is randomized to minimize hits on records closeby.
This program will perform over 1000 queries per second.
At the end, the Mysql socket will be closed
Even when the socket is closed each time, I still get 400 queries per second.

When I enter a similar query manually a web interface, I get about 3-9 second response time. This program opens/closes a socket for each query when using EMS I get similar 9 second results.

Does anyone have any suggestions Also in production, this table will be accesse for both read and write will I have problems. My testing showed that Innodb is much slower.

View Replies !

Simple Query? Why Is My Hair Falling Out?
Im trying to pull all records from table a and table b for 14 hrs now. It seems so simple?
both tables are indexed with the fields 'classid' and 'states'
actual results should be 36 records as you can see that is not the case.
Here is what ive tried so far:

SELECT * FROM classifieds_g WHERE states='AZ'

records 4

SELECT * FROM classifieds WHERE states='AZ'

records 32

Samples and results of what I've tried (should return 36 records)

SELECT * FROM classifieds_g, classifieds WHERE classifieds.states='AZ' and classifieds.states = classifieds_g.states

records 0

SELECT classifieds.states, classifieds_g.states FROM classifieds_g, classifieds WHERE classifieds.states='AZ' and classifieds.states = classifieds_g.states

records 0

SELECT * FROM classifieds_g, classifieds WHERE classifieds.states='AZ' GROUP BY classifieds.states

records 1

SELECT * FROM classifieds_g, classifieds WHERE classifieds.states='AZ'

records 4000

SELECT DISTINCT * FROM classifieds_g, classifieds WHERE classifieds.states='AZ' and classifieds_g.states='AZ'

records 128

SELECT * FROM classifieds_g, classifieds WHERE classifieds_g.states='AZ' and classifieds.states = classifieds_g.states

records 0

SELECT * FROM classifieds_g LEFT JOIN classifieds ON classifieds.states = classifieds_g.states WHERE classifieds_g.states='AZ'

records 128

SELECT * FROM classifieds_g INNER JOIN classifieds ON classifieds.states = classifieds_g.states WHERE classifieds_g.states='AZ'

records 128

SELECT * FROM classifieds_g LEFT JOIN classifieds ON classifieds.states = classifieds_g.states WHERE classifieds_g.states='AZ' GROUP BY classifieds.states

records 1

SELECT * FROM classifieds_g LEFT JOIN classifieds ON classifieds.states = classifieds_g.states WHERE classifieds_g.states='AZ' GROUP BY classifieds.classid

records 32 (all the same)

SELECT DISTINCT * FROM classifieds_g WHERE states IN(SELECT states FROM classifieds WHERE states='AZ' )GROUP BY states

records 1

SELECT DISTINCT * FROM classifieds_g WHERE states IN(SELECT states FROM classifieds WHERE states='AZ' )

records 4

View Replies !

Mysql Back-up
We have an online catalogue running off a mysql database, which we can back
up. When we back it up, it creates a file online called "database.sql"
which, when opened in Notepad starts...
DROP TABLE IF EXISTS store_category;
CREATE TABLE store_category (
category text NOT NULL,....etc

View Replies !

MySQL Back End
I have an Access application which uses an Access database.
I want to replace the Access back end with a MySQL one.
Can I link the new database?
Can I do it in any other way?
I reckon I should be able to, since MySQL has an ODBC driver but just not sure how

View Replies !

Getting MySQL Back
I am getting relay-bin logs on my master server. They are all empty except
for one line that reads:

þbin

I have no slave settings in my my.cnf file. Any idea where these are coming
from and how to turn them off?

View Replies !

Mysql, Get Back Your Youth

<div align="center">
 
<a
href="http://www.herbal-medical.biz/projectx/hgh.html"><img
src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0">
</a> 
 
 
 
<A HREF="http://www.herbal-medical.biz/projectx/hgh.html">Click Here If Image Doesnt Load</A>
 
 
</div>
<CENTER>WdXfuRttYR, yJJZQwQUqY
 
 
<A HREF="http://www.herbal-medical.biz/optout.html">No More Emails Please</A> </CENTER>


View Replies !

Back Up MySQL In A PHP File
I need a script that will find all tables and all rows and all data it makes a file called back.sql with all the info in it. How do you do that. My Web host dont got PHpmyadmin or nothing.

View Replies !

Auto Back Up Of MySQL
I want to Automaticly dackup my MySQL DB, and then upload it to a FTP site so I have a off site back up.

Anyone know of any programs (open source is preffered) that would allow me to do this. I was think batch file my self in scedualed tasks but I am no too sure of what commands to use. This is on a windows 200 server too.

View Replies !

Back Up MySQL Database
Plese tell me how do i back up a perticuler mysql database? can i do it from mysql command line? can i manually copy and past? if what folder?

View Replies !

Upgrade Mysql :: Get Back Old Data
I uninstalled older version of mysql 4.025 or some ancient thing. Now I didn't back up the database, but thought i could move the data folder over. Is there any way to get back into the old data? its the password access.

View Replies !

MySQL Takes FOREVER To Start Back Up
Need some help here. I am running MySQL 4.1 on a windows 2003 server. We've had the server for about a year and right now the data file for the database is up to 345mb. Its growing week by week.

Lately if I had to restart my server once windows comes back up it takes 20min for MySQL to start back up.

View Replies !

Optimizing MS Access Front End -> MyODBC <- MySQL Back End
I am using an MS Access front end -> MyODBC <- MySQL back end database configuration where the data is replaced every month. After emptying the old data, I would like to optimize the MySQL tables using VBA code, prior to importing the new data. Would anyone know how to implement this in VBA code, using ADO and ODBC

View Replies !

Easiest Way To Back Up MYSQL Database To Move Over To Another Computer
I've been working through Sitepoint's Build Your Own Database Driven Website and I've decided to change which of my computer's I use as my test server. I installed Apache, PHP and MySql on the new "server" and tried to copy over my database folder, but I can't seem to get it to work in the MySql client. I looked through the documentation for information about maybe making a backup and then restoring it to the new server, but I was a little overwhelmed. Anyone have an easy suggestion to accomplish this. I'm sure it's much easier than I'm making it.

View Replies !

Performance MySQL With ADO VB
I'm developing an VB application which uses the SAX parser and ADO VB to
insert.update data in in MySQL. The perormance is very bad. If I use the
same data and insert/update to a MS Access database it takes 14 minutes. But
using MySQL it takes about 5 hours! Here's the piece of code which takes the
most time. Does anyone have an explanation for this? Code:

View Replies !

MySQL Performance
We ran MySQL (4.0.15-standard, 64-bit, SuSe 8.0) benchmarks
on 2 CPU and 4 CPU Opteron machines. Mostly we tested insertion
times with many simultaneous connections (hundreds). To our
surprise we did not find significant differences.Each of our servers (2 and 4 CPU machine) has one 1Gbit network
connection. I have feelings that the machines are the network
bounded, not the CPU bounded. Could it be true? How to verify it?

View Replies !

Problem With MYSQL Performance With ASP.NET
Large table performance problem with MYSQL performance with ASP.NET

I am doing some benchmarking of an application using MYSQL under
Windows and I confused about the results.

Environment
Emachine 6417 with amd3200+ 64 bit processor 3.3GB ram

mysql 4.1 with odbc 3.51 MYISAM
windows 2003 server std edition
date, account and invoice number are indexed
Database size 18 million rows

I am querying (selecting) columns of a date and an account

our tester program that opens a socket to the Mysql database and does a
select for the above n times
each time the date and the account is randomized to minimize hits on
records closeby.
This program will perform over 1000 queries per second.
At the end, the Mysql socket will be closed

When I enter a similar query manually a web interface, I get about 3
second response time.
This program opens/closes a socket for each query

Does anyone have any suggestions

Your assistance would be greatly appreciated

Also in production, this table will be accesse for both read and write
will I have problems. My testing showed that Innodb is much slower.

View Replies !

MySQL Performance Question..
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst,
with a wd 512MB HD and I want to store George Bush in our MySQL database.
As far as table definitions are concerned, should I use a BLOB or should I
store him on disk and make a reference to the physical location in the MySQL
table instead?
Will I run into any performance/storage issues when querying this data?

View Replies !

MySQL Tables Performance
I have a table where misc data are stored. Right now this table has
about 30 columns, but for sure it will be more in the near future. So I
wonder how the big number (50-100) of table's columns affect for MySQL
DB performance. Maybe it's better to create more tables rather than more
table's columns ??

View Replies !

Optimizing MySQL For Performance
I am going to be running mySQL on a RAID5 array and am wondering if I need to worry about splitting up the data and log files on to seperate channels on the RAID array.

I have heard differing arguments. Some people say that you can install SQL on the same logial drive as long as you are running RAID5 and not worry about performance issues.

Others say that you need to split everything up even if you are running RAID5.

Do I need to split it up in to 2 channels and 2 logical drives or is one drive OK?

View Replies !

Analysis MySQL Performance
What is the best way to analayse the performance of an operational MySQL server?
Are there any good stats programs out there that show more than the variabels listed by MySQL (And phpMyAdmin)?
Are there any good tutorials about what figures to be alert for, and what should be ignored?In particular I'm facing a number of connections issue and need to isolate what is causing so many connections, and why so many stay in sleep mode.Database amostly use PEAR to connect to MySQL, are there any common pitfalls with PEAR and numerours connections?

View Replies !

MySQL Performance Monitor
Wanting to do some performance testing of MySQL on my Windows 2003 Server, and was wondering if there was anyway to setup some basic MySQL performance counters to monitor and log in perfmon? Things like queries per second, connections, traffic, etc? Doesn't have to be a permon counter, just something that can log usage values to a CSV at one second intervals

View Replies !

MySQL Performance Maintenance
can anyone please tell me how I keep the performance of the data within my MySQL database optimized? Ie, will the data over time become defragmented and therefore need to be optimized via (for example) an unload process, then a sort then a reload?
Most of my selects will need to order the data in alphabetical order (I am storing business names and addresses and returning the data in business name order) and I was wonderring if I needed to perform some process to reorder and reload the data periodically to maintain performance. I am expecting approximately 8000 rows of data.

View Replies !

Ajax Performance With Mysql?
I'm trying to tweak the performance of a php script, but I don't understand how mysql handles connections, so I'm not sure if I should use standard sql statments, prepared statements or stored procedures.

The php script is called by an ajax file, which will be executed very often. Right now each time the script is called I create a new connection (username, password, etc...) and at the end of the script I specifically close it (mysqli_close($con)).

View Replies !

Profile Performance On MySQL
I'm looking for recommendations on an app/function of mysql that will show a profile of the performance of my interaction with MySQL.

I'm a newb to php/MySQL, but not to programming/db. I'm about to launch a site and I'd like to look at a profile of the queries I'm running and if they are using indexes properly/doing full table scans, and other performance related items.

I've read up on the explain and benchmark functions, but they seem to require that the query is passed through them.

I'd prefer something more global like MS SQL's profiler that captures all of the actions, time expended and execution plan. Then I can look through it and see if any of the actions are taking longer than x time and then investigate further.

Does anything like this exist?

FYI, I'm on a shared hosted db server.

View Replies !

Slow MySQL
mySQL has been running very slowly and I am getting errors. First I did 2 things I raised the ServerLimit number (apache) to allow for more connections, I also raised the max conncetions in my.cnf. I do not know if this took effect? That should have worked. But basically in phpmyadmin i get this error frequently. I am getting more traffic so I think it is that.

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

View Replies !

Why Does MySQL So Slow
I just changed to use MySQL few days ago but it was a bad idea. My server now is running very slowly with the database. I'm using Perl5 and DBD::Mysql in my script. The system is Linux9, Apache2.

I looked at these mysql pid and saw a lot of activities (about 400) while there are more 100 users online at this moment and lots of running under a the same pid number.

View Replies !

MySQL Slow
I had downloaded a few years back mySQL v3.51 installed but never used it. Now I wanted to convert some B-TREE databases to mySQL and did some testing via ODBC to insert 70,000 records: My results:

MS ACCESS: ~60,000 msecs
MYSQL v3.51 ~18,000 msecs

Impressed with the speed, I went ahead and got the latest MySQL v5.1. Uninstalled the older version, I had nothing there to preserve, so I did a simple new install with MySQL v5.1. I noticed the size of the files and BINEXE increasted by 1,000,000%. Ok, Bulky. Not a problem.

I reran the same ODBC test, and now I got:

MYSQL v5.1: ~450,000 msecs or 7.5 freaking MINUTES!

What the hell happen? Nothing was done. I'm knew to MYSQL. I just installed it with all the defaults. I did choose "developer's machine" for the "optimizer wizard"

I can't redistribute MYSQL v3.51 and force it down people's throats! I have to use what they are using already, if already installed. Not even my current system takes 1 minute to add 70,000 records. Why 7.5 minutes? All it is simple inserts/free statements.

View Replies !

MySQL Slow Log
I have the long query time set to 15 yet MySQL is still showing results with a query time of 0 in the slow query log.

It says enter time in "seconds" in the MySQL Administrator but did it mean in milliseconds??

View Replies !

MySQL General Query Log And Performance
I'm wondering how big impact on performance would have turning on the general query log. I read in manual it should be turned off in production environment to increase the speed but I didn't find any information about performance (how much cpu/disk usage it would take). Is it like 1% performance lost or is it bigger?

View Replies !

Mysql Too Many Connections Performance Issues
I have a website running on a linux/apache/mysql/php
server. I receive about 8,000-10,000 visitors a day with about 200,000
to 300,000 page views. The server is a RedHat Linux server running PHP
5.x, MySQL 5.x, Apache 2.x

We have been suffering from a number of performance issues. Our
hosting company has set our max connections to 100, and we are using
persistent connections in PHP. At times the mysqld process takes 100%
of the CPU. We have also been suffering from
mysql_pconnect(): Too many connections errors. What can I do to fix
these issues?

When I run a top on the server I see this ...
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5567 mysql 16 0 169m 42m 4236 S 81.2 4.2 3078:09 mysqld
32539 apache 15 0 42676 25m 7708 S 1.0 2.5 0:03.40 httpd
32572 apache 15 0 42680 25m 7708 S 1.0 2.5 0:02.98 httpd
32608 apache 15 0 42680 25m 7704 S 1.0 2.5 0:00.72 httpd
32542 apache 15 0 42704 25m 7712 S 0.7 2.5 0:03.38 httpd
32561 apache 15 0 42732 25m 7712 S 0.7 2.5 0:02.61 httpd
32567 apache 15 0 42680 25m 7708 S 0.7 2.5 0:02.60 httpd
32591 apache ...................................................

View Replies !

MySQL Performance - Option Setting
I set OPTION=3 in my connection string as recommended by MySQL
(http://dev.mysql.com/doc/refman/5.0...parameters.html)
for a VB application.

OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2).

I found this to be very slow on a database with just 27,000 records. It took
approx. 12 seconds to read 27,000 records.

When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to
read 27,000 records. BUT now my application cannot update records anymore
and getting random errors on transactions.

I try setting OPTION=11 (all 3 options added together) and the speed went
back to being slow.

View Replies !

Mysql Performance On Large Joins (its Bad)
Mysql is unable to perform joins with large tables ON VARCHAR.

these joins run fine when the queriers are performed on INT values. However int values are not practical in this instant because I am joining on product SKUs.

sample SQL
-----------------
SELECT a.sku AS this, b.sku AS that, b.price, b.SRP
FROM table1 a
INNER JOIN table2 b
ON a.sku LIKE b.sku

TABLE specs
-------------------------
table1 14000 records
table2 13000 records

Running Mysql 4.1, PHP 4.3.

View Replies !

Performance On MySQL 5.1 / ODBC 5.1.4 Driver
Following procedure needs about 25 sec. to find the record I am asking for:

Private Sub btnLesen_Click()
sSQL = "SELECT * FROM tblAdressen WHERE AdressNr = 8"
aRs.CursorLocation = adUseClient
aRs.Open sSQL, oConn, adOpenKeyset, adLockOptimistic
If aRs.RecordCount > 0 Then
sevVorname = aRs!Vorname
sevStrasse = aRs!Strasse
sevOrt = aRs!Ort
sevName = aRs!Nachname
End If
End Sub

There are around 14'000 records in the table, Nr. 8 is the first one! I am trying to find the reason for the bad performance for days - without any success.

Following Flags are checked for the connector:

- return matched rows instead of affected rows
- Allow big results
- Use compression
- Treat BIGINT columns as INT columns
- Enable safe options
- Don't prompt when connecting
- Enable dynamic cursors
- Ignore schema in Column specification
- disable driver-provided cursor support
- Don't use setlocale()
- Don't cach results of forward-only cursors
- Ingnore space after function names
- Disable catalog support
- Disable transaction support
- Force use of forward-only cursors
- Limit column sizs to signed 32-bit range

The file "my.ini" I didn't change!

I work with Win2000 & VB 6.0

View Replies !

Mysql Database Performance Counters.
I am testing an application using OpenSTA on Windows platform and it's database resides on the Linux server. I have installed a Mysql server version 5.0.45 on Centos5.2.

I run the scripts through openSTA for generating load on my application. How to monitor the database performance counters in the case where the load is generated on the server.

I want these performance counters to be available on windows performance monitor. Is there any way to do this?

View Replies !

Database Performance Counters For Mysql 5.0.45
I have installed mysql server V5.0.45 on CentOS 5.2.

I want to know whether it installs database performance counters along with the software as Microsoft SQL server automatically installs the counters and those can be monitored using Windows Performance monitor tool.

View Replies !

Tips For Improving The Performance Of Mysql
I really hope I can get some general advice and suggestions about how I can improve the performance of our mysql server.

We have a dedicated webhost running a number of quite highly used websites. They all use mysql quite heavily at times. Recently we've had complete mysql gridlock and had to restart the server. What are the steps I can take to improve performance?

This is what i've done so far.

1. Optimise queries - i've been checking the queries we are running and trying to cache the results in a session rather than generating all the time. I've also installed something called mytop which is basically the same as the standard unix top command, except for mysql processlist and shows you the queries currently running and the time elapsed.

2. I have run explain on my queries and put in indexes all over the place to try and make lookups quicker.

Things i'm considering doing

1. Reducing the amount of data in the database and perhaps rotating the tables slightly, our biggest tables are approaching 2 million records and linking these together is i'm sure causing some of the problem, especially when we have to run a SUM query on them, even with good indexes.

2. Moving the database off the webserver and onto its own dedicated mysql server.

3. Load balancing the database and somehow clustering more than one database server, but this would cause serious headaches so not seriously considering unless it was thought the best solution.

4. Upgrading mysql... We are currently running version 4.0.27, should we upgrade to 5? Will this give us performance boost?

5. Re-compiling... After a google search I discovered that potentially we could recompile mysql with a better options set and perhaps improve performance.

6. Buying a book on mysql optimisation Any suggestions?

View Replies !

Tool For Administrating MySQL, Especially Performance
Are there any administration consoles out there for MySQL that specifically with performance? I'm most used to using MS SQL, and inside the admin console there, there are tools like profiler where it will watch the database, show queries as they execute with timing, etc.. and then you can drill deeper into execution plans, etc.. I've searched for tools on the internet, but haven't found anything definitive. I use phpmyadmin now, and I've looked at Navicat, but didn't see any performance monitoring or inspection tools.

View Replies !

MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server.
Apache runs great, but the auction software I am using (Web2035 Auction
software written in PHP) is very, very slow.

Sometimes it takes 20-30 seconds to bring up an auction page from the items
table which has less than 200 records in it.

Can anyone can give me some pointers on where to start looking? (I don't
know if the bottleneck is with MySQL or PHP or what I might need to look at
to enhance the performance of either package.)

View Replies !

Slow Mysql Select *,
I have a sql table with more then 20,000 rows in a table called summary and when I run "select * from summary" it returns a exucutions time of 0.5 seconds in php which is kinda slow if you ask me, now I know that the * type for select isnt the fastest way to fetch data but its the most convenient for me.

View Replies !

MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL.

My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.

Is there any settings I can change that would help me here? Any help would be greatly appreciated.

One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.

View Replies !