"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
"Jeffrey D. Wheelhouse" wrote:
>
> Here's another approach. I'm curious about the performance implications:
>
> SELECT @lines:=COUNT(id) FROM table;
> SET @rand=CEILING(RAND()*@lines);
> SELECT * FROM table WHERE (@rand:=@rand-1)+id=id;
>
> This *should* give each row an equal chance, but it'
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, I`v
Hmm, no reading comprehension points for me. I managed to read Steve's
message the first time without realizing that he only wanted one row.
Here's another approach. I'm curious about the performance implications:
SELECT @lines:=COUNT(id) FROM table;
SET @rand=CEILING(RAND()*@lines);
SELECT
>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 i
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 fil
I am the first day user.
Do I need to type the commands all over again if it is wrong?
";
print $row[col2];
?>
Robert B. Barrington
GetMart Commercial Ecom: Web Administrator
http://weddinginlasvegas.com/
http://getmart.com/
[EMAIL PROTECTED]
Vegas Vista Productions
3172 North Rainbow Boulevard
Suite 326
Las Vegas, Nevada 89108-4534
Telephone: (702)656-1027
Facsimile: (702)656-
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 h
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 display
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
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 question
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)
Hi.
On Fri, Feb 09, 2001 at 11:49:23AM -0500, [EMAIL PROTECTED] wrote:
> Hello,
>
> In an earlier post I complained of performance problems with ODBC+MySQL
> when running a server which makes many 'small' queries and writes. What is
> the overhead? The benchmarks indicate that MySQL via ODBC
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
> lock
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
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 handl
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 creatin
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]>
S
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 auth
Hi.
On Thu, Feb 08, 2001 at 01:52:47AM -0800, [EMAIL PROTECTED] wrote:
> Hi Everyone,
> Sorry for the subject but I am in a very very
Btw, this is the perfect way to get ignored.
> desperate state 'coz the whole site is down and if I
> cannot connect to the database through my servlet my
> @ss
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 Linu
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
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):
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 manua
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)
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)
Hi.
On Wed, Feb 07, 2001 at 09:39:15AM -0500, [EMAIL PROTECTED] wrote:
> Yes, I should have been more clear, I know that you can join a table to itself but I
>am trying to find out:
>
> 1) What is the max number of joins (unique tables/mixture of same table joins)
As far as I remember, there i
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 del
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.
On Tue, Feb 06, 2001 at 10:05:07AM +0800, [EMAIL PROTECTED] wrote:
> why mysql eat my memory over 1G?Please help me!Thank you!!!
>
> server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 .
> mysql start command:nohu
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
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?
Cal
http://www.calevans.com
-
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).
B
Hello.
Sorry, I don't understand what you want to archieve. Could you write
your questions in other words again? If possible, with an example.
Bye,
Benjamin.
On Mon, Feb 05, 2001 at 01:56:04PM +0200, [EMAIL PROTECTED] wrote:
> Hello
>
> Is there any way of repeating groups in MySql.
>
try PHPMyEdit: http://phpmyedit.sourceforge.net/
Maciek
> -Original Message-
> From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 10, 2001 11:37 AM
> To: Lista MySQL
> Subject: Add, modify and delete entries with PHP or Perl
>
>
> Hi,
>
> I would like to know how
Using RedHat 7.0, MySQL-3.23.32.-1
Logged on with mysql -u root -p, issued GRANT ALL ON samp_db.* TO user
IDENTIFIED BY "secret";
When logged onto Linux in the user account, typed mysql -p, resulted in:
ERROR 1045: Access denied for user: 'user@localhost' (Using password:
YES)
If I use the s
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 whethe
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 connect
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 * FR
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 pr
> 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
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
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 |
-
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 a
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
I've
Hi.
A bit late, but I did not see an answer to your question yet.
On Fri, Feb 02, 2001 at 03:23:06PM -0800, [EMAIL PROTECTED] wrote:
>
> We are getting thse errors. Can anyone point me in the right direction?
>
> DBI->connect(database=whois;host=www5) failed: Host 'www5' is blocked
> because o
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 databas
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 2001
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 s
> 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. P
> 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 th
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 bi
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
>
> --
> /"\
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
> -Ursprüngliche Nachricht-
> Von: Murat YESILDAL [mai
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 ch
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 C:\MYSQL
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 RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
--
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 dum
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 6
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)
ht
J.M. Roth writes:
> Hello,
>
> I updated to 3.23.32 and now this happens:
> mysql> show databases;
> +--+
> | Database |
> +--+
> | |
> | |
> | |
> | |
> | |
> | |
> | |
> | |
> | |
>
[EMAIL PROTECTED] writes:
> >Description:
>
> After running for a variable amount of time, our server will just die.
> We have run myisamchk several times, with -r and with -o. We even
> checked the actual file system for corruption. This is a real problem
> when the server doesn't automa
Kevin H writes:
> 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 ms
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 sa
Konstantin Osipov writes:
> Hi!
>
> Is this code buggy?
>
> ...
> mysql_res = mysql_store_result(mysql);
>
> if (mysql_errno(mysql) == 0 && mysql_num_rows(mysql_res) > 2 &&
> mysql_num_fields(mysql_res) > 2)
> {
> MYSQL_ROW row1 = mysql_fetch_row(mysql_res); // can i fetch severa
Hi,
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.
Regards,
Guru
_
Get You
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
Hi!
Thanks for have a look at me. I got some problem followed, thanks..
Because of deleting some data from a table, and I got the uncountinued
index number.
Yesterday, I tried to alter the table to delete a auto_increment and
primary key column
named "m
hiall
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
any
page visited while a person was logged in.
--
jaya
What sort of queries are you doing on this large table? I notice you only have
a couple of the fields indexed
jason
- Original Message -
From: "chchen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 6:35 PM
Subject: Speed of mysql
hi,all
i have a strange
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 don'
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) u
73 matches
Mail list logo
