Jeremy,
if i run the command
show tables; on some database
it returns
5 rows in set (0.02 sec)
and if, on the same database i run
the command
select count(*) from 'table';
it returns
+-+
| count(*)|
+-+
| 47226322|
+-+
1 row in set (0.00 sec)
now, i believe its
It's just that the number of rows in a table is stored directly in the
.MYD file (I believe) so a query like select count(*) from table will
just return that value, rather than counting all the rows. It's not
that the functions are built-in, rather they're *optimized* - a
totally different thing.
Hi!
On Dec 18, Andrew Rucker Jones wrote:
Sergei,
Forgive my ignorance, but i've been thinking about this. Isn't it
impossible to get it to work with the system calls i listed from strace?
To repeat:
chdir(/usr/local/var/mysql/) = 0
chroot(/chroot/mysql) =
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Greetings
Recently I have a great problem. My whole project depends on it and some
people are not satisfied with my aplication because of it. I use database
for storing into InnoDB tables word documents into BLOBs, and some other
information about docs into standard column types. However, after a
OK.. I have a field named 'adate' which is a mysql auto timestamp. I
need to use this data to do many time functions on a large 160,000 or so
row database. I have indexed adate, but am having trouble with this
WHERE statement because I am unable to make clean use of the index. I
have to do
hi
we have developed for a client and now its testing
phase by next week...
using Linux/PHP/MySQL 3.23
we need to test the database load...
like how efficienty query is executing...
how many inserts..updataes taking place...etc...
how much the data etc...
is there any tools available for this?
any
I tracked down the bug
I have one table with BLOB field in it
Then I execute queries like
SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
here, keywords is a blob fields
when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
hope this helps
--
Paul P
hi all ,
i am facing a great trouble of mysql corruption on
windows
i am using mysql 3.23.53-max-debug version on win 9x
plateform
i am using both PHP and VB as a client
mysqld is running
some the the cause of the table corruption is the
sometimes improper shutdown
sometimes normal shutdown
I keep getting this message what can i do to correct this problem ?
Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-page.php on line 4
-
- Original Message -
From: Lalit Chandwani [EMAIL PROTECTED]
To: MySql Mail [EMAIL PROTECTED]
Sent: Saturday, December 21, 2002 3:18 PM
Subject: mysql corruption probelm - urgent
hi all ,
i am facing a great trouble of mysql corruption on
windows
i am using mysql 3.23.53-max-debug
MySQL is not the problem.
Are you shutting down MySQL before you shutdown/restart the machine?
When you say Win9x, which flavor or Win9x do you really mean ('95, 98,
98SE?)
- Original Message -
From: Lalit Chandwani [EMAIL PROTECTED]
To: MySql Mail [EMAIL PROTECTED]
Sent: Saturday,
This has been answered a zillion times in the past.
Search the archive.
mysqld.sock will usually live in /tmp
Change the appropriate paths.
-B.
-Oorspronkelijk bericht-
Van: Rich Dodge [mailto:[EMAIL PROTECTED]]
Verzonden: zaterdag 21 december 2002 16:10
Aan: [EMAIL PROTECTED]
At 09:18 PM 12/20/2002 -0500, Michael She wrote:
The value's been clipped to the upper end of the range.
Your next question should be why that value has 9 digits to the left
of the decimal point. :-)
How did you guess! This behaviour is why I asked the question in the
first place. Why does it
Is mysql service started?
Check with:
ps -ax mysql | grep -i mysql
If it does't appear on tje list, start the service with:
service mysql start
Adolfo
P.S. I have mysql.sock in /var/lib/mysql which is the default. Check
also basedir in your /etc/my.cnf.
-Original Message-
From:
How did you guess! This behaviour is why I asked the question in the
first place. Why does it get clipped for a 10 digit number. Without the
decimal value I believe it inserts correctly, but with the 2 decimal
places it get clipped...
No, it won't insert correctly, it will still get
Hello,
following problem occurs using MySql.
Can you help me with that Error?
Betriebssystem: [ SuSE Linux 7.3 (i386) ]
MySql Verision: MySql Max 4.0.6
OMEGA.ERR:
021221 14:24:21 InnoDB: Assertion failure in thread 16401 in file
mem0pool.c line 491
InnoDB: We intentionally generate a memory
At 10:12 PM 12/20/2002 -0600, Paul DuBois wrote:
For a 10,2 decimal column, should this be a valid number:
1234567890.12?
It's easy to test:
mysql CREATE TABLE t (d DECIMAL(10,2));
Query OK, 0 rows affected (0.01 sec)
mysql INSERT INTO t SET d = 1234567890.12;
Query OK, 1 row affected
either mysql is not running or php doesn't know where to find your sock.
make sure that php.ini has the correct location for your sock and that ps
auxwww shows mysql running.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rich Dodge
Thanks Dean.
-Original Message-
From: Dean Harding [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 12:46 AM
To: 'JamesD'; [EMAIL PROTECTED]
Subject: RE: Can MySQL handle 120 million records?
It's just that the number of rows in a table is stored directly in the
.MYD file (I
Hi all,
We are pleased to announce the new DBTools Manager Professional 2.0.
This version is not a bug fixed, but a brend new application with much more
features and still easier to use. This version has been developed for
almost a year, and now with a new and improved GUI, really cool new
On Friday 20 December 2002 15:31, Imran Khan wrote:
I'm using solaris 8 with mysql v 3.23.54.
I want to enable a solaris user - 'user1', to use the mysqlimport command
without using a password.
I've run, as root, the following sql command:
mysqlgrant all on db1.* to user1@localhost
-this
On Thursday 19 December 2002 21:29, Arun kumar R wrote:
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly
Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in Debian GNU/Linux.
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debconf.
Description:
The unpacked source differs from the source tree after a
./configure make make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function
`handle_connections_sockets':
: undefined reference to `request_init'
Please someone email me at [EMAIL PROTECTED] how to do this as well...I
am lost on how to ad data to MYSQLCC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
On Thursday 19 December 2002 21:29, Arun kumar R wrote:
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly
Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in Debian GNU/Linux.
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debconf.
Description:
The unpacked source differs from the source tree after a
./configure make make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function
`handle_connections_sockets':
: undefined reference to `request_init'
Please someone email me at [EMAIL PROTECTED] how to do this as well...I
am lost on how to ad data to MYSQLCC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Christopher,
- Original Message -
From: Christopher Stephan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, December 21, 2002 6:00 PM
Subject: Bug Report
Hello,
following problem occurs using MySql.
Can you help me with that Error?
this is memory corruption,
On Friday 20 December 2002 15:31, Imran Khan wrote:
I'm using solaris 8 with mysql v 3.23.54.
I want to enable a solaris user - 'user1', to use the mysqlimport command
without using a password.
I've run, as root, the following sql command:
mysqlgrant all on db1.* to user1@localhost
-this
OK.. no takers the first time... I'll try to give more/better
information..
I am running into a system wall here. I have at the moment about 2600
rows of data totaling 650K. I expect this to grow at a rate of about an
additional 1200-1500 rows per week. I am using PHP to format the returns
into
Greetings,
I'm very new to Mysql and am trying to work with my first multi-table
database project. Here are my two table descriptions. I'm trying to
get the correct syntax for a sql query to do the following.
Display Ticket.Ticketnum,Ticket.Priority,Ticket.Title,Ticket.Status. I
assume
Hi--
I have just begun using MySQL...I am using a program called MySQL to manage
an online database. I can see the entire table I need and all the records in
that table for the db I¹m working with. I have a field called fullname which
is supposed to receive the full name of the person entering
SEELECT t1.* FROM ticket t1,customer t2 WHERE
t1.customerid=t2.customer.id AND t2.email='[EMAIL PROTECTED]'
On Sat, 2002-12-21 at 16:52, Jim Hankins wrote:
Greetings,
I'm very new to Mysql and am trying to work with my first multi-table
database project. Here are my two table
Jeff,
Are you looking for an update table syntax?
Example
Update tablename
Set FullName=Their Full Name where someotherfield=someother value;
Careful with this one. As if you omit the where clause it will update
every record!
-Original Message-
From: Jeffrey Ellis [mailto:[EMAIL
The following query adds NAME and ADDRESS (where the last name is
wrongly placed) and set ADDRESS to an empty string.
UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
WHERE ID=the register id
Adolfo
On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
Jeff,
Are you looking for
Hi, Adolfo--
Thank you!
But I have two problems here...First, I (whoops!) don't have an id field. In
the program I use, you can only set a key field when you first create the
database. I would love to have an id field, but don't know how to create one
now. :(
The second is that the command will
Instead of:
TO_DAYS(adate) = TO_DAYS(NOW()) - 6
you can try:
adate = unix_timestamp(now()) - 6 * 24 * 3600
This way, you don't need to apply a function to 'adate'.
You should also note that these expressions are not exactly
equivalent since yours compares day numbers but mine compares
seconds.
If
I keep getting weird return messages from the list.. not sure if this
made it through..
I am running into a system wall here. I have at the moment about 2600
rows of data totaling 650K. I expect this to grow at a rate of about an
additional 1200-1500 rows per week. I am using
CONCAT(FullName,' ',Address)
regarding the lack of an ID field, create a new table with all the
fields from the original table plus an ID field, auto_numeric, and
insert the registers from the old table to the new one. Then, use the
UPDATE on the new table.
Adolfo
On Sat, 2002-12-21 at 17:35,
Just a wild guess. If you are only using TO_DAYS(somedate) for the
queries, why don't you create the column 'adate' as INT and index it?
When you need the real DATE, use the FROM_DAYS() function.
Just a wild guess that I think could improve your queries speed.
Adolfo
On Sat, 2002-12-21 at
Hi, Adolfo--
Thank you again!
However, the problem is, the table is linked to a file on the web. If I
create a new table with a different name the link wont work and no data will
be entered.
Is there a way to rename a table once you create it? Then, I could delete
the old table after I create
Look in the manual the ALTER TABLE command. I don't remember the syntax
but it can be done.
Adolfo
On Sat, 2002-12-21 at 18:56, Jeffrey Ellis wrote:
Hi, Adolfo--
Thank you again!
However, the problem is, the table is linked to a file on the web. If I
create a new table with a different
Thanks, Adolfo! I appreciate very much you taking the time to help me:)
All My Best,
Jeffrey
on 12/21/02 3:10 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
Look in the manual the ALTER TABLE command. I don't remember the syntax
but it can be done.
Adolfo
On Sat, 2002-12-21 at 18:56,
.
Dear List,
I'm using php MySQL for a cycling club website, results, guest-book,
events and so on. I've just started and have faithfully created indices
all over the place.
At present, we have less than 400 records, be they of members, of image
URLs, whatever. Each year will, I expect,
Dear sir,
i come across yourmanual [mySQL Reference] when browsing through the
internet, i read it
but i didn't understand it. i like to develop software of my own through
writing software
programs but don't know how to do it, i would like you to
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm using
LOOL! This *IS* a joke right? ;)
- Original Message -
From: lateef ayinla [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 22, 2002 2:13 AM
Subject: request
Dear sir,
i come across yourmanual [mySQL Reference] when browsing
through the
SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB?
How can I find these rogue queries and optimise them? I could increase the
FYI...
Yes, I created a new field called 'd_now' with data inserted as
(TO_DAYS(NOW()), updated it to include the proper date format for all
the old records and of course then had to paste in the old timestamp
values that automatically updated when I did that update... lots of fun
on 2800
I have written menu-1.13.tar.gz
and
menu-1.13.tar.bz2 for download at:
http://www.hurontel.on.ca/~barryp
This program will help the user with SQL and the handling of mysql
reserve words. You can rename fields or columns or tables from a menu. The
program `menu.pl' keeps track of all
At the present time I am using Mandrake 9.0 and installed the MySql
programmes that con the three disks:
MySQL-3.23.52-1mdk.i586.rpm*
MySQL-bench-3.23.52-1mdk.i586.rpm*
MySQL-client-3.23.52-1mdk.i586.rpm*
MySQL-Max-3.23.52-1mdk.i586.rpm
#mysql_install_db has been run. The last time I did this
if it's not you have probably just shamed him into never turning his computer
on again.
Quoting Chris Knipe [EMAIL PROTECTED]:
LOOL! This *IS* a joke right? ;)
- Original Message -
From: lateef ayinla [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 22,
Hi!
I was interested in the answer to this person's question, too!
The following response:
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
seems to lack detail in answering the question, which might be phrased when
might indices start making
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 22, 2002 2:12 AM
Subject: Re: request
If it is not, his computer should probably not have been on to begin with.
:)
- Mark
if it's not you have probably just shamed him into never turning his
- Original Message -
From: wcb [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Sunday, December 22, 2002 2:23 AM
Subject: Re: How long is my piece of string?
Hi!
I was interested in the answer to this person's question, too!
The following response:
You need indexes as soon as
Sure. Indices increase the time it takes to add or update a record.
They also take up disk space.
Also when scanning a database, its quicker ot just read the data records
directly than to use an index if most of the data records need to be
read anyway. For example, if you had a table with 10,000
wcb wrote:
seems to lack detail in answering the question, which might be phrased when
might indices start making a performance difference?.
newbie to indexing talk
Well, I'm no wizard or anything, but have just spent the last twos days
on this subject here on my project. Anyway, waht I have
When configuring mysql-4.0.5a-beta I found that if I were to configure
as follows:
CFLAGS=-O3 -mpentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti ./configure
--prefix=/usr/local/mysql --enable-assembler
--with-mysqld-ldflags=-all-static --disable-shared
At the present time I am using Mandrake 9.0 and installed the MySql
programmes that con the three disks:
MySQL-3.23.52-1mdk.i586.rpm*
MySQL-bench-3.23.52-1mdk.i586.rpm*
MySQL-client-3.23.52-1mdk.i586.rpm*
MySQL-Max-3.23.52-1mdk.i586.rpm
#mysql_install_db has been run. The last time I did this
What would be the SQL query to return every Nth row in a result set? So
it would return the 5th row, the 10th row, the 15th row, etc. Thanks for
any and all replies!
seems like it would be easier to
write a perl script
#repeated SQL selects
$count=0;
$sth = $dbh-prepare(qq(select * from table LIMIT ?,?));
while ($sth){
$sth-execute($count,1);
$ref =$sth-fetchrow_arrayref();
print FILEHANDLE my item is $ref-[0],$ref-[1]...etc\n;
$count+=5;
}
#or use modulo
Dear Spamsucks86,
With Mysql 4.0.x I think you are limited to either performing the
algorithm at the client side as James suggested or using temporary tables
and mysql variables at the server side.
create table test (var int);
insert into test values
We have set up mysql on a linux webserver running apache at our college for
students. We can create users at the site and log in to databases from a
number of user ID's however when I try this from a dial up using sqlyog I
always get the error message connection lost with mysql during query. have
70 matches
Mail list logo