r u not able to create tables of type=INNODB.
On 5/7/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> What ever you have written i did the same thing, Yet innodb get disabled,
>
>
> On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <[EMAIL PROTECTED]>
> wrote:
>
> > If you ju
Hi,
What ever you have written i did the same thing, Yet innodb get disabled,
On Tue, May 6, 2008 at 11:24 AM, Rolando Edwards <[EMAIL PROTECTED]>
wrote:
> If you just created the /data/mysql folder and moved the ib* files to that
> folder from /var/lib/mysql, you may have to contend with the i
Hi,
Currently error log file is empty. What else can be the reason for disable
innodb.
On Tue, May 6, 2008 at 9:11 AM, Juan Eduardo Moreno <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Can you send the error log file of mysql server in your machine?.
>
> Regards,
> Juan
>
>
> On 5/6/08, Krishna Chandra
Hi
The query is not optimized as it is scanning 45048 rows.
Vertical partitioning can be used because there is a lot of column in single
table.
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit qui
Hi,
Currently there is no way but there is a WorkLog for implementing such
a feature,
It may be possible to encourage someone to implement such a feature
request.
Regards,
Antony.
On 6 May 2008, at 14:58, Bryan Cantwell wrote:
Is there no way to step thru a stored proc in order to de
Is there no way to step thru a stored proc in order to debug it and see
what it is doing?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
As a note. The query itself may not be taking long but there are many
"Sorting result " and "Copying to tmp table " in myTop.
Thanks,
Michael
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]> wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit q
Hi.
The main table for our site is called properties and it gets hit quite
often (several times per second) something like:
Queries Total: 41,496 Avg/Sec: 6.89 Slow: 0
Cache Hits : 15,096 Avg/Sec: 2.51 Now/Sec: 0.00 Ratio: 36.38%
Threads Total: 1 Active: 1 Cach
This may be a bit off topic, but useful nonetheless. I've released a web site
dedicated to security issues only, and it has not only useful links but roll
marquees displaying all of the latest patch/threat/virus/vulnerability issues.
It's intended as a "one stop" url for all of the security news
I have a table from which I need to calculate the percentage growth of
downloads from specific countries over two distinct periods of time.
Calculating the total downloads from a country over one period of time is not
difficult:
SELECT country, SUM(total_dl) AS q3_total FROM show_history WHER
Hi Michael,
Try placing the following at the top of your PHP code:
ini_set('error_reporting', E_ALL | E_STRICT);
ini_set('display_errors', 'On');
What error messages do you see on your page?
On Tue, May 6, 2008 at 12:07 PM, Jerry Schwartz <[EMAIL PROTECTED]>
wrote:
> In general, if I have a P
In general, if I have a PHP-generated page that produces a blank page, I
execute the PHP code from the command line. It will probably fall over dead
somewhere along the line, but you'll know if there are any syntax errors.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
19
On 6 May 2008, at 15:39, Michael Condon wrote:
I have a PHP script that seems to be failing. I execute it using
window.location.href("http://www.vote.com/vote2.php";):
$result = mysql_query("update election set Votes = Votes + 1 where
Name='TheGuy'");
if (!$result) {
$message = 'Invalid up
If you just created the /data/mysql folder and moved the ib* files to that
folder from /var/lib/mysql, you may have to contend with the internal data
dictionary with ibdata1.
You do the following:
1) Put the mysql data back into /var/lib/mysql
2) Configure my.cnf to set datadir=/var/lib/mysql
3
Hi.
try this
or this
regards
On Tue, May 6, 2008 at 4:39 PM, Michael Condon <[EMAIL PROTECTED]>
wrote:
> I have a PHP script that seems to be failing. I execute it using
> window.location.href("http://www.vote.com/vote2.php";):
>
> $link = mysql_connect('localhost', 'login', 'password');
>
I have a PHP script that seems to be failing. I execute it using
window.location.href("http://www.vote.com/vote2.php";):
$result = mysql_query("update election set Votes = Votes + 1 where
Name='TheGuy'");
if (!$result) {
$message = 'Invalid update: ' . mysql_error() . "\n";
$message .= '
Hi,
Please, you must set up the log-bin for enable replication :
Example ( in your my.cnf )
--log-bin=mysqld-bin
The mysql signal 4 error appear when you install erroneus your environment.
I recommed reinstall your MySQL in your OS.
Regards,
Juan
On 5/6/08, Kaushal Shriyan <[EMAIL PROTECTED]>
Hi
I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I
see the below information in the mysqld.err file
##
06 6:30:13 [Warni
Hi,
Can you send the error log file of mysql server in your machine?.
Regards,
Juan
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Juan,
>
> I have verified directory permissions, its shown below.
>
> linux76:~# ls -l /data/mysql/
> total 535088
> drwx-- 2 mysql mysq
Hi Juan,
I have verified directory permissions, its shown below.
linux76:~# ls -l /data/mysql/
total 535088
drwx-- 2 mysql mysql 20480 2008-05-04 23:44 dip
-rw-rw 1 mysql mysql 10485760 2007-12-23 01:21 ibdata1
-rw-rw 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile0
-rw-rw---
Hi all,
Apologies if this isn't the correct list but I couldn't see a more
suitable one.
I have 4 tables. t1 and t3 are a many to many relationship and use t2
as link table. t3 has many t4.
What I want to do is insert a new row into t3 for each row in t1. I
then want to add the correspo
Hi,
The InnoDB engine was disable because some ib_log files or Ibdata files,
InnoDB canĀ“t read. In some cases, could be a directory permissions or some
error in creation of ib_logfiles when database is started. If you want , try
to see in the error log file generated in order to see more details.
U also need innodb tables?.
As you have myisam as ur default, SHOW STATUS is showing it correctly.
regards
anandkl
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> hi
>
> I want MYISAM to be the default storage engine.
>
>
> On Tue, May 6, 2008 at 4:42 AM, Ananda Kumar <[EMAI
hi
I want MYISAM to be the default storage engine.
On Tue, May 6, 2008 at 4:42 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> looks like your mn.cnf has this commented
>
> #set default_storage_engine=InnoDB
>
> Can u please uncomment it, if u want INNODB as ur default storage engine.
>
> On 5/6/
looks like your mn.cnf has this commented
#set default_storage_engine=InnoDB
Can u please uncomment it, if u want INNODB as ur default storage engine.
On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I have change the data directory from /var/lib/mysql to /data/mys
Hi,
this Thursday, Stewart Smith will give a MySQL University session:
http://forge.mysql.com/wiki/Getting_Started_Using_NDB
Please register for this session by filling in your name on the session
Wiki page. Registering is not required but appreciated. That Wiki page
also contains a section to
Hi all,
select ucp.payment_id, ucp.payment_service_id, cps.payment_service_amount,
ucp.coupon, ucp.payment_order_id, cps.definition,
state
FROM user_delivery_payment ucp, delivery_payment_service cps, user_info
ui, course c
WHERE ucp.payment_order_id is not null and date_format(ucp.payment_dat
Hi all,
I have change the data directory from /var/lib/mysql to /data/mysql
directory and adding innodb_file_per_table. By doing this innodb storage
engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is it's adding
will enable or not
HOW CAN I ENABLE INNODB
mysql> show engines;
+-
28 matches
Mail list logo