hi,all
i have a strange question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual PIII667+ 768MB RAM
I have a table like this
CREATE TABLE ABC (
A int(10) unsigned DEFAULT '0' NOT NULL,
B int(10) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20)
I have mysql working, but I can't get mysqlgui to connect. I've tried the
'bin/mysqladmin version' test and that works ok, it's just that mysqlgui doesnt
connect for some reason. A test doing 'telnet localhost 3306' connects (but later
disconnects, some msg about foreign host...), I just
oh.
no.i am not talking about of the speed of SELECT.
my problem is the speed of INSERT and UPDATE.
evenmore indexes only slow down the speend of insert,update.
i ruduce the index to only i need.
-
What sort of queries are you doing on this large table? I notice you only have
Sir,
Iam Roopa mailing you from linux learning centre.
I have a slight problem regarding mysql-3.23.22-6
I have installed this for the first time using rpm packages.after
installation when i run mysql_install_db ,
but when i try to start mysql daemon using safe_mysqld
am encountering an error
Trying to setup mysql on a cobolt raq4 however i keep getting an error 1064
does anyone know what could be causing this.
Regards
Adam Ward
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Alexander.
Thank you for the interest.
I wait for to understand my unfortunate groins.
My problem is that when I am going to conect to MySql throuhgt ODBC is very
slow in the begining, I want to use another method, if you know another one
that is not ODBC I will thank you. I use Visual Foxpro
We have one (WinNT) installation with a database that has grown to +250mb.
This particular database was ported to MySQL from MSSQL7.
Our experience has been that if you supply adequate resources for the server
(RAM, CPU and Virtual Memory) the size of the database only becomes an issue
during
Hi,
I have a problem i was using mysql and it was very well but yesterday
it didn't work then i removed it and reinstalled it , it worked 2 times
and then again it doesn't work, when i run mysqld it doesn't run in the
background of windows, and in the error file it says
13:05:14
You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a
chown mysql.mysql and then did a chmod 775 on the directory.
So I still get basically the same thing.
I enter: mysqladmin -u root -p password meg123
Enter password:(I leave it blank and CR)
mysqladmin: unable to
Hello Murrat,
is it possible, that someone deletes your mysql-database or the host table?
Maybe yourself?
The server needs this table for the "authorization rules", and a deletion
should be avoided!
Hope that helps.
Regards
Andy
-Ursprngliche Nachricht-
Von: Murat YESILDAL
Yes I tried that too... Same stupid stuff happening
clay bond writes:
On Fri, 9 Feb 2001, Mailing List Address wrote:
Help!
[ ... ]
6 rows in set (0.00 sec)
(The output should be mysql and test.)
Looks to me like you didn't run mysql_install_db
--
/"\
\ / ASCII
I did.. I tried everything...
[root@cents /usr/local/mysql]# chmod -R 0777 var
[root@cents /usr/local/mysql]# llm
total 2.1M
drwxr-sr-x 12 mysqlmysql1.0k Feb 10 00:12 .
drwxr-sr-x 26 root root 1.0k Jan 28 00:59 ..
drwxr-sr-x 2 mysqlmysql1.0k Feb 9 23:48
I remember trying out a really nice Java GUI for mysql, had a yellow and
gray color scheme if I remember correctly, and was very nicely done. The
only thing I can find the the GUI clients page at mysql.com is one so-so
client that doesn't do what I need. Anyone maintaining a list of all the
Hi,
I've read some people talking about ISAM and MYISAM table.
I dont understand what are those tables and can anyone explain to
me and the
difference of each table. and also which one has better performance?
Read The Fine Manual, chapter 8: MySQL table types
/ Carsten
--
Carsten H.
Well, I finally got that portion working. After I putzed around for awhile, I
said to myself - Self, With all this putzing, I probably need to restart the
mysqld server. So I tried that from linuxconf and for some reason it just didn't
want to restart! So, I went and did a /etc/rc5.d/S85mysqld
I'm new too, but a good starting point would be:
http://www.mysql.com/doc/T/a/Table_types.html
regards,
thalis
---+
You're definitely on their list.
The correct question to ask is what list it is.
---+
On Sat, 10 Feb
On issuing the command:
rpm -i MySQL-32.23.32.-1.i386.rpm
the following error listed:
cannot open Packages index using db3 - Permission denied (13)
-- The rpm database cannot be opened in db3 format.
If you have just upgraded the rpm package you need to convert
your
Could you do something like:
CREATE TEMPORARY TABLE temptable (
pk INTEGER,
rand INTEGER
);
INSERT INTO temptable SELECT yourpk,Rand() FROM yourtable;
SELECT yourtable.* FROM yourtable,temptable WHERE pk=yourpk ORDER BY rand;
DROP TABLE temptable;
That might be quicker than your current
Hi,
I would like to know how to add, modify and delete entries with PHP or Perl, because I
want to create a table in mysql and and don't know how.
The table look like this:
-| time spent on-line | leads | mailling list |e-mail |
On Sat, 10 Feb 2001, 163 wrote:
x
mysql-3.23.32/sql-bench/Results-linux/big-tables-mysql-Linux_2.0.33_i586-cmp-ms-sql,mysql,sybase,
684 bytes, 2 tape blocks
UX:tar: ERROR: Cannot set time on ././@LongLink: No such file or directory
UX:tar: ERROR: Directory checksum error
what's the wrong
Hi there,
In the quest to get a random row from a table, "order by rand()" has
proven too inefficient and slow. It's slow because MySQL apparently
selects ALL rows into memory, then randomly shuffles ALL of them, then
gives you the first one - very inefficient. There are a few other ways
Description:
I have this little script (1) that builds a table each night.
For quite a while the output shows a normal load data infile (2).
Then, it switches to a state of 'Repair with keycache' (3).
This just started happening with mysql 3.23.32. Until I upgraded
a few days ago it was not a
Hi.
On Sun, Feb 04, 2001 at 02:57:06PM -0700, [EMAIL PROTECTED] wrote:
I recently asked for some help with join order and it's now fixed, kinda :)
On a web server running mySQL version 3.22.32 on a Linux box (cobalt RAQ) I get the
following output for this query:
EXPLAIN SELECT * FROM
Hi.
'localhost' is a special name for MySQL, which implies to connect via
mysql.sock. You don't need to recompile, just give the host name (like
test.earthlink.net or whatever it is) or IP address of your PC and
MySQL will use TCP sockets.
Bye,
Benjamin.
PS: I don't really know
Hi.
It looks like you are using persistent connections with SQL server,
but not with MySQL (time_wait and close_wait are states of a TCP
connection after it was closed by the appliction). I don't know much
about PHP, but there is somewhere a option to influence whether you
want persistent
Hi.
'0' (i.e. Zero) has a special meaning for AUTO_INCREMENT, namely the
same as NULL, which will choose a automatically a new value for the
column. (Btw, are you sure, that you get the error for the row which
was '0' and not for the one which was '72' - the latter sounds more
probably to me).
I wish, ERWin is wonderful!
- Original Message -
From: "Cal Evans" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 10, 2001 6:41 PM
Subject: Data modeling tool
As much as I love creating models by hand, my databases are growing to the
point where I need a tool to
Hi.
On Tue, Feb 06, 2001 at 02:00:11PM +0100, [EMAIL PROTECTED] wrote:
Hello!
I was wondering if anyone knows how big a qury can be in MySQL 2.23.14???
First 2.23.14 is not a known MySQL release. You probably mean
3.23.14. If so, you are still using an alpha release and should
upgrade to
Hi Andy,
I dont think so to be honest it could be but i removed mysql and
reinstalled it several times
and each time, it works for a few times and then it collapses... any other
idea ???
murat,
At 19:13 10.02.2001 +0100, Dingfelder Andy wrote:
Hello Murrat,
is it possible, that someone
I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers
a trial download, and does support MySQL.
Mark Chalkleyi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Sat, 10 Feb 2001, Cal Evans wrote:
As much as I love creating models by hand, my databases are growing to the
point where I need a tool to help me "see" them. Does anyone know of a tool
like ERWin or ER/Studio that supports MySQL?
I have a project called Alzabo (alzabo.sourceforge.net)
How do I dump all the contents of a table called "clients" into a .txt
file (or anyother kind of file for that matter).
Thanks for your help.
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello,
if you want to have a file with just the bare data contents of the table, you simply
do:
mysql SELECT * FROM table_name INTO OUTFILE '/tmp/lala.txt';
otherwise if you want your data represented in SQL, so that you can reconstruct the
table by importing at a later time (a backup form):
Despite the temptation to suggest RTFM ...
mysqldump database table(s)textfile.txt
~ or ~
mysqldump -uUserID -pPassword database table(s)textfile.txt
If you type mysqldump|more at the command prompt, the syntax for this
command is fully documented. You will also find the MySQL Manual to be
Hi all,
The resolution to my problem is probably simple for many of you.
However, I'm new to MySQL and php and am having difficulties. However,
I'm ignorant, not stupid, and can follow directions.
My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin
installed on my Red Hat
It looks like MySQL is working fine, phpMyAdmin just needs to know your new
password so that it can connect to the database. Just edit the
"config.inc.php" file in the phpMyAdmin directory.
Find the lines:
$cfgServers[1]['user'] = 'root';// MySQL user (only needed
with basic
Just to add to that, suggest you create another user, other than root, and
use that instead. Look up Grant in chapter 7 of the manual on how to create
users.
- Original Message -
From: "Daniel Von Fange" [EMAIL PROTECTED]
To: "Eddie Rhodes" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Firstly, have you flushed privileges?
Secondly, I think you want "mysql -p -uuser samp_db". You have already
created the database, right?
- Original Message -
From: "Larry Marshall" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 11, 2001 6:41
Subject: Trouble creating
Hello.
On Fri, Feb 09, 2001 at 09:53:45AM -0500, [EMAIL PROTECTED] wrote:
Good Morning:
We have a system of databases (in the plural) which number in the hundreds
on individual servers. I want to open a persistant connection on the server
and switch databases without closing the handle in
Hi.
First, there is somewhere a chapter about disk usage in the manual
(too lazy to look it up).
On Fri, Feb 09, 2001 at 09:51:03AM -0500, [EMAIL PROTECTED] wrote:
I was wondering if someone could help advise me on calculating
database size estimations. Assume the following table:
Field
Hi.
On Fri, Feb 09, 2001 at 05:34:38PM +0200, you wrote
[...]
5. Add a timeout to lock waiting: Innobase can detect and resolve deadlocks
within its own lock table, but if a user uses also MySQL LOCK TABLES... or
BDB locks, a deadlock can occur where Innobase does not know of all the
locks:
Excuse me ,I am looking for Wenhong Liu, Ph.D. Tulance University
1995, BS Naikai University 1990.
Would you please give her contacting information,or forward my information
to her.
Thanks for your help!
Niu Hong
Email:[EMAIL PROTECTED]
[EMAIL PROTECTED]
Telephone:(617)
I am trying to tune mysql on linux for a web based application. Reading
throw the docs I found thread_cache_size I checked what it was set to by
default and found that it was 0. In the docs it says That it doesn't
make much difference if you have a good thread implementation. So my
major
I asked a similar question recently and as a result of my searching, I found
a moderately priced, $99 (I think), data modeling tool from XTG (download
here):
http://www.xtgsystems.com/download.php3
I downloaded it and set up a few tables (only 4 are allowed with eval), then
generated the sequel
On Sat, Feb 10, 2001 at 03:24:42PM +0533, Jaya Thakar(ASI 2001) wrote:
Can anybody tell me ,how to remove all the visited pages from the
cache after logout that is after invalidating the session in java
servlets and mysql, so that pressing the back button of the browser
doesn't displays
On Sat, Feb 10, 2001 at 11:32:25AM +, guru prasad wrote:
I have a site with the database of size 90 MB on Mysql-3.22.25.
It is performing quite well right now,
Please let us know the maximum limit of the database size that Mysql
can handle efficiently.
It really depends on the
?php
$query = "SELECT col1, col2 FROM the_table ORDER BY RAND() LIMIT 1";
$result = mysql_query($query) or die("could not query");
$row = mysql_fetch_array($result);
print $row[col1];
print "P";
print $row[col2];
?
Robert B. Barrington
GetMart Commercial Ecom: Web Administrator
I am the first day user.
Do I need to type the commands all over again if it is wrong?
I've been looking for a way to disable logging to mysql_history on a global
basis. Does anyone know of a way to do this? If so, please e-mail me at
this address (I don't check the list). If not, can someone tell me how to
submit a feature request?
My current work-around is to create the
Description:
running ./configure with no options works fine until the test
program to determine the size of the char data type is compiled and
run. I've compiled and run the sample program manually, and added a
printf() statement to show the result that's placed
Hi,
I`m selecting information from my MySQL as follows...
Select * FROM Features WHERE Platform='pc' and Public='Y' Order by DateTime
ASC LIMIT 0,3
I am storing the field DateTime as a date when selected it looks like this
2001-05-05 but I want to change it so it looks like May 5th 2001,
"Jeffrey D. Wheelhouse" wrote:
SELECT @lines:=COUNT(id) FROM table;
SET @rand=CEILING(RAND()*@lines);
SELECT * FROM table WHERE (@rand:=@rand-1)+id=id;
Never mind on the "it doesn't work on my system" more like it didn't
work on my brain :) Works fine. And now that I ponder it a bit
52 matches
Mail list logo