Hi,
I have a table tAccount which is a chart of accounts.
Accounts in the master chart have a CientID of NULL, and there will be a duplicate set for each client with a corresponding ClientID....
http://www.experts-exchange.com/Database/MySQL/Q_23191861.html
Zones:
MySQL ServerDate Answered: 02/25/2008 Grade: A Views: 13
I am trying to optimize the 2 queries below (one of them is a view), but I cant figure out how to get it to use the indexes I have set up.
The queries are run a minimum of 900 times every 2 minute...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23605138.html
We have 1 master MySQL server (5.0.27 Community Edition), and several slave servers.
We can stop replication at the slave by setting the my.ini to ignore the databases/tables, but we would like ...
http://www.experts-exchange.com/Database/MySQL/Q_23403098.html
Zones:
MySQL ServerDate Answered: 06/05/2008 Grade: A Views: 9
Hello you all,
I am using mySQL 5.0.27 for Windows XP SP2.
I would like to install mySQL (datadir only) on the network (for backup's issues), the rest of the installation would continue loca...
http://www.experts-exchange.com/Database/MySQL/Q_23274165.html
Zones:
MySQL ServerDate Answered: 04/10/2008 Grade: B Views: 50
We have a system consisting of two PC's
client 1 multi user
|__|
\ |__| ..one user..............|__|
/winserver Mysql
|__|
cli...
http://www.experts-exchange.com/Database/MySQL/Q_23143739.html
Here is the setup:
2 x Sun T2000 running 1 mgm node each (amongst other things)
2 x Sun T1000 running 1 mysql and 1 ndb node each (dedicated to MySQL) with 8GB of physical memory
According t...
http://www.experts-exchange.com/Database/MySQL/Q_23163050.html
