Hello Meir,
Before taking your money, let's try some free help.
Since modern Linux distributions support installation of Linux+MySQL
out of the box in reasonably standard hardware, could you tell us about
your environment and whether there is anything nonstandard in it:
1. Which
Hi Everyone!
I am looking for such (paid) help since I encountered problems in
installing such!
The idea is to come over to my place (Or-Aqiva) and do it on premises.
Knowledge of Grub 2.0 is also required...
Best regards,
Meir Guttman
Cell. +972-54-526 2264
___
Hi,
I think I found the problem according to
https://serverfault.com/questions/325171/debian-mysql-error-running-shared-postrotate-script-for-var-log-mysql-log
:
My password for user debian-sys-maint was not correct. I updated the
password with:
update user set authentication_string=password
Hi,
I installed a new Ubuntu 18.04 server with mysql, and I receive the
following error by email daily:
*Cron test -x /usr/sbin/anacron || ( cd / && run-parts --report
/etc/cron.daily )/etc/cron.daily/logrotate:error: error running shared
postrotate script for '/var/log/mysql
Hi Shimi and Erez,
On Wed, Mar 23, 2016 at 12:53 PM, shimi wrote:
>
>
> On Wed, Mar 23, 2016 at 9:22 AM, Erez D wrote:
>
>> hi
>>
>> i have a running mysql server, and want to be able to restore it to any
>> day, with as little backup space as needed
>>
On Wed, Mar 23, 2016 at 9:22 AM, Erez D wrote:
> hi
>
> i have a running mysql server, and want to be able to restore it to any
> day, with as little backup space as needed
>
> i do mysqldump to the same file every day then commit the file with "svn
> ci"
>
check mysqlbinlog
#
:כתב Erez D, 2016-03-23 09:22 בתאריך
> hi
>
> i have a running mysql server, and want to be able to restore it to any day,
> with as little backup space as needed
>
> i do mysqldump to the same file every day then commit the file with "svn ci&
On Wed, 23 Mar 2016 09:22:06 +0200
Erez D wrote:
> hi
>
> i have a running mysql server, and want to be able to restore it to any
> day, with as little backup space as needed
>
> i do mysqldump to the same file every day then commit the file with "svn ci"
> t
You can try to switch to BUP https://bup.github.io/
This is GIT based backup system, works fine in small scale scenarios.
It works OK with big files cause of chunk deduplication.
On Wed, Mar 23, 2016 at 9:22 AM, Erez D wrote:
> hi
>
> i have a running mysql server, and want to b
hi
i have a running mysql server, and want to be able to restore it to any
day, with as little backup space as needed
i do mysqldump to the same file every day then commit the file with "svn ci"
the idea is that if there are no changes, it takes no space
it works well if i just appe
which approach you take you would need to find the
appropriate server side technology to interact with a MySQL
generated event.
--
David Suna
da...@davidsconsultants.com
___
Linux-il mailing list
Linux-il@cs.huji.ac.il
http://mailman.cs.huji
te, and
once every X amount of time try to update them directly if a timestamp at
the db was changed.
> If they are different clients (as in agents), then there are other tools
>> at your disposal, such as Varnish, that create cached version for the web.
>>
> still neab client nee
things, but it is still polling, which i try to avoid
> If they are different clients (as in agents), then there are other tools
> at your disposal, such as Varnish, that create cached version for the web.
>
still neab client need to poll the server
>
> Secondly, the MySQL/MariaDB
o display things from a
> mysql database which is updated from time to time.
> however. this meens a lot of un-needed acesses to the database. and this
> refresshing page may be openede by many browsers. causing a huge load on
> the database.
>
> i know mysql supports triggers, but it
eries involved in rendering the
full page (use AJAX/jQuery/YUI/etc. to refresh only a small part of
the page).
You can and should also use prepared statements/stored procedures to
help speed up queries.
As far as OSS solution goes MySQL/MariaDB still outstrip PG in
performance by factor 10 at
the web.
Secondly, the MySQL/MariaDB triggers really basics if you compare them to
PG and Fb (true open source solutions), not to mention non open source
databases such as SQL Server and Oracle.
Third, try to see how you can optimize the page. If there is no need for
constant data reading, why does
hello
i have a web page that refreshes all the time to display things from a
mysql database which is updated from time to time.
however. this meens a lot of un-needed acesses to the database. and this
refresshing page may be openede by many browsers. causing a huge load on
the database.
i know
phpstorm. not free (as in beer and speech), but amazing and worth any $
you pay.
you can download 30 days trial from: http://www.jetbrains.com/phpstorm/
Barak
On 2 December 2012 12:18, Erez D wrote:
>
> another short question:
> anybody knows of a good PHP IDE (on linux of course) ?
ould be supported for years.
>
> We need to access mysql via php
> currently i seem to preffer PDO as it supports not only mysql but many
> other DBs.
>
> searching the net, i see many comparisons of mysql vs mysqli vs pdo.
> they compare functionality
>
> however, i am tr
he same set of
interfaces/functions).
HTH,
Eliyahu - אליהו
2012/12/2 Lior Kaplan :
> Hi Erez,
>
> From PHP 5.4 the default for all the mysql extensions family is mysqlnd (PHP
> native mysql driver), and it seems that for the next PHP release (5.5)
> ext/mysql will be deprecated https://w
Hi Erez,
>From PHP 5.4 the default for all the mysql extensions family is mysqlnd
(PHP native mysql driver), and it seems that for the next PHP release (5.5)
ext/mysql will be deprecated https://wiki.php.net/rfc/mysql_deprecation
So PDO is probably the right answer.
Kaplan
On Sun, Dec 2, 2
Hello,
We are starting a new project, one that will be used for production and
should be supported for years.
We need to access mysql via php
currently i seem to preffer PDO as it supports not only mysql but many
other DBs.
searching the net, i see many comparisons of mysql vs mysqli vs pdo
on etc
>> due to shortage or RAM and/or CPU power.
>>
>> Lets say I have a machine with 512GB RAM, 20 cores, 20TB disks. Such a
>> machine should handle a huge load without any issue. With such a machine,
>> theoretically, can a single MySQL / PostgreSQL handle such a l
ge load without any issue. With such a machine,
> theoretically, can a single MySQL / PostgreSQL handle such a load? (few
> hundred thousands connected users at once).
>
>
>
It really depends on *what* you do, like has been said, ACID consideration,
and of course, the ratio between read/write oper
On 23 August 2011 12:01, guy keren wrote:
> did you first try to isolate what is causing your troubles? i.e. is it
> indeed related to disk wait times? or the CPUs choke? or perhaps it's a
> RAM problem? it's not always simple to know where the bottleneck is, and
> if you fix it - how soon until
etc due to shortage or RAM and/or CPU power.
>
>
> Lets say I have a machine with 512GB RAM, 20 cores, 20TB
> disks. Such a machine should handle a huge load without any
> issue. With such a machine, theoretically, can a single
> MySQL / PostgreSQL handle suc
ge load without any issue. With such a machine,
> theoretically, can a single MySQL / PostgreSQL handle such a load? (few
> hundred thousands connected users at once).
>
I can't answer these specific questions directly. We have a chubby (2TB
right now, and growing) PostgresQL database on Hita
0TB disks. Such a
> machine should handle a huge load without any issue. With such a
> machine, theoretically, can a single MySQL / PostgreSQL handle such a
> load? (few hundred thousands connected users at once).
>
Please note that there is a difference between the CPU and number of
c
to memory? processor? I know that many uses replication etc
due to shortage or RAM and/or CPU power.
Lets say I have a machine with 512GB RAM, 20 cores, 20TB disks. Such a
machine should handle a huge load without any issue. With such a machine,
theoretically, can a single MySQL / PostgreSQL han
OK, I fixed phpmyadmin by changing to 'cookie' authentication mode. It
worked. But I got this message: "Cannot load mcrypt extension. Please
check your PHP configuration.". I installed mcrypt with "apt-get
install php5-mcrypt" and "/etc/init.d/apache2 restart", but now I get
the phpmyadmin login pa
On Fri, Mar 4, 2011 at 21:55, Geoff Shang wrote:
> On Fri, 4 Mar 2011, Uri Even-Chen wrote:
>
> OK, I setup file /etc/apache2/sites-available/default , but it's still
>> not working. I can't log into /admin , and
>> http://www.speedy2000.net/uri/en is "Not Found / The requested URL
>> /uri/en wa
On Fri, 4 Mar 2011, Uri Even-Chen wrote:
OK, I setup file /etc/apache2/sites-available/default , but it's still
not working. I can't log into /admin , and
http://www.speedy2000.net/uri/en is "Not Found / The requested URL
/uri/en was not found on this server.". I used
http://www.htmlite.com/HTA0
There is another problem - we installed phpmyadmin under /admin
directory, and now it requires 2 usernames and passwords - one for
/admin and one for phpmyadmin. Even if I enter both usernames and
passwords - it doesn't work. Any solution?
Uri Even-Chen
Mobile Phone: +972-50-9007559
E-mail: u...@s
Oops. I found a bug and fixed it. I replaced "require admin" with "require
user admin" and it works now. I still have a problem with the second problem
- http://www.speedy2000.net/uri/en not working.
Uri Even-Chen
Mobile Phone: +972-50-9007559
E-mail: u...@speedy.net
Website: http://www.speedy.net
OK, I setup file /etc/apache2/sites-available/default , but it's still
not working. I can't log into /admin , and
http://www.speedy2000.net/uri/en is "Not Found / The requested URL
/uri/en was not found on this server.". I used
http://www.htmlite.com/HTA006a.php to create admin password (without
sa
On Fri, Mar 4, 2011 at 17:03, ik wrote:
> You should use AllowOverride option in the directory settings to be All
> rather then none on not existed at all.
>
> Thank you. Actually I saw
http://httpd.apache.org/docs/2.0/howto/htaccess.html , and found out that
it's not recommended to use .htaccess
server on www.speedy2000.net , it uses Ubuntu
> 10.04 LTS with apache2, PHP and MySQL. The problem is, currently apache
> ignores .htaccess files. I have 2 .htaccess files, one to protect a
> directory with username & password and one to redirect to another domain.
> Here are the
Hi everyone,
1. I installed a new cloud server on www.speedy2000.net , it uses Ubuntu
10.04 LTS with apache2, PHP and MySQL. The problem is, currently apache
ignores .htaccess files. I have 2 .htaccess files, one to protect a
directory with username & password and one to redirect to ano
rs and here's the solution:
postfix kept complaining the socket was not there but it is. finally I
saw that one example listed the map setting in main.cf thus:
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf
rather than:
virtual_alias_maps = mysql:/etc/postfix/mysql_vir
Uri Evenhen More wrote:
Hi Friends,
I am hosting my website on Servage.net, where I don't get SSH access.
I need to run mysqldump in order to backup my mysql database to SQL
format (I need the backup in SQL format). Is there a way to run
mysqldump without using SSH access? Does phpmy
e:
> Hi Friends,
>
> I am hosting my website on Servage.net, where I don't get SSH access.
> I need to run mysqldump in order to backup my mysql database to SQL
> format (I need the backup in SQL format). Is there a way to run
> mysqldump without using SSH access? Does phpmyad
Hi. have you tried using the -h switch?
mysqldump -h x.x.x.x
should let you connect to the mysql server on IP x.x.x.x but dump it
locally.
good luck,
Mike
Uri Evenhen More wrote:
Hi Friends,
I am hosting my website on Servage.net, where I don't get SSH access.
I need to run mysqldu
n Sun, Nov 30, 2008 at 9:03 PM, Uri Evenhen More <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> I am hosting my website on Servage.net, where I don't get SSH access.
> I need to run mysqldump in order to backup my mysql database to SQL
> format (I need the backup in SQL
Hi Friends,
I am hosting my website on Servage.net, where I don't get SSH access.
I need to run mysqldump in order to backup my mysql database to SQL
format (I need the backup in SQL format). Is there a way to run
mysqldump without using SSH access? Does phpmyadmin support this?
They also
On Sun, Nov 23, 2008 at 4:44 PM, Moshe Teutsch <[EMAIL PROTECTED]> wrote:
> I'm having a problem INSERTing Hebrew text into a MySQL database.
> Whenever I try to do it through my PHP application the fields that contain
> Hebrew text end up blank. The collation for
On Sunday, 23 November 2008 16:44:34 Moshe Teutsch wrote:
> I'm having a problem INSERTing Hebrew text into a MySQL database. Whenever
> I try to do it through my PHP application the fields that contain Hebrew
> text end up blank. The collation for the Hebrew fields is *utf8_general
I'm having a problem INSERTing Hebrew text into a MySQL database. Whenever
I try to do it through my PHP application the fields that contain Hebrew
text end up blank. The collation for the Hebrew fields is *utf8_general_ci.
*I have very little experience with Hebrew in PHP and MySQL applica
Hi friends,
I need help with somebody with shell access. I need to upload a whole
database from files, and then create a mysql dump of the entire
database. Anybody can help?
Thanks a lot,
Uri Evenhen More (Ore)
Mobile Phone: +972-50-9007559
E-mail: [EMAIL PROTECTED]
Blog: http
g product we originally had)
>> to Virtual-IP (using Linux Virtual Server) we see how MySQL
>> master-master replication (using simple two-sided replication, e.g.
>> http://www.howtoforge.com/mysql-5-master-master-replication-fedora-8,
>> NOT the "MySQL Cluster" product
"Amos Shapira" <[EMAIL PROTECTED]> writes:
> BUT now that we are finally moving from DNS-based fail-over (due to
> lack of Virtual IP support in the hosting product we originally had)
> to Virtual-IP (using Linux Virtual Server) we see how MySQL
> master-master replica
e days).
>
> Well, how about a couple of hours, including RTFM? LinuxHA (heartbeat,
> http://www.linux-ha.org) + DRBD (http://www.drbd.org,
> http://linux-ha.org/DRBD) is the most common linux HA solution, works
> great with MySQL (http://www.mysql.com/products/enterprise/drbd.html),
>
Hi,
Hi tech college are looking for an instructor for a MySQL course.
If you know MySQL installation, administration and optimization inside
out, have training experience and interested let me know.
Thanks,
Gilad
--
Gilad Ben-Yossef
Chief Coffee Drinker
Codefidence Ltd.
The code is
On Dec 12, 2007 2:03 AM, Oded Arbel <[EMAIL PROTECTED]> wrote:
>
> On Tue, 2007-12-11 at 18:00 +0200, ik wrote:
> > Hello List,
> >
> > I have a weird problem with the above server using MySQL (4.1):
>
> You need to provide more information about MySQL - what
On Tue, 2007-12-11 at 18:00 +0200, ik wrote:
> Hello List,
>
> I have a weird problem with the above server using MySQL (4.1):
You need to provide more information about MySQL - what engine your
tables are using, any replication or clustering taking place, etc'.
> 1. Some t
Hello List,
I have a weird problem with the above server using MySQL (4.1):
1. Some tables on specific database are loosing the Auto Inc pointer,
making it start from 0 every time there is a restart to the server
itself.
2. It seems that the MySQL server have a big delay (of a minute and
tood from all the documentation I found
about this).
Hell I would get away with zero nodes and a Nissan Patrol in Kakadu
National park if it was up to me :-)[1].
Let's just cut the lawer-speak, shell we?
Anyway, right now it looks like I'll pass the MySQL cluster and try to
go with the &
ractical*
minimum is obviously 2.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Yonah Russ
Sent: Tuesday, November 20, 2007 7:26 PM
To: Imri Zvik
Cc: linux-il@cs.huji.ac.il
Subject: Re: MySQL Cluster for HA? What about PostgresQL PGCluster?
I believe the original inqu
a < [EMAIL PROTECTED]> wrote:
> > >
> > > >
> > > > On 20/11/2007, Yonah Russ <[EMAIL PROTECTED]> wrote:
> > > > > Hi,
> > ..snip..
> > > >
> > > > Another point which was just raised in the office - it appea
uss <[EMAIL PROTECTED]> wrote:
> > > > Hi,
> ..snip..
> > >
> > > Another point which was just raised in the office - it appears that we
> > > are going to use DRBD for SQLite synchronization - if so then it
> > > should make sense to use DRBD for MySQL sync
I believe the original inquiry was regarding HA - Less than three nodes does
not have any HA benefits AFAIK.
yonah
On Nov 20, 2007 10:36 AM, Imri Zvik <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The MySQL cluster can run perfectly on one physical node.
>
> The 3 nodes you're r
answer is no
- you can technically use 1 physical node. The fact it doesn't provide
any redundancy is not MySQL specific, but true to any cluster of any
kind :)
You are also correct about the indexes. As far as I can remember there
is a script that analyzes existing databases and reports the
On 20/11/2007, Yonah Russ <[EMAIL PROTECTED]> wrote:
> On Nov 20, 2007 7:32 AM, Amos Shapira <[EMAIL PROTECTED]> wrote:
>
> >
> > On 20/11/2007, Yonah Russ <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > AFAIK MySQL cluster requir
Hi,
You're very much correct about the nodes & HA - but that wasn't the
question - The question was if 3 nodes are a must - and the answer is no
- you can technically use 1 physical node. The fact it doesn't provide
any redundancy is not MySQL specific, but true to any
On 20/11/2007, Imri Zvik <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The MySQL cluster can run perfectly on one physical node.
>
> The 3 nodes you're referring to are at least 1 management node, and at
> least 1 API ("mysqld") node, and at least 1 data/storage (&qu
Imri Zvik wrote:
Hi,
The MySQL cluster can run perfectly on one physical node.
The 3 nodes you're referring to are at least 1 management node, and at
least 1 API ("mysqld") node, and at least 1 data/storage ("ndbd") node.
They can all reside on the same physical node
Hi,
The MySQL cluster can run perfectly on one physical node.
The 3 nodes you're referring to are at least 1 management node, and at
least 1 API ("mysqld") node, and at least 1 data/storage ("ndbd") node.
They can all reside on the same physical node.
The main issue w
On Nov 20, 2007 7:32 AM, Amos Shapira <[EMAIL PROTECTED]> wrote:
> On 20/11/2007, Yonah Russ <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > AFAIK MySQL cluster requires using the NDB engine which is not 100%
> > compatible with MYISAM, etc. The more recent a ve
On 20/11/2007, Yonah Russ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> AFAIK MySQL cluster requires using the NDB engine which is not 100%
> compatible with MYISAM, etc. The more recent a version you have the better
> off you will be but there was one point where autoincrement wa
Hi,
AFAIK MySQL cluster requires using the NDB engine which is not 100%
compatible with MYISAM, etc. The more recent a version you have the better
off you will be but there was one point where autoincrement wasn't even
supported. Also from what I know, a NDB cluster needs at least three
Hello,
We are looking at enhancing one of our servers, which runs CentOS 5 on
amd64, for HA using Linux Virtual Servers (LVS). The server runs a web
site using MySQL 5.0.22 and of course we'll need to replicate that on
the second server as well.
Is MySQL Cluster the right solution for us
rently it is stuck with records from yesterday at noon and
> nothing new is coming in (I currently think its only one that has
> problems, but I haven't checked all of them). Other tables are getting
> updates just fine.
The problem was - as usual - RTFM. The MySQL "replicate-re
Hi list.
I'm (possibly) having a problem with a MySQL replication setup, where
replication works well except for one table that doesn't get new rows at
all.
I'm using a moderately complex replication setup where a remote server
is a master to a server running on the local lan and
vid Suna wrote:
> While this is not directly linux related it is FOSS related.
>
>
> I have a MySQL 5 database that has fields with Hebrew values. The
> fields are defined as varchar with a hebrew_general_ci collation. I
> have a PHP page that takes values specified in a form fi
You've chosen a ISO-8859-8 (logical or visual play no role here) encoding
for the MySQL tables. Do you know which encoding your PHP pages accept the
form data in? (And why for heaven's sake somebody developing an app in 2007
doesn't use UTF-8 everywhere?)
On 5/10/07, David Suna &l
While this is not directly linux related it is FOSS related.
I have a MySQL 5 database that has fields with Hebrew values. The
fields are defined as varchar with a hebrew_general_ci collation. I
have a PHP page that takes values specified in a form field and runs a
query against the table
On Fri, 23 Mar 2007, Shlomi Fish wrote:
Seriously now - what can we do to get rid of the fact that a single
architecture controlls most of the market, and it sucks. Here's what. Why
is the x86 problem? That's why:
There is no 'x86' problem. There is a marketing/market driven spiral
called 'th
On Thu, 22 Mar 2007, Tzahi Fadida wrote:
Listen, i did not suggest to map 1024 bits, i was using your example.
What you are talking about is PCI and other buses. On the same 32bit address
bus you can address many data buses using bridges, which is exactly what i
said from the beginning and yes,
On Thursday 22 March 2007 17:45, Peter wrote:
> On Thu, 22 Mar 2007, Tzahi Fadida wrote:
> > On Thursday 22 March 2007 16:18, Peter wrote:
> >> On Thu, 22 Mar 2007, Tzahi Fadida wrote:
> >>> Advocating is a strong word, i was suggesting. How exactly would you
> >>> address 128gb,256gb? Unless of co
On Thu, 22 Mar 2007, Tzahi Fadida wrote:
On Thursday 22 March 2007 16:18, Peter wrote:
On Thu, 22 Mar 2007, Tzahi Fadida wrote:
Advocating is a strong word, i was suggesting. How exactly would you
address 128gb,256gb? Unless of course your system board and CPU
supports such sizes...
The boa
On Thu, 22 Mar 2007, Tzahi Fadida wrote:
Advocating is a strong word, i was suggesting. How exactly would you
address 128gb,256gb? Unless of course your system board and CPU
supports such sizes...
The board does not care about sizes. Disk requests are serialized and
they can be any lengths.
On Thursday 22 March 2007 16:18, Peter wrote:
> On Thu, 22 Mar 2007, Tzahi Fadida wrote:
> > Advocating is a strong word, i was suggesting. How exactly would you
> > address 128gb,256gb? Unless of course your system board and CPU
> > supports such sizes...
>
> The board does not care about sizes. D
On Thu, 22 Mar 2007, guy keren wrote:
Peter wrote:
Afaik the fastest servers (including Google and many others) do not use SQL
for anything. An optimized hash table (tiered etc) should work much better
than any SQL.
funny you should mention google - because all their computers that run the
On Thursday 22 March 2007 14:58, Peter wrote:
> On Thu, 22 Mar 2007, Tzahi Fadida wrote:
> > Perhaps some kind of a hardware solution can be used. I.e. attaching a
> > pci with memory and addressing it's 64gb memory either directly (if you
> > have 64 bit bus) or in two phases. It can also be any R
Geoff - when it will be _you_ who manage to run a multi-billion company,
and not google, i'll listen to you, rather then look at what they did.
the fact is - there are ways to use cheap hardware to get a reliable,
scaleable and maintainable service. i only wanted to bring a
counter-example t
On Thu, 22 Mar 2007, Tzahi Fadida wrote:
Perhaps some kind of a hardware solution can be used. I.e. attaching a pci
with memory and addressing it's 64gb memory either directly (if you have 64
bit bus) or in two phases. It can also be any RAM space size you choose, but
it will cost you (each add
On Thu, Mar 22, 2007 at 02:03:51PM +0200, guy keren wrote:
> they use a replicating file-system + lots of communicatoins redundancy +
> monitoring software + lots of technicians and spare parts, to get the
> reliability they want.
I see two problems with that. One is that the average technician
Peter wrote:
Afaik the fastest servers (including Google and many others) do not use
SQL for anything. An optimized hash table (tiered etc) should work much
better than any SQL.
funny you should mention google - because all their computers that run
the google sites, are no-name 1U and 2U
On Thursday 22 March 2007 11:49, Muli Ben-Yehuda wrote:
> On Thu, Mar 22, 2007 at 11:46:36AM +0200, Tzahi Fadida wrote:
> > > With PAE you can stick in a lot more RAM on x86-32, but then your
> > > bottleneck becomes the 3GB of virtual address space for a single
> > > process.
> >
> > Perhaps some
On Thu, Mar 22, 2007 at 11:46:36AM +0200, Tzahi Fadida wrote:
> > With PAE you can stick in a lot more RAM on x86-32, but then your
> > bottleneck becomes the 3GB of virtual address space for a single
> > process.
>
> Perhaps some kind of a hardware solution can be used. I.e. attaching
> a pci wi
On Thursday 22 March 2007 11:25, Muli Ben-Yehuda wrote:
> On Thu, Mar 22, 2007 at 10:55:11AM +0200, Peter wrote:
> > I am not an expert on this, but any algorithm that runs in O(1) or
> > close to that for the data size you use is a candidate. The data
> > size should be obviously less than 2^32 fo
On Thu, Mar 22, 2007 at 11:14:47AM +0200, Nadav Har'El wrote:
> Reminds me of a group in my workplace whose abbreviated name is "STD".
> Unfortunately, when I found out about it, and told them what "STD" means
> to the typical American, it was too late to change the group's name.
Or an Israeli co
On Thu, Mar 22, 2007 at 10:55:11AM +0200, Peter wrote:
> 64-bit x86 and up. F.ex. 30 million records will require less than 7
> bits per entry just to keep a complete linear index in 3GB of RAM (the
> maximum usable you can put in a x86 32 bit machine). 7 bits is not
> enough to even make 30 mi
On Thu, Mar 22, 2007 at 10:55:11AM +0200, Peter wrote:
> I am not an expert on this, but any algorithm that runs in O(1) or
> close to that for the data size you use is a candidate. The data
> size should be obviously less than 2^32 for x86 at least in any
> indexable dimension if you want a reaso
On Thu, Mar 22, 2007, Peter wrote about "Re: Blooming Filters (was: Re: [Job]
MySQL consultation)":
> The 'Blooming' name was an unfortunate choice. The people who came up
> with that are Israelis I think. Try to find their other academic work
> and trace them, and
On Thu, 22 Mar 2007, Omer Zak wrote:
On Thu, 2007-03-22 at 00:20 +0200, Peter wrote:
You also
probably want to read up on more advanced indexing methods (like Bloom
and Blooming filters and such) than what's available with ordinary off
the shelf databases.
I searched for information about B
On Thursday 22 March 2007, Peter wrote:
> I am not an expert in database servers but I know 2 or 3 things about
> 'commodity' PC hardware. If you want to build a server by saving money
> on hardware, don't.
>
> Go and buy a 2nd hand AS/400 and put Linux (or *BSD) on one of its
> images and that's s
On Thu, 2007-03-22 at 00:20 +0200, Peter wrote:
> You also
> probably want to read up on more advanced indexing methods (like Bloom
> and Blooming filters and such) than what's available with ordinary off
> the shelf databases.
I searched for information about Blooming filters.
Google gave me
People, you also need to take into account that MYSQL is a pile of
when dealing with complex queries. The problem there as i saw it can also be a
db optimizer problem. I would recommend trying it on PostgreSQL.
and doing "explain analyze" on this query. I have a feeling it woul
By the way, for example on how NOT to do SQL & web programming see the
white pages service at fwd.pulver.net or the search in Skype. Both of
these have well under a million records usually and it takes minutes to
hours to get answers. At least Skype starts displaying as soon as there
is data.
On Wed, 21 Mar 2007, Geoffrey S. Mendelson wrote:
With 30 million records in a database, I would seriously consider
a different hardware platform. Some of the perform quite well with
Linux some do not.
30 million records is not a lot. But it is too much if one expects to
write things like SE
1 - 100 of 392 matches
Mail list logo
