2014-02-12 12:32 GMT+01:00 Lukas Lehner :
> Hi Antonio
>
> all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
> it will be fast 80GB.
>
Depending on how your application is going to use MySQL resources you will
need to tweak some things (and not only MySQL).
If it is goin
Hi Lukas,
In that case, such as Adarsh has said, you can configure until 70% of your
RAM for innodb_buffer_pool_size.
In your case, with 3GB RAM, I suggest you to configure until 2GB for MySQL:
Minimal for MyISAM (Maybe 32MB), and the rest for InnoDB. Your problem will
be loading data. Maybe your
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma wrote:
> Is it a standalone DB server or Application is also hosted on top of it.
>
> You can give 50-70% of RAM to memory parameters like
> Innodb_buffer_pool_size ( Innodb )
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
thanks
On Wed, Feb 12, 2014 at 10:28 AM, Antonio Fernández Pérez <
antoniofernan...@fabergames.com> wrote:
> Hi Lukas,
>
> What is your default engine? In MySQL there are a lot of param
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Innodb_buffer_pool_size ( Innodb ) and key_cache ( Myisam ) for mysql
tables.
Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief
idea.
Thanks
Hi Lukas,
What is your default engine? In MySQL there are a lot of parameters that
configure the engine behaviour. Depends on the engine, I suggest you to add
some parameters or others.
Also it's important to know the size of your data. Your configuration is
minimal and by default is not optimal.
Hi
We will use a Java application which uses Hibernate for DB calls. The
vendor didn't made recommendations howto configure MySQL. The application
is not yet in production.
MySQL is new to me, I previously used Oracle DB. The vendor provided a
guide howto configure Oracle.
This is our my.conf
$
";
>> >
>> > When I query the server for a list of databases with the code above it
>> > returns the name of just two and there are over 10.
>> >
>> > Any ideas?
>>
>> Permissions - the user you're logging in as probably only has
&g
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
> RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
> #my $dbh =
I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell
> On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina
> wrote:
> > use DBI;
> > my $dbh = DBI->conn
use DBI;
my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
RaiseError => 3 } );
my $dbs = $dbh->selectcol_arrayref("show databases");
#my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
#my $dbh = DBI->connect($dsn, $usrr, $passw);
my $dbs = $dbh->selectcol_arrayr
@str;
execute stmt;
deallocate prepare stmt;
-Original Message-
From: Girish Talluru [mailto:girish.dev1...@gmail.com]
Sent: Tuesday, February 12, 2013 1:37 AM
To: mysql@lists.mysql.com
Subject: Please check the stored procedure
DROP PROCEDURE IF EXISTS Cursor_Test;# MyS
lists.mysql.com
> Subject: Re: Fwd: Query take too long time - please help!
>
> On 10.07.2012 13:16, Darek Maciera wrote:
> > 2012/7/10 Ananda Kumar :
> >> can u show the explain plan for your query
> >>
> >
> > Thanks, for reply!
> >
> >
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar :
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time around. The
query you'
you are using a function-LOWER, which will not make use of the unique key
index on ksd.
Mysql does not support function based index, hence your query is doing a
FULL TABLE scan and taking more time.
On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera wrote:
> 2012/7/10 Ananda Kumar :
> > can u show th
2012/7/10 Ananda Kumar :
> can u show the explain plan for your query
>
Thanks, for reply!
Sure:
mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
++-+-+--+---+--+-+--++-+
| id | se
s in this
> table.
>
> But this SELECT take too long time:
>
> mysql> SELECT * FROM books WHERE ksd ='A309CC47B7';
> 1 row in set (2.59 sec)
>
>
> Table is in InnoDB engine. I added to my.cnf: innodb_buffer_pool_size =
> 512MB
>
> Any suggestions? Help, please..
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
ds in this table.
But this SELECT take too long time:
mysql> SELECT * FROM books WHERE ksd ='A309CC47B7';
1 row in set (2.59 sec)
Table is in InnoDB engine. I added to my.cnf: innodb_buffer_pool_size = 512MB
Any suggestions? Help, please..
--
MySQL General Mailing List
For list arc
Dear Friends,
There has been some problems with my mail box and some spam emails have been
sent to you from my email.
Please do not open the link that was sent to you from my email address!!
Sorry for the problem caused.
Best regards,
Javad Bakhshi,
Computer Science M.Sc
Department of IT
2011/10/24 16:31 -0700, Daevid Vincent
WHERE cs.customer_id = 7
GROUP BY customer_id
Well, the latter line is now redundant.
How will you make the '7' into a parameter?
--
MySQL General Mailing List
For list archives: http://l
October 24, 2011 4:06 PM
> To: mysql@lists.mysql.com
> Subject: RE: Within-group aggregate query help please - customers and
latest
> subscription row
>
> A kind (and shy) soul replied to me off list and suggested this solution,
> however,
> this takes 28 seconds (that's f
-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Monday, October 24, 2011 1:46 PM
> To: mysql@lists.mysql.com
> Subject: Within-group aggregate query help please - customers and latest
> subscription row
>
> I know this is a common problem, and I've been struggling
I know this is a common problem, and I've been struggling with it for a full
day now but I can't get it.
I also tried a few sites for examples:
http://www.artfulsoftware.com/infotree/queries.php#101
http://forums.devarticles.com/general-sql-development-47/select-max-datetime
-problem-10210.html
; Date: Wed, Oct 5, 2011 at 9:48 AM
> > Subject: Re: Slow query - please help
> > To: Johnny Withers
> > Cc: "mysql@lists.mysql.com"
> >
> >
> > I just revised my query and now get the following output :
> >
> > '1', 'PRIMARY&#
t help.
>
> -- Forwarded message --
> From: Tompkins Neil
> Date: Wed, Oct 5, 2011 at 9:48 AM
> Subject: Re: Slow query - please help
> To: Johnny Withers
> Cc: "mysql@lists.mysql.com"
>
>
> I just revised my query and now get the followin
Following my mail below, if anyone can help optimise the query further that
would be a great help.
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers
Cc: "mysql@lists.mysql.com"
I ju
g
where'
After doing this the query speed is acceptable.
Thanks
Neil
On Wed, Oct 5, 2011 at 3:12 AM, Johnny Withers wrote:
> Can you post the explain extended output of your query?
>
> Sent from my iPad
>
> On Oct 4, 2011, at 2:45 PM, Neil Tompkins
> wrote:
>
>
onst',
'267', '100.00', 'Using index condition; Using where'
Thanks
Neil
On Wed, Oct 5, 2011 at 3:12 AM, Johnny Withers wrote:
> Can you post the explain extended output of your query?
>
> Sent from my iPad
>
> On Oct 4, 2011, at 2:45 PM
; To: mark carson
>> Cc: "[MySQL]"
>> Subject: Re: Slow query - please help
>>
>
>> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are
>> below, let me know if you need any more information.
>>
>> CREATE TABLE `districts` (
Can anyone help me ?
Begin forwarded message:
> From: Tompkins Neil
> Date: 30 September 2011 20:23:47 GMT+01:00
> To: mark carson
> Cc: "[MySQL]"
> Subject: Re: Slow query - please help
>
> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitio
ysical Address : 34 Spanish Galliard, Mooikloof, Pretoria, South Africa
> snailmail : P.O. Box 36095 Menlo Park 0102, South Africa
> Tel. +27 12 996 1193/1815 Fax : +27 86 672 7012 Cell : +27 83 260 8515
>
>
> This e-mail may contain PRIVILEGED AND/OR CONFIDENTIAL INFORMATION intend
Hi
I've the following query :
SELECT city_id, name, meta_title, meta_description, meta_keywords,
country_code, link_text, folder_url, enabled, last_changed, nr_hotels,
(SELECT COUNT(hotels.hotel_id) FROM hotels WHERE hotels.city_id =
cities.city_id AND hotels.country_code = 'gb' AND hotels.enable
hi
The message sid this :
Dear,
inform you that your email _ * has not been delivered to the recipient * _
because there is no
mailbox in the domain
A greeting.
I have many problems sending mail , any problem or any ideas?
2011/4/2 Reindl Harald
> Can anybody remove this (i think spanish) a
Can anybody remove this (i think spanish) autoreply-spammer
from the list nbecause the only thing i understand is some
price in € and that our spm-firewall is tagging it
Original-Nachricht
Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1'
(111)
Datum:
I am at the planning stage of building a database that will have a fairly
large amount of different information. It is a DB for law firms, so it will
have all of their contact information including a county. Also an individual
lawyer will be listed. Add to that 2 description areas (one for firm,
On 21.12.2010 11:27 CE(S)T, 杨涛涛 wrote:
> Maybe you should give a password to MySQL's root. And I think this note will
> disappear.
I would be extremely dumb not to set any password on MySQL's root
account at all! Of course (I hope I made that clear before) a password
has been set while installing
Maybe you should give a password to MySQL's root. And I think this note will
disappear.
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
2010/12/17 Yves Goergen
> On 14.12.2010
On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote:
> Are you using ubuntu deb's or mysql bin? Do you get that message when
> the service start? Look init script to see what it does.
I get the message when MySQL is started. I've installed the Ubuntu
standard package mysql-server-5.1. It has alr
On 13.12.2010 15:26 CE(S)T, who.cat wrote:
> try /mysql_bin_path/mysql_secure_installation !
> Hope it helpfu!
I already followed that path and it doesn't quite help. I've done the
checks that the install script does and my installation is secure by
those means. But I don't want to install things
Hi,
I find the following line in my syslog events:
Daemon Error mysqld
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
followed by a whole lot of notes, advice and web links. I do have set a
custom password for root, root is not accessible from remote, the
anonymous user does not
I wondered if anyone can help me ? Do you need any further information ?
Cheers
Neil
-- Forwarded message --
From: Tompkins Neil
Date: Thu, Sep 23, 2010 at 9:49 AM
Subject: Query help please
To: "[MySQL]"
Hi all,
I've the following
Hi all,
I've the following query :
SELECT fixtures_results.seasons_id ,
home_teams_id AS teams_id ,
1 AS home ,0 AS away ,
(SELECT SUM(goals) FROM players_appearances WHERE
fixtures_results.fixtures_results_id =
players_appearances.fixtures_results_id AND players_appearances.teams_id =
home_teams
Nunzio Daveri,
Joerg Bruehe gave you a lot of good tips to try and speed things up.
A few hundred queries per second seem to be a relatively small number to
cause the server to crawl. I don't have the rest of your thread, but can
you publish some of the slow queries (see Slow Query Log) an
Thanks again :-)
Nunzio
From: Joerg Bruehe
To: Nunzio Daveri ; mysQL General List
Sent: Fri, July 30, 2010 1:31:54 PM
Subject: Re: Indexes larger than RAM (was: Do you know who can answer this
question I posted yesterday please?)
Hi!
I am no InnoDB and
Hi!
I am no InnoDB and tuning expert, so I had intended to stay away from
this question. Ok, I'll give some general remarks:
Nunzio Daveri schrieb:
> [[...]]
>
> All, I was running slamdb against one of our QA boxes and noticed that the
> innodb database is 190Gb in size BUT the worrying issu
i said: ignore!
But did it work?
;-)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelo
i said: ignore!
--
hartmut
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> -Original Message-
> From: Nurudin Javeri [mailto:nsjav...@idh.com]
> Sent: Sunday, April 18, 2010 9:25 AM
> To: mysql@lists.mysql.com
> Subject: How to corrupt a database please???
>
> Hi all, I am hiring a few new junior DBA's and I want to put
> th
Rob Wultsch wrote:
On Sun, Apr 18, 2010 at 11:13 AM, Andrés Tello wrote:
What if the DBA ask for the backup?
And those recommendations can be "fixed" or they have a very high chance of
making recovery impossible?
Who is the dba going to ask for a backup? Himself? The guy that puts
backups o
On Sun, Apr 18, 2010 at 11:13 AM, Andrés Tello wrote:
> What if the DBA ask for the backup?
>
> And those recommendations can be "fixed" or they have a very high chance of
> making recovery impossible?
>
Who is the dba going to ask for a backup? Himself? The guy that puts
backups on tape? One way
A couple good tests are.
1. Corrupt a relay log. For this you can stop the sql thread, cat
/dev/urandom over the newest relay log, start the sql thread and watch
it fail.
2. Change the innodb_log_file_size in my.cnf without going through the
proper procedure to remove the old log files. In 5.0 thi
On Sun, Apr 18, 2010 at 11:07 AM, Jim Lyons wrote:
> You can remove the innodb logs and/or the innodb data file. You can also
> remove some of the individual .idb files (if you're using file-per-table
> option).
>
He originally asked about how to provide a training excise about
repairing a db. H
ant to put them thru a
> >> simple db repair training. Does anyone know how I can deliberately
> corrupt
> >> a MyISAM and InnoDB database in different ways please? So what I want
> to do
> >> is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb databases - ALL
g a few new junior DBA's and I want to put them thru a
>> simple db repair training. Does anyone know how I can deliberately corrupt
>> a MyISAM and InnoDB database in different ways please? So what I want to do
>> is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb databases
ru a
> simple db repair training. Does anyone know how I can deliberately corrupt
> a MyISAM and InnoDB database in different ways please? So what I want to do
> is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb databases - ALL WITH
> DIFFERENT ERROR MESSAGES and have these new
ning. Does anyone know how I can deliberately corrupt
> a MyISAM and InnoDB database in different ways please? So what I want to do
> is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb databases - ALL WITH
> DIFFERENT ERROR MESSAGES and have these newbies fix them in a 2 hour period
Hi all, I am hiring a few new junior DBA's and I want to put them thru a
simple db repair training. Does anyone know how I can deliberately
corrupt a MyISAM and InnoDB database in different ways please? So what
I want to do is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb
databases
; mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: RE: Please help me.
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name,
not the key name. Try this
column after that.
From: Valentin Ionescu [colibry...@yahoo.com]
Sent: Wednesday, March 18, 2009 11:27 AM
To: mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: Please help me.
Hi!
My name is Valentin and I am writing to
ried to do like:
alter table documents_ex drop column Journal_ex_ID
or
alter table documents_ex drop foreign key Journal_ex_ID
or
alter table documents_ex drop key Journal_ex_ID
I receive the same error 150 and I don't know what to do.
Please help me.
Best regards.
--
MySQL
ot;C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --console
081004 16:56:01 InnoDB: Started; log sequence number 0 43655
081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were
used; s
o replication may break when this MySQL server acts as a slave and has his
hostn
am
bmisq01.bmi.com', master_user
> = 'repl', master_password = 'repl';
> ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found
> (Errcode: 2)
> mysql>
>
>
>
> -Original Message-----
> From: David Giragosian [mailto:[EMAIL PRO
t;
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote:
>
> you should probably just resync your s
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On
On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote:
>
> you should probably just resync your slave. If it hasn't run for over a
> month then there's not a lot of point in trying to start it up. Even if
> you
> did start the slave (which seems doubtful) you'd have over a month's worth
> of commands t
AL.
>
> If you are not the intended recipient, you are hereby notified
> that any dissemination of this communication is strictly prohibited.
>
> If you have received this communication in error, please erase
> all copies of the message and its attachments and notify us
semination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
--
MySQL General Mailing List
For list archiv
mysql> show global status like '%stmt%';
+-+-+
| Variable_name | Value |
+-+-+
| Com_stmt_close | 4875504 |
| Com_stmt_execute| 4875504 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare| 48
Hi,
for all you people out there loving phpMyAdmin ;-)
please visit http://hackontest.org and vote for or suggest your favorite
feature you would like to see in phpMyAdmin and that can be implemented
within 24 hours by a team of three
Thank you very much!
--
Sebastian Mendel
--
MySQL
ivileges for each IP for each machine that is going to access
the mysql server would be tedious and not recommended choice. Please let
me know.
Regards
Ahmad
-Original Message-
From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:34 PM
To: Ahmadbasha Shaik (W
7; work in the place of IP?, as I feel that
giving privileges for each IP for each machine that is going to access
the mysql server would be tedious and not recommended choice. Please let
me know.
Regards
Ahmad
-Original Message-
From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday
abc.def.com' is not allowed to connect to this
> MySQL server", Please advice..
>
> Hi,
>
> I did that too,
>
> I executed the command -> GRANT ALL PRIVILEGES ON *.* to
> 'root'@'localhost' ;
> I tried also GRANT ALL PRIVILEGES ON *.* to
Hi,
I did that too,
I executed the command -> GRANT ALL PRIVILEGES ON *.* to
'root'@'localhost' ;
I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where
abc.def.com is my machine name
But both of these did not work, I did not ment
Hi All,
I am facing a particular problem which i have explained here. Can
you please let me know a solution for this.
>From my web application, I am trying to connect the MySQL server by
using the IP address as the server name, and it says the following
error:
"Host 'abc.de
hello,
im trying to make a DB for a message system.
the best way i have made is this:
*TABLE conversations* (informacion de cada conversacion)
.
i*d_conversation (bigint)
count(smallint) updated every time a new message is
adde
On Thu, 13 Mar 2008, Roberto Zarate <[EMAIL PROTECTED]> wrote:
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
I did a Google search for "mysql" and the top hit was
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
thx
Roberto Zarate Mendoza
lima-peru
511 9238-4883
On 06.03.2008 15:15 CE(S)T, Paul DuBois wrote:
Here's some advice from Alexander Barkov:
You might be able to use a particular collation to achieve what you want.
For example, latin1_general_ci.
You can take a look at its collation chart here:
http://www.collation-charts.org/mysql60/mysql604.lat
On 03.03.2008 23:17 CE(S)T, Anders Karlsson wrote:
And you are right of course, you may use the COLLATE keyword also,
to enforce a certain collation, although if you want BINARY, I think
using BINARY might be slightly more effective.
I was also considering compatibility with other DBMS. At
Yves!
OK. I agree I don't like this much myself, but we have to live with
the multi-lingual aspect of UNICODE. Or rather, we have to agree to be
either multi-lingual, and have the cons and pros of that (using
UNICODE), or ignore UNICODE and have binary collations etc. And
collation also de
comparison, please!
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
> [a lot about why sorting unicode is complicated]
> If you want to
> accknowledge exact matching, and say any character, accented /
> unlauted etc, is different from any other character, specifiy a binary
comparis
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
> [a lot about why sorting unicode is complicated]
If you want to
accknowledge exact matching, and say any character, accented / unlauted
etc, is different from any other character, specifiy a binary comparison:
SELECT * FROM phonebook WHERE BI
Yves!
This is a complicated matter alright, but it is a complicated
problem to solve here also. Your statement about characters being the
same isn't really correct. To take an example: Let's assume you were
doing a phonebook, in print, of all people in the world. How would you
sort that? A
Hello,
I've just read through the MySQL documentation about Unicode support,
collations and how it affects sorting and comparison of strings. And I
find it horrible, at least. I feel like I'm back in the MySQL 3.x days
where I used UTF-8 in my application and MySQL treated it binary. The
only
Hello
I want to use functions - SetSRID(),Makebox2D(),Distance_Sphere() of
Post GIS in MySQL. Can please let me know the similar functions in
MySQL.
Environment
===
Operating System : Red Hat Linux 3.4
Database :
MySQL Version 5.0.51
PostgreSQL 8.2.6 with PostGIS 1.2.1
Functions
On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote:
> I've found a glaring problem with the latest ODBC connector. Data
> types have been changed and data is no longer being read correctly.
That's not quite correct -- data types are now actually being read
correctly. They were wrong before, e
I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC d
Anders,
>I also want to find out the user's position relative to others
depending on the result.
For a given pUserID, something like this?
SELECT userid,result,rank
FROM (
SELECT o1.userid,o1.result,COUNT(o2.result) AS rank
FROM object o1
JOIN object o2 ON o1.result < o2.result OR (o1.resu
On Dec 11, 2007, at 10:46 AM, Rob Wultsch wrote:
On Dec 11, 2007 8:38 AM, Anders Norrbring <[EMAIL PROTECTED]> wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
On Dec 11, 2007 8:38 AM, Anders Norrbring <[EMAIL PROTECTED]> wrote:
> I'm looking at a situation I haven't run into before, and I'm a bit
> puzzled by it.
>
> I have this table structure:
>
> Table USERS: userid, class
> Table OBJECT: userid, class, result
>
> Now I want to query the database for
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain user's result in a
specified class, which is very, very easy. No proble
- Original Message -
From: "Russell E Glaue" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
>
> The mysql.sock location '/var/lib/mysql/mysql.sock' att
>>> From: Ali Nebi <[EMAIL PROTECTED]>
>>> Sent: Nov 6, 2007 9:24 AM
>>> To: mysql@lists.mysql.com
>>> Subject: Please help to solve a serios problem
>>>
>>> Hi, i need of help for a serios problem.
>>>
>>> We have ins
t runs mysql.
>
>
>
>
> -Original Message-
> >From: Ali Nebi <[EMAIL PROTECTED]>
> >Sent: Nov 6, 2007 9:24 AM
> >To: mysql@lists.mysql.com
> >Subject: Please help to solve a serios problem
> >
> >Hi, i need of help for a serios problem.
> >
> >
6, 2007 9:24 AM
>To: mysql@lists.mysql.com
>Subject: Please help to solve a serios problem
>
>Hi, i need of help for a serios problem.
>
>We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
>5, x86.
>
>Our problem is this.
>We get this message
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
ERROR 2002 (HY0
d] Error 1
make[3]: Leaving directory
`/var/local/repository/src/mysql-5.1.21-beta/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory
`/var/local/repository/src/mysql-5.1.21-beta/sql'
make[1]: *** [all] Error 2
make[1]: Leaving directory
`/var/local/repository/src/mysql-5.
to
`dlclose'
sql_plugin.cc:(.text+0x3916): undefined reference to
`dlclose'
sql_plugin.cc:(.text+0x3a3d): undefined reference to
`dlclose'
collect2: ld returned 1 exit status
make[3]: *** [mysqld] Error 1
make[3]: Leaving directory
`/var/local/repository/src/mysql
[EMAIL PROTECTED] wrote:
Please remove me from this list or tell me how I can do this procedure...
Thanks...
Have you noticed what the footer of each message says?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http
Please remove me from this list or tell me how I can do this procedure...
Thanks...
mail2web.com Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail
1 - 100 of 1527 matches
Mail list logo
