Jonathan Chong wrote:
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB
Am Montag, 2. Januar 2006 10:08 schrieb [EMAIL PROTECTED]:
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please click on
the following link:
http://lists.mysql.com/u/mysql/43b8eda9e876b6f0/tommi=tntnet.org
This confirmation serves two purposes.
Not sure what you mean by 'using MySQL to query your installed modules', sorry.
phpinfo() called from a HTML document is one way, but from a command
line level, you can do this is you have the php CLI installed:
PHP: php -m
Perl: If you want to test if a specific module is installed, a way is:
Yes, and from database and table level too, but you must revoke GRANT
OPTION seperately from all other privs like this:
REVOKE GRANT OPTION ON database.tableFROM user
GRANT and REVOKE are essential to your database security, I would
think twice before adding a layer on top of them. There is
Hi,
I have a web app where I am doing a boolean search. I only want
to return 10 results per page, but I'd also like to know how many total
rows match the search query. I'm currently performing this with 2
query statements:
1. (To get the actual rows via the search)
--- 维斯 苏 [EMAIL PROTECTED]写道:
just use phpmyadmin 2.5* because the 2.6* default
use utf8,what you need to do is dump out your old
mysql in sql form, use phpmyadmin 2.5* to redeploy
it on 4.1*. That is it.
I don't have control over phpmyadmin version because
it is on a shared hosting plan.
Hank wrote:
Don't you want the queries to be outer join and not left join?
??? A left join IS an outer join.
PB
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005
--
MySQL General Mailing
Mike,
I ended up using a subselect and that found the missing rows.
I'm not sure why the left join didn't work. I've been using them
for years to find missing rows in tables.
I think that suggests one of the indexes was munged.
PB
mos wrote:
At 08:33 PM 1/1/2006, Hank wrote:
Don't you
On 02.01.2006 13:41 (+0100), Imran Chaudhry wrote:
GRANT and REVOKE are essential to your database security, I would
think twice before adding a layer on top of them. There is potential
for error and you dont want that where security is related. It is
probably worth the pain of learning the
one of my table columns is unique. i mean cant av duplicate contents. How do
i remove this?
ALTER TABLE db.table DROP INDEX nameOfTheIndex;
If you don't know nameOfTheIndex use:
Show create table db.table
Regards!
-Mensaje original-
De: Yemi Obembe [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 02 de Enero de 2006 10:03 a.m.
Para: mysql@lists.mysql.com
Asunto: Alter table
Hi all,
I have a weird problem with MySQL 4.1 on a Debian stable system.
My application uses alot of 'INSERT DELAYED' and 'UPDATE LOW_PRIORITY'
statements and every now and then a SQL statement (not a specific one)
terminates with an error named 'Server shutdown in progress'.
The Server is
Hi,
As I know that MySQL supports stored procedure from 5.0. Does anyone have
the info on if there is any plan to support anonymous PL/SQL block in MySQL
in later MySQL version? So that when port Oracle anonymous PL/SQL block, it
doesn't need to change to procedure/function?
Thanks,
Jenny
Hi,
You can do:
select sql_calc_found_rows [and here follow the rest of the select query];
And then you can get the number of all found rows, not only those got by
limit 10 as follows:
select found_rows();
Teddy
From: Grant Giddens [EMAIL PROTECTED]
Hi,
I have a web app where I am
I have these two tables: 'registration_and attendance' and 'schedules'
They both share a common class_id field. I'm trying to write a Trigger
which will set the class_id field for 'registration_and attendance'
equal to the schedules.class_id matching the
registration_and_attendance.schedule_id
Hi john,
When did you start getting this error message?
There aren't any trouble with MyIsam tables?
Danny
Brittingham, John wrote:
They are InnoDB and max_write_lock_count=4294967295.
The same thing happens when I create a copy of the table.
-Original Message-
From: Danny Stolle
Hi John,
I have looked around a bit and you might be interested in this part:
InnoDB: Do not intentionally crash mysqld if the buffer pool is
exhausted by the lock table; return error 1206 instead ...
check this link: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-8.html
it is quite
Ezhilarasan Sammandam [EMAIL PROTECTED] wrote on 12/30/2005 08:53:36
AM:
Hi,
Is there any compiler to Compile Embedded SQL Macros into source codes
for MySql?
In otherwords, what is the equivalent of PRO*C (in Oracle) in MySql?
Thanks,
Ezhilarasan
STORED PROCEDURES and FUNCTIONS are
Trying to migrate to MySql 5 from Sybase asa. I have a tables that have
column values that are calculated based on other columns in the table. How can
I accomplish the same in MySql?
Here is sample of my asa table:
CREATE TABLE DBA.OpptyDetail
(
OpptyDetailID
numeric(40,0)
NOT
My MySQL databases are stored in a directory that is with the rest of my
project. I am using rsync to back up the entire project, including the
database files. I'd much rather do it this way than to create files with
mysqldump. Whenever MySQL creates a new database, the file is owned by the
Bryan Cantwell wrote:
Trying to migrate to MySql 5 from Sybase asa. I have a tables that
have column values that are calculated based on other columns in the
table. How can I accomplish the same in MySql?
This sounds a job for a trigger - an insert trigger.
I haven't used triggers in mysql,
Hi all, Im sure the Online HTML mysql reference manual is something built by
mysql specifly to handle the manual.
(the one found at http://dev.mysql.com/doc/refman/5.0/en/index.html )
Does anyone know of any open source programs for creating your own online
manuals like the MySQL Reference
On 1/2/06, JJ [EMAIL PROTECTED] wrote:
Is there an easy way to drop all (MyISAM) tables of a MySQL 3.23 database
besides deleting it and then recreating an empty database?
Read up on mysqldump. For 3.23, something like the following should
do the trick:
mysqldump databasename --add-drop-table
Hi Hal,
You might like to try setting the umask for the mysql user. I would
think the server would abide by the OS rules for permission settings.
You may be able to set the UMASK_DIR environment variable (as described
here http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html).
At 16:42 -0500 1/2/06, Andrew stolarz wrote:
Hi all, Im sure the Online HTML mysql reference manual is something built by
mysql specifly to handle the manual.
(the one found at http://dev.mysql.com/doc/refman/5.0/en/index.html )
Does anyone know of any open source programs for creating your own
Hi, I'm sorry to post this here, but I don't seem to be getting any response
on the Suse lists, so here it goes: Could anybody tell me if there are rpms
out there for updating my MySQL server to the latest version? Thank you, and
reply off list if you could.
--
MySQL General Mailing List
Hello,
I'm stuck with a rapidly decreasing amount of available disk space and
a requirement to keep a lid on the size of our databases. We're
using MySQL 4.1.12 as bundled with RHEL ES 4. We do a lot of
transactions keeping short term track of webserver sessions, which
we don't need to
You can stop the auto-growth of your ibdata1 file, and add additional
ibdata files (as needed) on different disks/partitions. However, you
cannot currently shrink the file without some work..
Check out the MySQL documentation for innodb_data_file_path (that is the
config setting that you
Hi there i am looking for an alternative gui app than navicat for osx.
Ive used CocoaMysql in the past and is limited in terms of
administration, however has more working features than navicat ever
does.
I assumed this product was pretty good, however after purchasing boy
was i wrong. I
HI Carl,
The ibdata file growth can be stopped by removing the autoextend
keyword in the my.cnf file.
In your my.cnf file the entry might be
innodb_data_file_path = ibdata1:256M:autoextend
If you want to stop the growth of that file and add another file then this
is what you want
Hi I need some optimization help.
I currently have this query SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch
31 matches
Mail list logo
