Hi,
I need a procedure that will allow me to take an online (i.e. database
up) Netapp Snapshot of a large InnoDB-based database. Could someone
please confirm that this is a valid way of making a Snapshot:
* Issue a "flush tables with read lock;"
* Issue a "flush logs;"
* Create the Snapshot
* Iss
Hello mysql,
>> i've got a strange problem with concat() function
>>
>> i have the following data structure:
>>
>> CREATE TABLE table1 (
>> field1 int(11) NOT NULL auto_increment,
>> PRIMARY KEY (field1)
>> ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
>>
>> CREATE TABLE table2
mysqladmin processlist
On Jul 26, 2005, at 5:21 PM, Joeffrey Betita wrote:
hello
what command should i type to see all the user connected to
the database.
thank you very much.
Rich Allen
Dare & Do
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> I am trying to find documentation on how to use the new Distributed
> Transactions (XA) feature without going through a JDBC driver. According
> to a Webinar I just reviewed, the XA protocols are "available in the SQL
> la
hello
what command should i type to see all the user connected to the
database.
thank you very much.
rgds,
Joeffrey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm using a boolean query to perform an exact match on musicians within a text
field. However, if the musician's name contains a quote, I get inaccurate
results. For example, this query works fine:
select * from feeds where MATCH(feed_title, feed_content) AGAINST('"Tom Petty"'
IN BOOLEAN MODE)
Michael Monashev <[EMAIL PROTECTED]> wrote on 07/26/2005 04:41:28 PM:
> Hello,
>
> How to optimize != statement?
>
> SELECT * FROM table1 WHERE char_255_column != '';
>
> How to fast select all rows, where CHAR(255) NOT NULL column not
> empty?
>
>
>
> Sincerely,
> Michael,
You could
When I try to install
MySQL-server-4.1.13-0.glibc23.ia64.rpm
MySQL-Max-4.1.13-0.glibc23.ia64.rpm
MySQL-devel-4.1.13-0.glibc23.ia64.rpm
MySQL-debuginfo-4.1.13-0.glibc23.ia64.rpm
MySQL-client-4.1.13-0.glibc23.ia64.rpm
MySQL-bench-4.1.13-0.glibc23.ia64.rpm
I get lots of messages like this:
Error: Mi
Hello,
How to optimize != statement?
SELECT * FROM table1 WHERE char_255_column != '';
How to fast select all rows, where CHAR(255) NOT NULL column not
empty?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
Hi,
Look at having :
having count(*) > 3 for example
Mathias
Selon Pupeno <[EMAIL PROTECTED]>:
> I have esentially this query (the list of integers may differ):
>
> SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans` JOIN
> `TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan
[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: test
ERROR 2013 (HY000): Lost connection to MySQL server during query
bu
Thanks!
Jeff
> -Original Message-
> From: Jason Pyeron [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 26, 2005 3:03 PM
> To: mysql@lists.mysql.com
> Subject: Re: Mysql-shared-compat for 4.13
>
>
>
> you can find what you need here:
>
> http://public.pdinc.us/rpms/mysql
>
> please
Tim Holmes wrote:
>> Hello.
>>
>> You could find the clues in the error log. See:
>>
>> http://dev.mysql.com/doc/mysql/en/error-log.html
>>
>> Good Afternoon:
>>
>>
>>> I have rebuilt by web / database server from bare metal this morning.
>>> The computer is running Fedora Core 3, and is ful
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email the list with questions and comments
-Jason Pyeron
On Tue, 26 Jul 2005, Jeff wrote:
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to upgrade t
Pupeno <[EMAIL PROTECTED]> wrote on 07/26/2005 03:53:10 PM:
> I have esentially this query (the list of integers may differ):
>
> SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans`
JOIN
> `TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE
> `TechsPerPlan`.`id` IN (
I am trying to find documentation on how to use the new Distributed
Transactions (XA) feature without going through a JDBC driver. According
to a Webinar I just reviewed, the XA protocols are "available in the SQL
layer" but I am having the hardest time finding documentation on how to
initiate,
I have esentially this query (the list of integers may differ):
SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans` JOIN
`TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE
`TechsPerPlan`.`id` IN (17, 48, 54, 64, 75, 13, 30, 37, 45, 55, 65, 76, 11,
33, 46, 58, 68, 80)
Hello list,
I'm having some mysterious problems when I try to migrate several
databases from one server to another one. This
databases contain some InnoDB tables - db size is around ~3GB. On both
servers I'm using MySQL version 4.1.12,
the same kernel version, same libc (2.3.2), but different a
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to upgrade to mysql 4.1.13
(MySQL-server-standard-4.1.13-0.rhel3.i386.rpm) and I'm getting the
usual errors of required dependencies because I need the shared-compat
package.
Problem is
Michael Stassen wrote:
Sort of. The order of requirements in the WHERE clause is irrelevant.
...
No composite index will be fully used here. MySQL uses composite
indexes from left to right, *stopping on the first key part used in a
range* rather than to match a constant. "WHERE latitude >
Sorry to disturb you, i have resolved my problem by using other mysql headers!
Selon [EMAIL PROTECTED]:
>
>
> Hi all,
>
> i try to use the C API but i get a segmentation fault...
>
> my code looks like :
>
> MYSQL mysql;
> if( ! mysql_init(&mysql) )
>exit(0);
> if( ! mysql_real_connect(&mysql
[EMAIL PROTECTED] wrote:
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2 varch
Hi all,
i try to use the C API but i get a segmentation fault...
my code looks like :
MYSQL mysql;
if( ! mysql_init(&mysql) )
exit(0);
if( ! mysql_real_connect(&mysql,"localhost","user","xxx","",3306,NULL,0) )
exit(0);
if( mysql_select_db(&mysql, nomBdd) != 0 )
exit(0);
mysql_query(&m
On Jul 26, 2005, at 3:56 AM, Marvin Wright wrote:
Regarding the file size issue, we are on a 32-bit system running
redhat AS3,
we already have idb files in excess of 21Gb, I'm not sure what the
limit is
though if any ?
No, typically a 32 bit file system would have limits like 2G or 4G...
Hi Joerg,
From: "Joerg Bruehe"
> Jigal van Hemert wrote:
> > 050726 14:13:12 mysqld started
> > 050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of
> > InnoDB: memory with malloc! Total allocated memory
> > InnoDB: by InnoDB 78086952 bytes. Operating system errno: 12
> On my machi
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2 varchar(255) NOT NULL default ''
Hi Jigal!
Jigal van Hemert wrote:
[[...]]
After a while he needed to restart MySQL (made some changes somewhere) and
it refused to do so:
050726 14:13:12 mysqld started
050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB
I recomend to you FabForce DBDesigner 4.x with this tool you can do "Reverse
Engineering" to a database in oracle, and then once created a model, export
sql to mysql and that's it!
I have made this to some databases in oracle, is really easy do it!
Saludos!
-Original Message-
From: Nguye
Christos Andronis wrote:
Hi all,
we are trying to run the following query on a table that contains over 600 million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running for over 10 hours now).
Hi Catalin,
Here are some InnoDB performance tuning tips that may boost
your insert speed:
Catalin Trifu wrote:
...
innodb_buffer_pool_size = 256M
Higher is better, in fact pushing this up to 60%-80% on a
dedicated database would be good. If there are other things
running like a web server,
Nguyen, Phong wrote:
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
You can try our Migration Toolkit which has pretty good support
for Oracle now...
http://www.mysql.com/products/migration-toolk
Hi all,
We're trying to get a new 64-bit machine going to get around the memory
limitations of the 32-bit machines we have. On this dual Opteron server with
8GB memory we've installed Fedora Core 4 and MySQL 4.1.13.
Our sysadmin configured MySQL to use a 7GB buffer pool to accomodate a few
big ta
Hi,
> I have scripts to create constraints, sequences, storage..., tables from
> ORACLE and I don't know if I can create them in MySQL?
MySQL doesn't have "sequences" or "storage" specifiers.
You cannot run your script directly.
Depending on your current Oracle structure, you might want to give
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
Appreciated your help,
Thank you,
Phong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
THe MySQL packages was not well installed. I remove the packages and
re-install them after, the file "/ect/sysconfig/mysql" appears, and after
modifications, everything works well.
Thanks.
On Tuesday 26 July 2005 10:09, Pascal Francq wrote:
> Since I make an install, Mandrake has hold the old "/
Hi Bruce,
Thanks again for your advice.
I have control over the client access so it a possibility to do what Heikki
is suggesting, additionally I have to do it to a master and slave, I could
always try it on one and if it fails then go down the dump and import route,
this way I wouldn't lose data
Since I make an install, Mandrake has hold the old "/etc/init.d/mysql" script
(rather than "/usr/init.d/mysqld") and the file in "/ect/sysconfig/mysql" was
not created.
On Tuesday 26 July 2005 09:56, Joshua J. Kugler wrote:
> http://qa.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNot
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Subject: Re: Phone Number Storage
>From: "Sujay Koduri"
>> I guess anywhere we have 3 levels of hierarchies for a phone number.
>> (Country code, Area code and the actual number).
>
>That's a pretty wild guess IMHO. You
See the release notes:
http://qa.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNotes#MySQL
j- k-
On Monday 25 July 2005 23:43, Pascal Francq said something like:
> I made an upgrade from Mandrake 10.1 to 10.2. Since, I cannot connect
> anymore to the database locally using '12
I made an upgrade from Mandrake 10.1 to 10.2. Since, I cannot connect anymore
to the database locally using '127.0.0.1':
[EMAIL PROTECTED] sysconfig]# mysql -u root -h 127.0.0.1
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
I suppose that something has changed concernin
From: "Sujay Koduri"
> I guess anywhere we have 3 levels of hierarchies for a phone number.
> (Country code, Area code and the actual number).
That's a pretty wild guess IMHO. You have to be absolutely sure that this is
true for each and every country in the world. Furthermore, various telecom
pr
41 matches
Mail list logo
