2006/1/25, Nathan Gross [EMAIL PROTECTED]:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
If you have a linux box (or any acceptable shell)
cat query.log | grep
Aye. -v. thanks!
-nat
On 1/26/06, Pooly [EMAIL PROTECTED] wrote:
2006/1/25, Nathan Gross [EMAIL PROTECTED]:
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
I'm trying to change a couple of replace statements to
insert...on duplicate key update (using Perl/DBI).
foreach my $key (keys %e_items) {
my $sql = insert table1
(id, date, time, uid, type, seq, value)
values
(?, ?, ?, ?, ?, ?, ?)
on
I recently changed all my ibd files to MYISAM. Can I safely remove the
ibdata file and restart mysql?
Thanks;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
I'm not a MyODBC expert and not completely sure if it is your case, but
it seems that there're several bugs similar to your. See:
http://bugs.mysql.com/bug.php?id=10148
You can find more by searching on the 'SQLDescribeCol' keyword in the
bugs database. Check that you're using the
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Shaun [EMAIL PROTECTED] wrote on 01/23/2006 11:51:32 AM:
Hi,
We have a dataset of uk postcodes and their relevant X-Coordinates and
Y-Coordinates, a table of properties (houses), a table of users and a
table
of offices - users
Hello.
Before removing the ibd files, add skip-innodb to your configuration
file, restart the server and check if your applications still work fine.
Nathan Gross wrote:
I recently changed all my ibd files to MYISAM. Can I safely remove the
ibdata file and restart mysql?
Thanks;
-nat
--
Hello.
Please, execute the following statements in mysql command line and php,
and provide its output to the list:
show variables like '%char%';
show variables like '%collation%';
Include the CREATE statement for your table as well.
Chris wrote:
I think I have a problem with mysql
Hello.
Perhaps you have forgotten to add col_name=expr to the end of your
query. See:
http://dev.mysql.com/doc/refman/5.0/en/insert.html
Jonathan Mangin wrote:
I'm trying to change a couple of replace statements to
insert...on duplicate key update (using Perl/DBI).
foreach my $key (keys
as somebody in the list already pointed out it all depends on the
amount of RAM you have , the formula has been taken from Jeremy's book
, high performance Mysql
Expressed mathematically, that is:
min_memory_needed = global_buffers + (thread_buffers * max_connections)
where thread_buffers
Hi MySql,
Would it be possible to have the PK tables on hardisk-A and FK tables on
hardisk-B using only one database?
to envision:
CUSTOMER_MYSQL_DB
CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B]
-Melvin
-
Bring words and
Melvin Zamora wrote:
Hi MySql,
Would it be possible to have the PK tables on hardisk-A and FK tables on
hardisk-B using only one database?
to envision:
CUSTOMER_MYSQL_DB
CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B]
-Melvin
Moeller, Thorsten, AO wrote:
Hi,
is there a possibility to collect the sql statements issued to a mysql
db to analyse them??
perhaps there is an extra tool or script for this??
Thanks for any suggestions!
I don't know about collecting all queries, but we're doing this in
our my.cnf
I've determined that I need to set SQL_BIG_SELECTS=1 for an application
I have which connects to a MySQL 4.x database. However, I don't see how
to apply it universally to that application's connection. Is it
something I need to put in the connection string? Something I need to
put in each
David P. Donahue [EMAIL PROTECTED] wrote on 01/26/2006 02:19:25 PM:
I've determined that I need to set SQL_BIG_SELECTS=1 for an application
I have which connects to a MySQL 4.x database. However, I don't see how
to apply it universally to that application's connection. Is it
something I
How to specify that option depends entirely on how you are forming your
connection with the MySQL server. Which connection library are you using
and how are you opening your connection?
The application is an ASP .NET web app hosted on Mono on an Apache web
server running Linux. My data
At 1:07 pm -0500 26/1/06, JamesDR wrote:
You can do it symlinks (see the manual for this info.)
Just in case you are tempted to try _without_ reading the manual, this is only
supported for MyISAM tables with MySQL versions = 4.
http://dev.mysql.com/doc/refman/4.1/en/symbolic-links-to-tables.html
Sorry, I am unable to work the command line. I have used this script
instead.
$sql = show variables like '%char%';
$result = mysql_query($sql) or die(Couldn't Select .mysql_error());
$count = mysql_num_rows($result);
//echo $count;
while ($row = mysql_fetch_row($result)) foreach($row as
Amigos me llegó este mail, quiza les sea de ayuda.
Jorge Paiva
Lima - Peru
MySQL 5.0 - Nuevas funcionalidades para la Empresa
Miércoles 1 de Febrero de 2006
MySQL les invita a participar en el primer webinar en
castellano para España y
In general, I try to stay away from very large IN(..) lists because I
have seen them regularly degrade performance, but in this case the
alternative that I have found doesn't seem to perform any faster. Could
anyone give me some insight as to which of the following queries is
better (and why)
Thank to Mike give the result about the third question.
But the first and second question not answer.
The first question related to the function of mysql-administrator's
subassembly.A picture about this question in the accessories.
http://forums.mysql.com/read.php?34,61375,61375#msg-61375
The
Hi All,
Iam using tomcat 5x and mysql5.x the proble is when i try to connect mysql
and tomcat using j/connector 3.x tomcat throws error as access denied to [EMAIL
PROTECTED] host using password 'YES'.
Please help me to overcome this problem.
Thanks in advance
sankar
22 matches
Mail list logo
