Hi,
PHP Version 4.3.1
Mysql Version 4.0.13
When I try and run the following query
CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable;
on each database, the first one will run it with no problems at all. The
second returns the error:
[server] ERROR 1044: Access denied for user: '[EMAIL
That's it? The entire system - OS, swap space and data in a single array?
Nothing more involved?
[EMAIL PROTECTED] wrote:
> My favourite for dedicated db servers (good amount of data, but a ton of
> access, queries/sec) is raid 0+1 ... fast access, but requires a good number
of disks..
>
> Be
My favourite for dedicated db servers (good amount of data, but a ton of
access, queries/sec) is raid 0+1 ... fast access, but requires a good number of
disks..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
> What w
Thanks guys,
Actaully my Hard disk is 10G, just for one table. There is enough table
space. I noticed when I created index for 1.9G table, at the first phase,
mysql copy table, but mysql doesn't write to the tmp index file, I means the
filesize of the tmp index didn't increase. When I create in
It depends on what your goal is and how many disks your system will
contain.
Personally I like a disk configuration with multiple spindels for
performance. I also require redundancy, RAID-5 sounds good and is but I
want the most out of writes, so I go with RAID-1+0.
Hope this helps.
On Sat,
try --with-mysql=/usr
--- -{ Rene Brehmer }- <[EMAIL PROTECTED]>
wrote:
> X-posted to PHP General, PHP DB, and MySQL
>
> Hi gang
>
> Attempting to get my Linux test-server working, but
> ran into a problem when
> "making" PHP...
>
> System is RedHat 8, Apache 1.3.27 (compiled myself,
> tested
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What about
the best configuration for a dedicated W2k server running MySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list archiv
X-posted to PHP General, PHP DB, and MySQL
Hi gang
Attempting to get my Linux test-server working, but ran into a problem when
"making" PHP...
System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL 4.0.13.
The Apache 2.0.40 and PHP 4.2.2 that came w. RH8 didn't work correctly,
I take it no one is familiar with particular error? Didn't get anything
on google.
-Original Message-
From: marvc [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 9:00 PM
To: [EMAIL PROTECTED]
Subject: Possible OT: ADONewConnection Error
Anyone here familiar with the following
Hi. I'm a relative MySQL newbie.
A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box.
After some use, the system began to run very slowly, e.g, the login
box, start menu, and other apps were taking a few seconds to respond
to my mouse. Rebooting did not solve the problem.
By trial an
Hi !
In a server with Conectiva Linux 6.0 (A Brazilian version) and Mysql
3.23.36
the comand "SELECT NOW()" returns "2003-07-05 10:00:00" both in
the server and in the clients (Windows 98 with mysql-front and many programs
writen in Delphi and MYODBC 2.50 or Zeos).
In a new server with Conectiva
The release 2.1.1 is a major bug fix and a few new features. If you are
using an older Professional version, please consider updating it. Bellow,
you can see the list of changes:
NEW FEATURES
-Added support to load/export binary data into/from a table (for blob
fields). From now on BLOB fields wi
I tried to look everywhere @ mysql.com but i couldn't my question is
how many records can a table handle so it stays fairly fast?
What is the maximum records it can handle??
Thanx for any answers
Anthony
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
> On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> > I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> > create indexs for it, I couldn't finish after 4 hours.
>
> You mean it was still running?
On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> create indexs for it, I couldn't finish after 4 hours.
You mean it was still running? Was there still disk or CPU activity
after 4 hours?
>
Hello MySQL,
I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
create indexs for it, I couldn't finish after 4 hours. But when I reduce the
records to 16,000,000, about 1.9G, the same index can be finished within 35
minutes. Can anyone explain it? Thanks in advance.
I a
Running 3.23.56, from phpmyadmin all works fine. I'm building an admin
page, I can add a record, but when I try and update, I get this error:
Anyone have any ideas?
Here's the code for update.php:
Hovey Database Update Page