 | | | MySQL General | | > pgpool is a connection pool server for PostgreSQL. pgpool runs between
> PostgreSQL 's clients(front ends) and servers(back ends).
>
> Well there are a few solutions out there.
>
> The first comparabPhilip Hallstrom wrote
...
> > 6) When it comes to scaling MySQL and the use of load-balancing what
> > do you
> > feel is a technology that is missing that the MySQL community should
> > create?
> > (I.Philip Hallstrom wrote
...
> > 6) When it comes to scaling MySQL and the use of load-balancing what
> > do you
> > feel is a technology that is missing that the MySQL community should
> > create?
> > (I.Hi Naufal
Naufal Sheikh wrote
> Hello list.
>
>
> Inorder to do some maintainance I will be shutting down my production
> server running mysql4.1. I have already prepared a backup server which iHello list.
Inorder to do some maintainance I will be shutting down my production
server running mysql4.1. I have already prepared a backup server which is
running mysql4 and have imported the curr > 1) Do you use a load-balancer for your MySQL Deployment?
Yes. Well up till just a little while ago...
> 2) What load-balancer (product name) do you use for your MySQL Deployment?
We used to run
Permit me to query the users on this list to ask a few questions on if and how
they scale their MySQL with the use of load-balancers.
I am only expecting very short answers but you may choose to a
> What 's your question?
Heh yah that might be important...
Has anyone experienced this? Does it look like anything in the my.cnf
could be altered to alleviate or assist me in diagnosing the probleWhat 's your question?
Max Thayer wrote
> We are experiencing a certain anomaly here on our db server. The
> problem had occurred about 3 weeks ago.
> We ran diagnostics on the hardware over a 48+hoWe are experiencing a certain anomaly here on our db server. The
problem had occurred about 3 weeks ago.
We ran diagnostics on the hardware over a 48+hour period with no
failures or indications of pr > Just a thought (I 'm certainly no wondows guy) but perhaps your
> setting for the TMP directory would be respected if you used the DOS
> format path with the backslash..
>
> tmpdir C \temp
> vs.
> tRegarding this issue I have found that by rebooting the computer
these problems have gone away (for now). I have a feeling that
this was a subtle permission/ownership problem. Some of the
databases buenas tardes espero que al recibir este mail se encuentre bien de salud todos . El motivo por el cual les envio este mail es porque mysql que estoy instalando en solaris 10 marca errores cuando estoHello everyone hopefully a quick question is there a functional
difference between the various text field sizes other than size? For
example if I wanted to could I run a FULLTEXT index against a LonHi
When i try
"SELECT * id FROM <table > "
all is fine.
But if i want the "* " at the end (because the table is large)
i try
"SELECT id * FROM <table > "
and got
You have an error in youups typo ...
Sebastian Mendel schrieb
> Hi
>
> how can i find the real/valid name for current active db?
>
> Windows lower_case_table_names 2
>
> CREATE DATABASE `UPPERCASE`
> USE `UPPERCASMySQL users
Sorry for spamming mysql@(protected) but you may be interested in
my blog entry that complements our MySQL 5.1.22 announcement.
The Real Thing in HTML is on http //www.planetmysqlHi
how can i find the real/valid name for current active db?
Windows lower_case_table_names 2
CREATE DATABASE `UPPERCASE`
USE `UPPERCASE`
SELECT DATABASE()
// `UPPERCASE`
but working with tI need to find records in a table that may be duplicate records.
The table stores basic information about the Users. I want to do a
match on the FName and LName fields. The query I have looks likeRunning this statement on the master should do it
DROP TABLE table1 table2...
That will remove the tables.
Baron
Ratheesh K J wrote
> Hello all
>
> I cannot afford to stop my slave server. IHello all
I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affectiYup! That 's THE ONE!
Thanks Rajesh.
-afan
Rajesh Mehrotra wrote
> Hi
>
> I think "GROUP_CONCAT " will do it.
>
> -Raj.
>
>
>
> -----Original Message-----
> From afan pasalic [mailto afan@(protected)[snip]
Is there any way to use ORDER BY in such a way as to have it ignore
words such as "the " "a " "an " and the like?
[/snip]
I haven 't tested this but you might be able to do it with a little REGHi
I think "GROUP_CONCAT " will do it.
-Raj.
-----Original Message-----
From afan pasalic [mailto afan@(protected)]
Sent Tuesday October 16 2007 11 49 AM
To mysql@(protected)
Subject how tIs there any way to use ORDER BY in such a way as to have it ignore
words such as "the " "a " "an " and the like?
brian
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysqhi
I have "standard " organizations table with org_id name address
city ... columns.
CREATE TABLE `organization` (
`organization_id` int(8) unsigned NOT NULL default '0 '
`address_id` int(8) This is more of a philosophical issue than anything but it has jumped
up to bite us so I thought I 'd make others aware
Since NULL has no value they can be entered multiply times into unique
columnsHi William
William Newton wrote
> Hello List
>
> I have this table that has a single row in it
>
> CREATE TABLE `quicktable` (
> `x` int(11) NOT NULL auto_increment
> `quick_id` int(11) NOHello List
I have this table that has a single row in it
CREATE TABLE `quicktable` (
`x` int(11) NOT NULL auto_increment
`quick_id` int(11) NOT NULL default '0 '
PRIMARY KEY (`x`)
) ENGINEHi
James Graham wrote
> Hi List
>
> We have a transactions table (~600k records). I 'm trying a simple update
> query it fails.
> I thought this could be due to a reserved word problem but all n |
|
|
